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 vote249 views4 answers
Laravel old value for select option
PHP Laravel
10 votes176 views2 answers
Array to string conversion in laravel controller
PHP
22 votes169 views4 answers
Php secure password hash
PHP
1 vote176 views2 answers
EnableQueryLog
PHP
0 vote175 views1 answer
Php basename from path
PHP
0 vote197 views1 answer
Php laravel rount price to 99
PHP Laravel
-1 vote192 views1 answer
Laravel get fetch api request body
PHP Laravel
0 vote164 views1 answer
Laravel collection collapse
PHP
0 vote304 views1 answer
Bring up the power shell console php
PHP
0 vote217 views3 answers
Get index number wordpress loop
PHP Wordpress