插入PHP数组到mysql [英] insert php array into mysql

问题描述

我有一个数组$ product_array，当我使用的print_r（$ product_array）;.该阵列这样表示。

 阵列
（
    [0] =＆GT;排列
        （
            [ID] =＆GT; P00100
            [NAME] =＆GT;埃迪纳
            [PRICE] =＆GT; $ 20.00
        ）    [1] =＆GT;排列
        （
            [ID] =＆GT; P00101
            [NAME] =＆GT;里奇菲尔德
            [PRICE] =＆GT; $ 21.00
        ）    [2] =＆GT;排列
        （
            [ID] =＆GT; P00102
            [NAME] =＆GT;布卢明顿
            [PRICE] =＆GT; $ 22.00
        ）
）
 

我把我的数据库表中4 columes，第一个是mainid，并且是自动递增，与ID名称和价格之后，随着按键的上方显示。
我想插入这个数组$ product_array到mysql。
任何人都可以帮忙吗？将非常AP preciated！
TKS。

解决方案

  $ SQL =阵列（）;
    的foreach（$ myarray中为$行）{
        $ SQL [] ='（'。$行['身份证']'，'.mysql_real_escape_string（$行['名称']）。'
 '。$行['价格'。'）';
    }
    的mysql_query（INSERT INTO表（ID名称和价格）VALUES'.implode（''，$ SQL））;
 

查看更多详情：

<一个href=\"http://stackoverflow.com/questions/779986/insert-multiple-rows-via-a-php-array-into-mysql\">insert通过PHP数组多行到mysql

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.

解决方案

   $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

这篇关于插入PHP数组到mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！