Laravel update multi rows using whereIn

Question

I have ids in a string through ajax,

example:

"1,2"

and in my controller, I would like to update multiple rows of a product in one query using whereIn with id => [1,2].

ajax:

$('#add_product').click(function() { 
   var id = $('#get_value').val();
    $.ajax({
        type: 'POST',
        url: "{{action('ProductController@updateProduct')}}",
        data: {
        id: id
        },
     success: function(data){
          alert("success");
     }
    });
});

Controller :

public function updateProduct(Request $request){
 $test_value = collect($request->id);
 $updateProduct = Product::whereIn('id',$test_value)
                  ->update(['title' => 'My title']);
}

But i have this error in the network :

SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: '1,2' (SQL: update "products" set "title" = "My title" where "id" in (1,2))

@sebastianlarsen have you overcome this problem with my answer? — Chirag Patel
– Chirag Patel, Commented Apr 10, 2018 at 12:47

Chirag Patel · Accepted Answer · 2018-04-10 12:28:33Z

4

In $test_value you are getting values "1,2" as a string so you have to make it array first with using explode() function(what explode() function do is here),

$ids = explode(',',$test_value);

then pass this $ids into your function.

public function updateProduct(Request $request){
    $test_value = $request->id;
    $ids = explode(',',$test_value);
    $updateProduct = Product::whereIn('id',$ids)
                  ->update(['title' => 'My title']);
}

edited Apr 10, 2018 at 12:28

answered Apr 10, 2018 at 11:38

Chirag Patel

1,6422 gold badges11 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vishal pardeshi · Accepted Answer · 2018-04-10 12:18:52Z

0

You need to remove collect()

public function updateProduct(Request $request){
   $test_value = $request->id;
   $ids = explode( ',',$test_value);
   $updateProduct = Product::whereIn('id',$ids)
              ->update(['title' => 'My title']);
}

answered Apr 10, 2018 at 12:18

vishal pardeshi

3344 silver badges14 bronze badges

Comments

Mike Foxtech · Accepted Answer · 2018-04-10 11:23:54Z

-1

You can not update the fields in the table - bulk. You need to update one by one through the foreach

public function updateProduct(Request $request){
 $updateProducts = [];

 foreach((array) $request->id as $id) {
  $updateProducts[] = Product::where('id', $id)
                                      ->first()
                                      ->update(['title' => 'My title']);
 }
}

answered Apr 10, 2018 at 11:23

Mike Foxtech

1,6511 gold badge8 silver badges7 bronze badges

3 Comments

sebastian larsen Over a year ago

Thank's Mike Foxtech , but he make me an update for id = 1 but for id = 2 he does not do anything

Mike Foxtech Over a year ago

@sebastianlarsen $request->id looks like an array, that's right [1, 2] ?

Hilmi Erdem KEREN Over a year ago

You CAN bulk update the fields in a table. In fact, if you are not specific enough; your query will affect all the table.

Collectives™ on Stack Overflow

Laravel update multi rows using whereIn

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related