Laravel db query

Laravel update from query

$affected = DB::table('users')
              ->where('id', 1)
              ->update(['votes' => 1]);

Source: laravel.com

Laravel database select

use Illuminate\Support\Facades\DB;
 
$users = DB::select('select * from users');
 
foreach ($users as $user) {
    echo $user->name;
}

Laravel db query

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

Laravel wher in

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

Wherein laravel

 DB::table('user')->whereIn('id', [100,200])->get();

Laravel sql query

use Illuminate\Support\Facades\DB;

$users = DB::select('select * from users');

foreach ($users as $user) {
    echo $user->name;
}

Source: laravel.com

Similar codes

3 votes239 views2 answers
Current user laravel
PHP Laravel
1 vote239 views1 answer
How to alias table name in laravel model
PHP Laravel
0 vote245 views2 answers
Laravel limit foreach
PHP Laravel
18 votes291 views5 answers
Create model, controller and migration in single command laravel
PHP Laravel
12 votes223 views3 answers
Carbon in laravel documentation
PHP Laravel
1 vote250 views2 answers
Update checkbox value in laravel
PHP Laravel
10 votes247 views5 answers
How to remove public from url in laravel
PHP Laravel
0 vote262 views1 answer
Href in laravel view
PHP Laravel
2 votes233 views2 answers
Laravel get column field name
PHP Laravel
0 vote225 views1 answer
Publish laravel scout
PHP Laravel