+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Inserting multiple rows in Codeigniter (/showthread.php?tid=65161)
Inserting multiple rows in Codeigniter - frobak - 05-09-2016
I need to insert mutliple rows in codeigniter 3 with a single query. Now I'm currently using insert_batch and formatting the insert data as follows:
Code:
$user_privileges = array (
array (
'user_level_id' => $usr_level_id,
'privilege_id' => '501'
),
array (
'user_level_id' => $usr_level_id,
'privilege_id' => '505'
),
array (
'user_level_id' => $usr_level_id,
'privilege_id' => '520'
)
);Which works fine, but doesnt seem very efficient to me. What if I had 500 rows etc, whats an easier way to do it?
RE: Inserting multiple rows in Codeigniter - Narf - 05-09-2016
Why do you think it's not efficient?