Laravel Fluent add select()s in separate places?

Question

//Earlier in the code, in each Model:
query = ModelName::select('table_name.*')

//Later in the code in a function in a Trait class that is always called

    if ($column == 'group_by')
    {
        $thing_query->groupBy($value);
        $thing_query->select(DB::raw('COUNT('.$value.') as count'));
    }

Is there a way to append or include a separate select function in the eloquent query builder?

The actual ->select() is set earlier and then this function is called. I'd like to add the count column conditionally in this later function that has the query passed into it.

Cameron · Answer 1 · 2015-10-13T01:51:24.973

16

For future reference, you can use the addSelect() function.

It would be good to have in the documentation, but you'll find it here in the API: http://laravel.com/api/4.2/Illuminate/Database/Query/Builder.html#method_addSelect

edited Oct 13 '15 at 01:51

answered Feb 10 '14 at 05:26

Cameron

995
10
16

That link doesn't work for me, this one does: http://laravel.com/api/4.2/Illuminate/Database/Query/Builder.html#method_addSelect – Benubird Jan 28 '15 at 16:05

score 0 · Answer 2 · answered Jun 24 '13 at 21:00

Yeah you just insert the block you wanna execute as a function....according to the documentation on Parameter Grouping , you can do like so...by passing the Where a function...

This code below probably wont do what you want, but, its something for you to build off of, and play around with.

DB::table('users')
        ->where('name', '=', 'John')
        ->orWhere(function($query)
        {
            $query->group_by($value);
                  ->select(DB::raw('COUNT('.$value.') as count'));
        })
        ->get();

score -1 · Answer 3 · edited Apr 20 '16 at 11:23

-1

Try this:

$thing_query->groupBy($value)->get(DB::raw('COUNT('.$value.') as count'));

Also,if you are just trying to get the count and not select multiple things you can use ->count() instead of ->get()

edited Apr 20 '16 at 11:23

Community

1
1

answered Jun 24 '13 at 21:00

coffe4u

538
3
5

That doesn't add the count to my other select queries, just returns it by itself – Damon Jun 25 '13 at 13:01

Laravel Fluent add select()s in separate places?

3 Answers3