dongxiong2000 2016-06-15 02:17
浏览 30

使用单个查询PHP(Prepared语句)插入多行

What is the best way to insert multiple rows in single query using PHP prepared statements?

I have this multidimensional data:

$data = array(
'6' => array(
  '945' => array(
    '11:04' => array(
      '0' => array(
        'date' => '2013-02-02',
        'user' => '3'
      ),
    ),
    '11:05' => array(
      '0' => array(
        'date' => '2013-02-03',
        'user' => '3'
       ),
    ),
    '11:06' => array(
      '0' => array(
        'date' => '2013-02-03',
        'user' => '3'
       ),
    )
  )
);

And the query I used is :

$ins = $this->conn->prepare("INSERT INTO table (date, user) VALUES ('2013-02-03', '03' )"); $ins->execute();

The query above is working but it just insert only one row so I tried to used the foreach as below:

 foreach ($data as $dk => $dv) {
    foreach ($dv as $k => $v) {
        foreach ($v as $rk => $rv) {
           $ins = $this->conn->prepare("INSERT INTO table  (date, user) VALUES ($rv['date'], $rv['user'] )");
            $ins->execute();

        }
    }
}

I want to query as:

INSERT INTO emp (date,user) VALUES("2013-02-02",3),("2013-02-02",3),("2013-02-03",3);

Please help

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 mmocr的训练错误,结果全为0
    • ¥15 python的qt5界面
    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀