insert php array into mysql

Question

I have an array $product_array, and when I use print_r($product_array);. The array shows like this

Array
(
    [0] => Array
        (
            [ID] => P00100
            [NAME] => Edina
            [PRICE] => $20.00
        )

    [1] => Array
        (
            [ID] => P00101
            [NAME] => Richfield
            [PRICE] => $21.00
        )

    [2] => Array
        (
            [ID] => P00102
            [NAME] => Bloomington
            [PRICE] => $22.00
        )
)

I set my database table in 4 columes, first one is mainid, and which is auto increment, following with ID, NAME, PRICE, as the keys showed above. I would like to insert this array $product_array into mysql. Can anyone help? Would be very much appreciated! tks.

Community · Accepted Answer · 2017-05-23 10:26:36Z

18

   $sql = array(); 
    foreach( $myarray as $row ) {
        $sql[] = '('.$row['ID'].', "'.mysql_real_escape_string($row['NAME']).'",
 "'.$row['PRICE'].'")';
    }
    mysql_query('INSERT INTO table (ID, NAME,PRICE) VALUES '.implode(',', $sql));

see more details :

insert multiple rows via a php array into mysql

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Oct 18, 2010 at 15:01

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

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

2 Comments

teemitzitrone Over a year ago

correct the first $row['PRICE'] to $row['ID'] and get an up-vote as reward ;)

Oğuz Çelikdemir Over a year ago

@HaimEvgi Haim, I think you should change mysql_real_query function which isn't available in php anymore.

GoofyX · Accepted Answer · 2010-10-18 15:01:37Z

0

You can try this code (quick 'n' dirty):

foreach($product_array as $v) {
  $query = 'insert into tablename values (null, \'' . $v['id'] . '\', \'' . $v['name'] . '\', ' . $v['price'] . ');'
  mysql_query($query);
}

answered Oct 18, 2010 at 15:01

GoofyX

1,1791 gold badge16 silver badges37 bronze badges

Collectives™ on Stack Overflow

insert php array into mysql

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related