/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

35 votes176 views6 answers
Laravel make auth
PHP Laravel
0 vote208 views1 answer
Get database columns laravel
PHP Laravel
14 votes167 views2 answers
Laravel database select
PHP Laravel
7 votes211 views5 answers
Laravel if else condition in blade file
PHP Laravel
0 vote194 views1 answer
Spatie/laravel-activitylog display only changed data
PHP Laravel
2 votes175 views1 answer
Laravel pivot table model
PHP Laravel
6 votes196 views4 answers
Laravel set config
PHP Laravel
-1 vote186 views2 answers
Random number laravel faker
PHP Laravel
0 vote180 views1 answer
Laravel where search like with space
PHP Laravel
0 vote197 views2 answers
Curl post laravel
PHP Laravel