/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

0 vote228 views1 answer
Eager load relationships on an existing model in route laravel
PHP Laravel
4 votes231 views2 answers
Laravel eloquent sum column
PHP Laravel
5 votes289 views5 answers
Unique laravel migration
PHP Laravel
6 votes265 views4 answers
Illuminate database queryexception could not find driver laravel
PHP Laravel
0 vote232 views1 answer
Laravel access request in provider
PHP Laravel
10 votes246 views2 answers
Convert collection to array laravel
PHP Laravel
0 vote242 views1 answer
Verta sample jalali laravel problem return object
PHP Laravel
2 votes287 views2 answers
Sentence get first second word php laravel
PHP Laravel
1 vote245 views1 answer
How validate data if is exist must not be empty in laravel
PHP Laravel
0 vote203 views2 answers
Show number 1 as 00001 laravel
PHP Laravel