CODEWITHSUNDEEP
phplaravellaravel-5
Jaskaran Singh Puri
Jaskaran Singh Puri

Reputation: 739

Laravel not retrieving values from database

I want to retrieve all column values. Following is the dashboard controller code, which runs index method by default

<?php

namespace App\Http\Controllers;

use App\questions;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use App\Http\Requests;

class Dashboard extends Controller
{
    public function __construct()
    {
        $this->middleware('auth');
    }
    public function fetchQuestions() {
        return questions::where('people_id','=',Auth::id())->pluck('question');
    }
    public function index(){
        $listQuestions=$this->fetchQuestions();
        return view('forms.question',compact('listQuestions'));
    }
}

View File

<ul>
@foreach ($listQuestions as $question)
    <li>{{ $question }}</li>
@endforeach
</ul>

It doesn't show any error or any result either

Upvotes: 1

Views: 44

Answers (2)

Timothy Radier
Timothy Radier

Reputation: 335

Add ->all() after pluck

return questions::where('people_id','=',Auth::id())->pluck('question')->all();

Though you can do it in one method:

public function index(){
    $listQuestions=questions::where('people_id','=',Auth::id())->pluck('question')->all();
    return view('forms.question',['listQuestions'=>$listQuestions]);
}

Upvotes: 0

Ronak Dattani
Ronak Dattani

Reputation: 466

Can you try this? 

public function fetchQuestions() {
        return questions::where('people_id','=',\Auth::guard('yourguardname')->user()->id)->get()->pluck('people_id','question');
    }

Upvotes: 1

Related Questions