I have an array ['abc','xyz'];
I want to insert two rows but in one go
I dont want
loop(){
$this->db->insert()
}
this will run insery query two times
Using CI Framework and this array comes from user
4 Answers
foreach ($this->input->post("name") as $value) {
$name[] = array(
'name'=>$value,
);
}
$this->db->insert_batch("names",$name);
2 Comments
Muhammad Omer Aslam
would you like to explain the code so that the OP decides why he needs to update the code to this one
Sven Rojek
Thanks for your answer. Please provide some description to your code-example.
yourModel.php
public function urfunctionName($data)
{
foreach($data as $res)
{
$this->db->insert('table_name',$res);
}
}
Hope it will work you
3 Comments
Neeraj Walia
I told you not to do this in loop
Ramesh S
Show me your expected result
Neeraj Walia
I will get same results but your code will run query equal to length of my array like if array has 100 indexes it will run 100 times which is not good i want to insert 100 rows in one run thanks for help insert_batch() did it thankyou all
You'll need to build your 'batch' insert query first. After that call the insert_batch method.
$array = ['abc','xyz'];
$batchInsertArray = buildBatchInsertArray($array);
$this->db->insert_batch('myTable', $batchInsertArray);
function buildBatchInsertArray(array $array): array
{
$batchInsertArray = [];
foreach ($array as $item) {
$batchInsertArray[] = [
'columnName' => $item
];
}
return $batchInsertArray;
}
Comments
$data = array(
array(
'title' => 'My title',
'name' => 'My Name',
'date' => 'My date'
),
array(
'title' => 'Another title',
'name' => 'Another Name',
'date' => 'Another date'
)
);
$this->db->insert_batch('mytable', $data);
// Produces: INSERT INTO mytable (title, name, date) VALUES ('My title', 'My name', 'My date'), ('Another title', 'Another name', 'Another date')
Referance :: query_builder inserting-data
insert_batchcodeigniter.com/userguide3/database/…