Laravel not retrieving values from database

Question

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

Ronak Dattani · Accepted Answer · 2016-10-19 14:29:40Z

1

Can you try this?

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

edited Oct 19, 2016 at 14:29

answered Oct 19, 2016 at 14:21

Ronak Dattani

4663 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ronak Dattani Over a year ago

@Jaskaran : Sorry I had written first name , instead i rectified it \Auth::guard('yourguardname')->user()->id.

Timothy Radier · Accepted Answer · 2016-10-19 14:40:02Z

0

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]);
}

edited Oct 19, 2016 at 14:40

answered Oct 19, 2016 at 14:20

Timothy Radier

3354 silver badges15 bronze badges

4 Comments

Timothy Radier Over a year ago

what do you get when you dd($listQuestions)

Jaskaran Singh Puri Over a year ago

i get this array:1 [▼ 0 => "ok dere" ] It works, but value doesn't pass or displays on the page

Timothy Radier Over a year ago

remove the compact and replace it with ['listQuestions'=>$listQuestions]

Jaskaran Singh Puri Over a year ago

its throwing error Undefined variable: listQuestions

Collectives™ on Stack Overflow

Laravel not retrieving values from database

2 Answers 2

1 Comment

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related