update query laravel eloquent code example

Example 1: laravel update from query

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

Example 2: eloquent update row response

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

Example 3: laravel eloquent remove from db

$res=User::where('id',$id)->delete();

Example 4: eloquent first

$user = User::where('mobile', Input::get('mobile'))->get();

if (!$user->isEmpty()){
    $firstUser = $user->first()
}

Example 5: update query laravel

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

Tags:

Sql Example