laravel multiple inserts to MySQL

Question

I am trying to insert multiple rows of data into a MySQL table, but only the first row is being inserted. Here is the code in my controller.

DB :: table("users_has_activities") -> insert
(
array("usersID" => $userId, "activitiesID" => 1, "time" => $datetime, "value" => 1,
"multiplier" => 1 ),


array("usersID" => $userId, "activitiesID" => 2, "time" => $datetime, "value" => 1,
"multiplier" => 1 ),

array("usersID" => $userId, "activitiesID" => 3, "time" => $datetime, "value" => 1,
"multiplier" => 1 )
);

I can do it this way but I am looking for a better way.

DB :: table("users_has_activities") -> insert
(
array("usersID" => $userId, "activitiesID" => 1, "time" => $datetime, "value" => 1,
"multiplier" => 1 )
);

  DB :: table("users_has_activities") -> insert
(
array("usersID" => $userId, "activitiesID" => 2, "time" => $datetime, "value" => 1,
"multiplier" => 1 )
);


DB :: table("users_has_activities") -> insert
(
array("usersID" => $userId, "activitiesID" => 3, "time" => $datetime,   "value" =>   1,
"multiplier" => 1 )
 );

Alexey Mezenin · Accepted Answer · 2016-04-06 19:16:46Z

1

You're trying to pass an array, but you forgot to add array():

DB::table("users_has_activities") -> insert(array(
array("usersID" => $userId, "activitiesID" => 1, "time" => $datetime, "value" => 1,
"multiplier" => 1 ),

array("usersID" => $userId, "activitiesID" => 2, "time" => $datetime, "value" => 1,
"multiplier" => 1 ),

array("usersID" => $userId, "activitiesID" => 3, "time" => $datetime, "value" => 1,
"multiplier" => 1 )
));

answered Apr 6, 2016 at 19:16

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

laravel multiple inserts to MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related