I am trying to store multiple records in my database but I'm getting errors. At the moment I have this:
$array=array('key'=>'value');
for($i = 0; $i < $something; $i++){
array_add($array,'key','value')
}
DB::table('table')->insert($array);
Whenever I var_dump($array); It wont show the values of the array_add I add into the array.
What am I doing wrong and how should I insert like this?
What you are currently doing inside the for loop is setting key => value again and again. Instead you want to add an array with key => value to an array containing all the rows:
$rows = array(
array('key' => 'value'),
array('key' => 'value2'),
// and so on...
);
for($i = 0; $i < $something; $i++){
$rows[] = array('key' => 'value');
}
DB::table('table')->insert($rows);
$array[]=array('key2'=>'value2'); for every instance?
$something(in my normal code) What if I wanted to add more values before the for loop like you did on the first line?Cannot add or update a child row: a foreign key constraint fails. I know this means that what I'm trying to insert in a foreign key, doesn't exist, but I am 100% sure that the value that's going to insert in the foreign key, does exist. The query it shows in the error is kinda messed up as well. It says the error is at: FOREIGN KEY (company_id) REFERENCES companies . The query it shows is: SQL: insert into table (company_id) values (3), ('value'), etc...Here is an answer to this question. Hope this help. https://laracasts.com/discuss/channels/general-discussion/update-multiple-rows-in-a-foreach-loop?page=1#reply-27859
More a comment than an answer... Completely untested code...
Given my interpretation of the question - I think the code should look something like this....
If you wanted to add more than one record then an extra loop enclosing the 'newRecord' would be required.
Feel free to post comments if i misunderstood the question.
$allRecordsToInsert = array();
$newRecord = array();
for($i = 0; $i < $something; $i++) { // add columns to 'newRecord'
array_add($newRecord, $curColKey, $curColValue);
}
// append new record to list of records to be inserted
$allRecordsToInsert[] = $newRecord;
DB::table('table')->insert($allRecordsToInsert);
DB::table('table')->insert($array);This is in the Laravel framework query builder.=>and,do the same in this case? I've already tried to get both of them the same. Either=>or,