php mysql update multiple rows in different values

Asked Apr 12 '17 at 13:36

Active Apr 12 '17 at 13:36

Viewed 23 times

I am doing update the table values of multiple rows. So i using the query is

UPDATE `notification` SET `flag`='1' WHERE id IN (1,2,3,4)

Where it is working as fine. But don't how to use it in php. My php code ishown below.

  $json = '[{"id":"1"},{"id":"2"},{"id":"3"}]';
  $arr = json_decode($json);

if(is_array($arr)){
    $sql = "UPDATE `notification` SET `flag`='1' WHERE id IN (1,2,3,4)";

    // I want to implement the code is here.
}

Here, 1234 is the id. The id is parsing from json. But how apply in mysql query. please help me?

asked Apr 12 '17 at 13:36

Fazil

did you execute that query? and which MySQL API is used to connect with? – Funk Forty Niner Apr 12 '17 at 13:37
I have success fully excecuted in mysql. – Fazil Apr 12 '17 at 13:38
How to run a query with multiple values for IN clause is a duplicated question. While hoq to get your values from json is a different question, but nonetheless duplicated. use json_decode with second parameter and use array_column() to get values – Your Common Sense Apr 12 '17 at 13:42
how to check mysql api? – Fazil Apr 12 '17 at 13:43
have to first convert all id in to csv form and after that you can able to run query directly – Jenish Apr 12 '17 at 13:44

php mysql update multiple rows in different values

0 Answers0