how to build loop to insert array in a table

Question

i have the following code:

 $var1="bmx"
 $newdata = implode(",", $dx);
 $queryinsert = "INSERT INTO table VALUES ($var1,$newdata)";

but with this code i get some like

INSERT INTO table VALUES (bmx,black,white, green, yellow,grey)";

and i need to create a new row for each color, like

INSERT INTO table VALUES (bmx,white)";
INSERT INTO table VALUES (bmx,black)";etc...

i think i should use a foreach but i don't know how.

i'm sorry still very confusing for me... i'm not very familiar with this type of code. — user3415003
– user3415003, Commented Mar 24, 2014 at 16:04

PeterRing · Accepted Answer · 2014-03-24 16:12:05Z

0

You need something like this. Go to the php docs, you will find everithing there.

$var1="bmx"

foreach ($dx as &$value) {
   $queryinsert = "INSERT INTO table VALUES ($var1,&$value)";
}

answered Mar 24, 2014 at 16:12

PeterRing

1,81713 silver badges21 bronze badges

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

1 Answer 1