Problem with select in my controller

Question

Hello, I’m making Join between two table to display the user name in the view, but this giving the following error:

Call to a member function select() on string

My controller:

$postagens = Postagens::all()->sortByDesc('created_at')
    ->join('users','users.id' , '=', 'postagens.usuario' )
    ->select('users.name as nomeusuario')
    ->get();
    return view('index',compact('postagens'));

The view:

@foreach ($postagens as $pubs)
@postagens()
        @slot('titulo')
            {{$pubs['nomePost']}}
        @endslot
    @slot('descricao')
        {{$pubs['descricao']}}
    @endslot
    @slot('dia')
        {{$pubs['created_at']}}
    @endslot

    @slot('id')
        {{$pubs['nomeusuario']}}
    @endslot        
@endpostagens
@endforeach

Answer 1

The function all() is to return a collection of values obtained from your database. So when you declare Postagens::all(), will be returned a collection of all existing records in the configured table.

SELECT * FROM postagens

Note that in your code, you use the method join(), this method belongs to the Query Builder of Laravel, so to use it your code must be that way.

use Illuminate\Support\Facades\DB;

...

$postagens = DB::table('postagens') //Nome da tabela postagens
    ->select('users.name as nomeusuario')
    ->join('users','users.id','=','postagens.usuario')
    ->orderBy('postagens.created_at', 'desc')
    ->get();

To use your model for the query you need to use the Querying Relations of the Eloquent ORM.