/PHP/Laravel/Laravel update query builder

Laravel update query builder

Laravel where update query

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

Wherein laravel

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

Laravel update query builder

$update = \DB::table('student') ->where('id', $data['id']) ->limit(1) ->update( [ 'name' => $data['name'], 'address' => $data['address'], 'email' => $data['email'], 'contactno' => $data['contactno'] ]);

Source: stackoverflow.com

Laravel db::query update

 DB::table('user')->where('email', $userEmail)->update(array('member_type' => $plan));

Source: stackoverflow.com

Similar codes

1 vote369 views1 answer
Laravel order by raw
PHP Laravel
0 vote361 views1 answer
User order by role spatie laravel
PHP Laravel
0 vote370 views1 answer
Laravel str_pad Consecutivo
PHP Laravel
3 votes330 views3 answers
Laravel sort by function'
PHP Laravel
1 vote346 views1 answer
Laravel createmany example
PHP Laravel
1 vote322 views1 answer
How to save data from api to laravel
PHP Laravel
0 vote347 views1 answer
Sort by number of views descending laravel
PHP Laravel
0 vote345 views1 answer
Separate numbers with commas laravel
PHP Laravel
1 vote364 views1 answer
How send parameter with command in laravel
PHP Laravel
0 vote325 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel