Laravel select count

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 wher in

$users = DB::table('users')
                    ->whereIn('id', [1, 2, 3])
                    ->get();

Get count laravel

$count = Model::where('status','=','1')->count();

Source: stackoverflow.com

Select sum in laravel

Sometime for such queries you need to disable the strict check
 So inside config/database.php and inside mysql, 
 Set 'strict' => false,

->select('user_id', DB::raw('SUM(points) as total_points'))

Parametre grouping laravel quert

DB::table('users')
            ->where('name', '=', 'John')
            ->where(function ($query) {
                $query->where('votes', '>', 100)
                      ->orWhere('title', '=', 'Admin');
            })
            ->get();

Laravel select count

$count = DB::table('category_issue')->count();

Source: stackoverflow.com

Similar codes

0 vote225 views1 answer
Laravel storage goes to 404 page. (Symlink not working)
PHP Laravel
38 votes292 views6 answers
Laravel foreign key
PHP Laravel
24 votes288 views4 answers
Clear cache command in laravel controller
PHP Laravel
0 vote243 views1 answer
Laravel belongstomany prevent duplicates attach
PHP Laravel
17 votes225 views3 answers
Laravel order by desc
PHP Laravel
51 votes599 views3 answers
Laravel version check
PHP Laravel
5 votes271 views3 answers
Laravel eloquent duplicate record
PHP Laravel
3 votes235 views2 answers
Create variable in laravel blade
PHP Laravel
6 votes293 views1 answer
In order to use the Auth::routes() method, please install the laravel/ui package.
PHP Laravel
0 vote268 views2 answers
Bigtext migration laravel
PHP Laravel