laravel update and select

Question

I have a situation to update the row based on id and return the complete row. I can do it in two queries but i want to do it in one query only. I have write this...

 $result= DB::table($this->table)
          ->whereRaw($where['rawQuery'], $where['bindParams'] ? $where['bindParams'] : array())
          ->increment($updateField);
 if($result){
      return DB::table($updateTable)
             ->select('id')
             ->where('campaign_id',$where['bindParams'])
             ->where('date',date("Y-m-d"))
             ->get();
 }else{
     throw Exception("Error in fetching data");
 }

I am not getting any error, only i want to do it in a single query. dont want to hit the db two times for a single function — RAUSHAN KUMAR, Oct 13 '16 at 07:04
This isn't possible, your going to need to hit the database twice. — Jeemusu, Oct 13 '16 at 07:29
You need to run multiquery which are unprepared. you can see this question http://stackoverflow.com/questions/17630490/laravel-4-cannot-run-whole-raw-queries — Ahmed Khan, Oct 13 '16 at 07:29
i am not clear what you asked, i think you just want to update a field using where caluse and want to return what you inserted. — vinay kumar reddy, Oct 13 '16 at 07:33
No i want to return the id of the updated row or complete row if possible — RAUSHAN KUMAR, Oct 13 '16 at 07:35

score 1 · Accepted Answer · edited May 23 '17 at 12:08

I copied this from what you commented in your question:

No i want to return the id of the updated row or complete row if possible

If you want to return the ID of the just updated 'row' you're talking about. You can use Eloquent to accomplish this.

You can use a route like this:

Route::put('demo/{id}', Controller@update);

Then in your update function in your controller you can get the ID. Find the model with $model = Model::find(id);

do things with the data you get. Like $model->name = Input::get('name');

Then use $model->save();

After saving you can do $model->id;

Now you get back the ID about the row you just updated.

Refer back to this question:

Laravel, get last insert id using Eloquent

In the link i posted there are ways to do it with the DB query builder too. — Dennis, Oct 13 '16 at 09:45

SimonDepelchin · Answer 2 · 2016-10-13T08:25:43.993

-1

But any way it'll always be at least 2 queries (a SELECT and an UPDATE in MySQL, however you do it)

You can check Laravel Eloquent if you want a "cleaner" way to to this.

edited Oct 13 '16 at 08:25

answered Oct 13 '16 at 07:07

SimonDepelchin

2,013
22
18

laravel update and select

2 Answers2