doujiao7325 2016-12-23 10:51
浏览 178
已采纳

在php中将关联数组插入MySQL数据库

I have an array called $output which contains:

Array
(
    [0] => Array
        (
            [0] => J Arora
            [1] =>  India
        )

    [1] => Array
        (
            [0] => J Ramuj
            [2] =>  Russia
        )

    [2] => Array
        (
            [1] =>  KJ Tris
            [2] =>  Germany
        )

)

How can i insert these data into mysql database table like these

---------------
name   | country
-------|---------
J Arora|India
-------|--------
J Ramuj|Russia
-------|--------
KJ Tris|Germany
-------|--------

I am not able to fetch these values separately from given array as their index are not in sequence.

  • 写回答

5条回答 默认 最新

  • duanhuan2301 2016-12-23 10:58
    关注

    Just loop it with a foreach, and use PHP native functions like current() and end() to get your elements. Given that you just have two elements in your array at all times, this should work

    foreach ($output as $v) {
        echo current($v); // Name
        echo end($v); // Country
    }
    

    Adapt this to build your query and execute it inside the loop. Inside the loop you could do

    foreach ($output as $v) {
        $sql = "INSERT INTO table (`name`, `country`) VALUES ('".current($v)."', '".end($v)."')";
        // TODO: Execute query
    }
    

    You should also note that any query using variables should be using prepared statements with placeholders. Both MySQLi and PDO supports this.


    Using prepared statements

    Build the query before, and execute it as you loop it with the appropriate variables bound.

    Example with PDO:

    $stmt = $pdo->prepare("INSERT INTO table (`name`, `country`) VALUES (:name, :country)");
    foreach ($output as $v) {
        $stmt->execute(array("name" => current($v), "country" => end($v));
    }
    

    Example with MySQLi:

    $stmt = $mysqli->prepare("INSERT INTO table (`name`, `country`) VALUES (?, ?)");
    foreach ($output as $v) {
        $name = current($v);
        $country = end($v);
        $stmt->bind_param("ss", $name, $country);
        $stmt->execute();
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?

悬赏问题

  • ¥50 远程桌面打开Mastercam、没有许可证、物理机打开正常
  • ¥15 ubuntu安装gdal后java读取tif文件报错
  • ¥15 请问lammps怎么做两种金属连接的原子浓度分布图
  • ¥15 求jacquard数据集
  • ¥15 w10部分软件不能联网
  • ¥15 关于安装hbase的问题(操作系统-windows)
  • ¥15 novnc连接pve虚拟机报错安全协议不支持262
  • ¥15 设备精度0.03给多少公差能达到CPK1.33
  • ¥15 qt+ffmpeg报错non-existing PPS 0 referenced
  • ¥50 MacOS 使用虚拟机安装k8s