Laravel 5.3 Trying to get Property of non-object

Question

good morning! I followed what is said in this tutorial to fill values in a view: https://www.tutorialspoint.com/laravel/retrieve_records.htm

And I did the same scheme on my controller:

public function select_cursos_disciplinas()
{
    $cursos = DB::table('select * from cursos');
    $disciplinas = DB::table('select * from disciplinas');
    return view('cadastros.disciplinas_curso', ['cursos' => $cursos, 'disciplinas' => $disciplinas]);
}

In my view it’s like this:

<select class="form-control">
    <option disabled selected> --- </option>    
    @if ($cursos)
        @foreach ($cursos as $curso)
            <option> {{ $curso->nome }} </option>
        @endforeach
    @endif
</select>

However, it is giving the error "Trying to get Property of non-object". I already researched but I did not find the solution to what I need, because the solution was for only one value, but in my case I want several values.

What should I do to fill my select? Thank you

Answer 1

It turns out that your method is not loading the data into the object. For this you need to apply the method get() at the end of the method table.

As in the example below:

public function select_cursos_disciplinas()
{
    $cursos = DB::table('select * from cursos')->get();
    $disciplinas = DB::table('select * from disciplinas')->get();
    return view('cadastros.disciplinas_curso')
           ->with('cursos', $cursos)
           ->with('disciplinas', $disciplinas);
}

Your foreach on view is right.

Answer 2

I think it’s best to use the Query Builder of Eloquent. Try it this way.

public function select_cursos_disciplinas()
{
    $curso = new Curso();
    $cursos = $curso->all();

    $disciplina = new Disciplina();
    $disciplinas = $disciplina->all();

    return view('cadastros.disciplinas_curso', 
        [
            'cursos' => $cursos, 
            'disciplinas' => $disciplinas
        ]
    );
}