How do I select multiple columns across tables with Laravel query builder?

Question

I have a Laravel Eloquent query where I am trying to select multiple columns from a MySQL table.

    $query = DB::connection('global')
        ->select(
            'mytable.id',
            'mytable.column1',
            'mytable.another_column',
            'mytable.created_at',
            'myothertable.id
        )
        ->from('mytable')
        ->get();

It looks like the select() function takes three arguments: query, bindings and useReadPdo. The above query gives me an error:

{"error":true,"message":"Type error: Argument 1 passed to Illuminate\\Database\\Connection::prepareBindings() must be of the type array, string given" }

How do I write a select with Laravel query builder for the above columns?

I am structuring the query in this way, because I am looking to have a join across another table like so:

    $query = DB::connection('global')
        ->select(
            'mytable.id',
            'mytable.column1',
            'mytable.another_column',
            'mytable.created_at',
            'myothertable.id
        )
        ->from('mytable')
        ->leftJoin('myothertable', function($join){
           $join->on('mytable.id', '=', 'myothertable.id');
        })
        ->get();

How do I use the select function to grab multiple columns across tables with Eloquent query builder?

This is a complex query across tables with joins so doesn't really lend itself to eloquent — Connor Leech
– Connor Leech, Commented Feb 7, 2018 at 0:12

Prince Lionel N'zi · Accepted Answer · 2018-02-06 23:00:46Z

7

How do I write a select with Laravel query builder for the above columns?

You can do:

$data = DB::table('mytable')
        ->join('myothertable', 'mytable.id', '=', 'myothertable.mytable_id')
        ->select(
            'mytable.id',
            'mytable.column1',
            'mytable.another_column',
            'mytable.created_at',
            'myothertable.id'
        )
        ->get();

You can read the documentations here

edited Feb 6, 2018 at 23:00

answered Feb 6, 2018 at 22:46

Prince Lionel N'zi

2,5882 gold badges14 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

How do I select multiple columns across tables with Laravel query builder?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related