Laravel query count raw

Laravel join

$users = DB::table('users')
            ->join('contacts', 'users.id', '=', 'contacts.user_id')
            ->join('orders', 'users.id', '=', 'orders.user_id')
            ->select('users.*', 'contacts.phone', 'orders.price')
            ->get();

Source: laravel.com

Laravel query count raw

DB::table('users')
	->select('users.*', DB::raw('count(orders.user_id) as count_by_user_id'))
	->join('orders' ,function($join){
		$join->on('orders.user_id', '=', 'users.id');
	})
	->groupBy('users.id')
	->orderBy('users.id', "DESC")
	->get();

Similar codes

0 vote341 views1 answer
Refresh database tables yii 1
PHP Yii
0 vote174 views1 answer
Use php artisan command through controller
PHP
0 vote115 views0 answer
PHP
0 vote186 views1 answer
Laravel mysql specified key was too long
PHP Laravel
37 votes189 views3 answers
Php unset array element
PHP
12 votes200 views6 answers
Set session data in laravel
PHP Laravel
0 vote306 views1 answer
Symfony add field to entity
PHP Symfony
3 votes193 views2 answers
Laravel image max size validation
PHP
0 vote210 views1 answer
Applying multiple order by in codeigniter
PHP CodeIgniter
0 vote156 views1 answer
Php reverse dns lookup
PHP