/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 vote227 views1 answer
Composer new project laravel acl
PHP Laravel
1 vote256 views1 answer
/laravel-2020-07-27.log" could not be opened
PHP Laravel
0 vote239 views1 answer
Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
PHP Laravel
0 vote239 views1 answer
@method overide form laravel
PHP Laravel
15 votes246 views3 answers
Pass data to blade laravel
PHP Laravel
7 votes223 views2 answers
Laravel unique multiple columns
PHP Laravel
0 vote237 views1 answer
Scribe laravel
PHP Laravel
3 votes227 views1 answer
Sum multiple fields separately in laravel
PHP Laravel
0 vote238 views1 answer
Laravel capsule schema datatime CURRENT_TIMESTAMP
PHP Laravel
1 vote238 views1 answer
Laravel read origanl value before update
PHP Laravel