update all row in codeigniter<\/p>\n
<\/p>\n
$this->db->update_batch()<\/p>\n
Generates an update string based on the data you supply, and runs the query. You can either pass an array or an object to the function. Here is an example using an array:<\/p>\n
$data = array(
\narray(
\n‘title’ => ‘My title’ ,
\n‘name’ => ‘My Name 2’ ,
\n‘date’ => ‘My date 2’
\n),
\narray(
\n‘title’ => ‘Another title’ ,
\n‘name’ => ‘Another Name 2’ ,
\n‘date’ => ‘Another date 2’
\n)
\n);<\/p>\n
$this->db->update_batch(‘mytable’, $data, ‘title’);<\/p>\n
\/\/ Produces:
\n\/\/ UPDATE `mytable` SET `name` = CASE
\n\/\/ WHEN `title` = ‘My title’ THEN ‘My Name 2’
\n\/\/ WHEN `title` = ‘Another title’ THEN ‘Another Name 2’
\n\/\/ ELSE `name` END,
\n\/\/ `date` = CASE
\n\/\/ WHEN `title` = ‘My title’ THEN ‘My date 2’
\n\/\/ WHEN `title` = ‘Another title’ THEN ‘Another date 2’
\n\/\/ ELSE `date` END
\n\/\/ WHERE `title` IN (‘My title’,’Another title’)
\nThe first parameter will contain the table name, the second is an associative array of values, the third parameter is the where key.<\/p>\n","protected":false},"excerpt":{"rendered":"
update all row in codeigniter $this->db->update_batch() Generates an update string based on the data you supply, and runs the query. You can either pass … <\/p>\n