Laravel Union "Call to a member function union() on int"

Question

Error: Call to a member function union() on int

$category = Category::select('name')->count();
$city = City::select('city')->count();
$client = Client::select('name')->count();

$property = Property::select('name')->count()
                    ->union($category)
                    ->union($city)
                    ->union($client)
                    ->get();

dd($property);

The error says it all, you can not call `count()->union($category)` — ArSeN, Jan 23 '21 at 23:54
@ArSeN how should I act in order to get all counts in union? — Illyrian, Jan 24 '21 at 00:03
@codedge "Error: Call to a member function getBindings() on int" `$property=Property::select('name')->union($category)->union($city)->union($client)->count();` — Illyrian, Jan 24 '21 at 00:08

score 2 · Accepted Answer · answered Jan 24 '21 at 02:26

If you just want an array of counts, union won't work for you. Select count(*) from multiple tables

$counts = [
    'city' => City::count(),
    'category' => Category::count(),
    'client' => Client::count(),
    'property' => Property::count(),
];

There's no need to keep it in one query.

Laravel Union "Call to a member function union() on int"

1 Answers1