update batch codeigniter

Solutions on MaxInterview for update batch codeigniter by the best coders in the world

Search
showing results for - "update batch codeigniter"
Dario
01 Mar 2018
1$data = array(
2   array(
3      'title' => 'My title' ,
4      'name' => 'My Name 2' ,
5      'date' => 'My date 2'
6   ),
7   array(
8      'title' => 'Another title' ,
9      'name' => 'Another Name 2' ,
10      'date' => 'Another date 2'
11   )
12);
13
14$this->db->update_batch('mytable', $data, 'title');
15
16// Produces:
17// UPDATE `mytable` SET `name` = CASE
18// WHEN `title` = 'My title' THEN 'My Name 2'
19// WHEN `title` = 'Another title' THEN 'Another Name 2'
20// ELSE `name` END,
21// `date` = CASE
22// WHEN `title` = 'My title' THEN 'My date 2'
23// WHEN `title` = 'Another title' THEN 'Another date 2'
24// ELSE `date` END
25// WHERE `title` IN ('My title','Another title')
26
source
similar questions
codeigniter function upload 2 gambar berbedacodeigniter updatecodeigniter update query return valueupdate in codeigniter queryupdate codeigniterupdate query in codeigniter using where conditioncodeigniter select for updatecodeigniter get last querylaunch new tab and refresh original page codeignitercodeigniter 4 get last queryget upload error codeigniterhow to upload two files on same form different path in codeignitercodeigniter 3 pass anything in query stringcodeigniter 3 updateupdate query in codeigniter using multiple where conditioncodeigniter update or createupload multiple files in codeigniterlast insert id model codeignitercodeigniter check affected rows
queries leading to this page
update batch in codeigniter with where conditiontoute example update batch in codeigniterupdate batch in fro loop codeigniterupdate batch in codeignitercodeigniter batch updatecodeigniter update batch with wherecodeigniter update batchinsert batch codeigniter 4update batch codeigniterupdate in batches mysql codeigniterdelete batch codeignitercodeigniter 4 batch updateupdate batch where codeigniterupdate batch returning 1 codeignitercodeigniter update batch performancecodeigniter update batchbatch update codeigniter 4codeigniter update batch exampleupdate batch codeigniter 3using update batch with where condition in codeignitercodeigniter batch update wherecodeigniter update batchupdate batch in codeigniter with where conditioninsert batch codeignitercodeigniter 3 update batchdifference betwne update and update batch codeigniterupdate in batch where in codeigniterupdate batch in codeigniter 3update batch returning 1 in codeigniterupdate batch examplecodeigniter update batch with where inbatch update codeigniterupdate batch codeignitercodeigniter moder query update batchinsert batch in codeigniterupdate batch codeigniter 4codeigniter update batch limitcodeigniter update batch not workingcodeigniter batch updatebatch update in codeignitercodeigniter update batch extra wherecodeigniter 3eupdate batch 3ewhereinsert batch codeignitercodeigniter update batch with whereupdate batch codeigniter