I need to make a DB inert which looks like this:
DB::table('users')->insert([
['email' => '[email protected]', 'votes' => 0],
['email' => '[email protected]', 'votes' => 0]
]);
But I am tryint to build the data with dynamic values eg in a loop add more times:
array_push($a,'email' => $this->mail,'votes' => $this->votes);
So that I can simply run this later:
DB::table('users')->insert($myData);
So how can I push a dimensional array?
If I understand your question correctly .you can do simply do this , you can push you arrays to the original array so it will create a multidimentinal array.
$a = array();
array_push($a,array('email' => $this->mail,'votes' => $this->votes));
You can do something like:
$array = [];
$dataComingFromSomewhere = []; // Assuming this is your data source
for($index = 0; $index < count($dataComingFromSomewhere); $index++)
{
$newUserArray = ['email' => $dataComingFromSomewhere[$index]->email, 'votes' => $dataComingFromSomewhere[$index]->votes];
array_push($array, $newUserArray);
}
DB::table('users')->insert($array);
just this,
$myData[]= array('email' => $this->mail,'votes' => $this->votes);
DB::table('users')->insert($myData);
Improper use of array_push(). To push a single Associative Element it's like:
$a['email'] = $this->mail; $a['votes'] = $this->votes;
or do this:
$a = array_merge($a, array('email' => $this->mail, 'votes' => $this->votes));
First initialize $a as empty array $a = array()
Then change the line
array_push($a,'email' => $this->mail,'votes' => $this->votes);
to
array_push($a,array('email' => $this->mail,'votes' => $this->votes));
and you can do,
DB::table('users')->create($a);
