Insert array to multiple rows in MySQL database?

Question

Array $ids contains:

Array ( [0] => 25 [1] => 29 [2] => 30 [3] => 34 )

How do I insert each key as a row in column ID?

So far I did this, I don't know if it's possible to stick it in the query though:

$x = 0;
while($x < 6) {
echo "values ('" . $follower . "','" . $ids[$x] . "')";
$x++;
}

Yes, sorry. I'm trying to make a loop that echoes the Values and see if that can be integrated in the query. I don't know if it's possible. I add it in the question. — lisovaccaro
– lisovaccaro, Commented Nov 21, 2011 at 5:35

Amit Merchant · Accepted Answer · 2011-11-21 05:51:02Z

4

it's as simple as that:

foreach ($ids as $k => $v) {
     mysql_query("insert into TABLE_NAME(ID) values($v)");
}

and for you second question:

foreach ($ids as $k => $v) {
    if($k!=0){
        mysql_query("insert into TABLE_NAME values($v)");
    }
}

edited Nov 21, 2011 at 5:51

answered Nov 21, 2011 at 5:32

Amit Merchant

1111 gold badge1 silver badge10 bronze badges

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

1 Comment

Shailesh Jangir Over a year ago

this will execute query multiple time, but my solution will executed only once for multiple value.. stackoverflow.com/questions/8207628/…

Hassan Khodadadeh · Accepted Answer · 2011-11-21 05:30:22Z

1

foreach($ids as  $id=> $val){
mysql_query("insert into table(id,value) values($id,$val)",$cn);
}

answered Nov 21, 2011 at 5:30

Hassan Khodadadeh

7,8984 gold badges47 silver badges72 bronze badges

Comments

Tudor Constantin · Accepted Answer · 2011-11-21 05:30:51Z

1

you iterate through the array: foreach ($arr as $key => $value) {
on each iteration you create an SQL query $sql = "INSERT INTO table (id) VALUES ($value)"; - of course you will mysql_real_escape the value of $value before doing this
then execute the query: mysql_query($sql)

answered Nov 21, 2011 at 5:30

Tudor Constantin

26.9k7 gold badges54 silver badges73 bronze badges

Comments

Shailesh Jangir · Accepted Answer · 2011-11-21 06:11:56Z

1

you may use

$sql = "";
foreach($ids as  $id=> $val){
if(empty($sql)){
$sql = "insert into table(follower,value) values( $follower,$val)";
}else{
$sql.=",($follower,$val)";
}
}
mysql_query($sql);

answered Nov 21, 2011 at 6:11

Shailesh Jangir

3952 silver badges10 bronze badges

Collectives™ on Stack Overflow

Insert array to multiple rows in MySQL database?

4 Answers 4

1 Comment

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Related