/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 vote257 views1 answer
Laravel orderby with relation
PHP Laravel
0 vote252 views1 answer
Only get selected value from has many ralation laravel
PHP Laravel
15 votes349 views2 answers
Update column value laravel
PHP Laravel
4 votes260 views3 answers
Laravel restore soft delete
PHP Laravel
12 votes292 views4 answers
Laravel get second last record
PHP Laravel
0 vote275 views1 answer
How can get attribute without getter in laravel
PHP Laravel
5 votes290 views2 answers
Laravel APP_ENV config
PHP Laravel
0 vote226 views2 answers
Laravel blade empty
PHP Laravel
0 vote261 views1 answer
Show all laravel valet folders
PHP Laravel
1 vote277 views1 answer
How to use old for select in blade laravel
PHP Laravel