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.

http://stackoverflow.com/questions/19077724/inserting-multiple-rows-from-a-php-form-into-the-database — Huseyin, Mar 24 '14 at 15:33
i'm sorry still very confusing for me... i'm not very familiar with this type of code. — user3415003, Mar 24 '14 at 16:04

score 0 · Accepted Answer · answered Mar 24 '14 at 16:12

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 '14 at 16:12

PeterRing

1 Answers1