Update on some Laravel 4.2 fields

Question

I have a table called People in Mysql with 40 fields and I want to update only 2 fields (latitude and longitude) but I don’t want to bring all 40 fields to change together. I just want to save the two camps I mentioned.

$people = DB::table('people')
            ->where('people.id', $people_id)
            ->select('people.id', 'people.latitude', 'people.longitude')
            ->first();

$people->latitude = $latitude;
$people->longitude = $longitude;
$people->save();

How to do this with Laravel 4.2?

Answer 1

No need to bring all fields there is a way to do this by giving only the update in some defined fields:

Example that is in the documentation

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

---

In your case:

DB::table('people')
       ->where('id', $people_id)
       ->update(array('latitude'=>$latitude,'longitude'=>$longitude));

See full documentation of version Laravel 4.2