php中如何执行批量插入数据到mysql-php教程-PHP中文網

回复内容：

###代码大概像这样吧，手打的，没有测试###

首頁

後端開發

php教程

php中如何执行批量插入数据到mysql

Jun 06, 2016 pm 08:36 PM

mysql php 大量批量插入

<code>$arr = Array
(
    [0] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1427940803
            [pv_total] =&gt; 0.00
        )

    [1] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1428477888
            [pv_total] =&gt; 0.00
        )

    [2] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475892
            [pv_total] =&gt; 0.00
        )

    [3] =&gt; Array
        (
            [u_id] =&gt; 2
            [userid] =&gt; feng001
            [status] =&gt; 3
            [confirm_time] =&gt; 1428482901
            [pv_total] =&gt; 0.00
        )

    [4] =&gt; Array
        (
            [u_id] =&gt; 2
            [userid] =&gt; feng001
            [status] =&gt; 3
            [confirm_time] =&gt; 1428483116
            [pv_total] =&gt; 0.00
        )

    [5] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1428483542
            [pv_total] =&gt; 20.00
        )

    [6] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475881
            [pv_total] =&gt; 40.00
        )

    [7] =&gt; Array
        (
            [u_id] =&gt; 5
            [userid] =&gt; feng005
            [status] =&gt; 3
            [confirm_time] =&gt; 1428474458
            [pv_total] =&gt; 100.00
        )

    [8] =&gt; Array
        (
            [u_id] =&gt; 4
            [userid] =&gt; feng004
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475275
            [pv_total] =&gt; 100.00
        )

    [9] =&gt; Array
        (
            [u_id] =&gt; 3
            [userid] =&gt; feng002
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475478
            [pv_total] =&gt; 100.00
        )

    [10] =&gt; Array
        (
            [u_id] =&gt; 2
            [userid] =&gt; feng001
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475622
            [pv_total] =&gt; 100.00
        )

    [11] =&gt; Array
        (
            [u_id] =&gt; 6
            [userid] =&gt; feng006
            [status] =&gt; 3
            [confirm_time] =&gt; 1428479200
            [pv_total] =&gt; 100.00
        )

    [12] =&gt; Array
        (
            [u_id] =&gt; 6
            [userid] =&gt; feng006
            [status] =&gt; 3
            [confirm_time] =&gt; 1428483519
            [pv_total] =&gt; 40.00
        )

)；
$count = count($res);
     $sql = "insert into users(periods,uid,username,pv) VALUES ";
           foreach($res as $key=&gt;$vo){
                if($key == $count-1){
                    $sql .= "(".$periods.",".$vo['u_id'].",'".$vo['userid']."',".$vo['pv_total'].")";
                }else{
                    $sql .= "(".$periods.",".$vo['u_id'].",'".$vo['userid']."',".$vo['pv_total']."),";
                }
            };
            M()-&gt;query($sql);
</code>

登入後複製

这样能行吗？没怎么用过批量操作数据库，请指导。

回复内容：

<code>$arr = Array
(
    [0] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1427940803
            [pv_total] =&gt; 0.00
        )

    [1] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1428477888
            [pv_total] =&gt; 0.00
        )

    [2] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475892
            [pv_total] =&gt; 0.00
        )

    [3] =&gt; Array
        (
            [u_id] =&gt; 2
            [userid] =&gt; feng001
            [status] =&gt; 3
            [confirm_time] =&gt; 1428482901
            [pv_total] =&gt; 0.00
        )

    [4] =&gt; Array
        (
            [u_id] =&gt; 2
            [userid] =&gt; feng001
            [status] =&gt; 3
            [confirm_time] =&gt; 1428483116
            [pv_total] =&gt; 0.00
        )

    [5] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1428483542
            [pv_total] =&gt; 20.00
        )

    [6] =&gt; Array
        (
            [u_id] =&gt; 1
            [userid] =&gt; feng003
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475881
            [pv_total] =&gt; 40.00
        )

    [7] =&gt; Array
        (
            [u_id] =&gt; 5
            [userid] =&gt; feng005
            [status] =&gt; 3
            [confirm_time] =&gt; 1428474458
            [pv_total] =&gt; 100.00
        )

    [8] =&gt; Array
        (
            [u_id] =&gt; 4
            [userid] =&gt; feng004
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475275
            [pv_total] =&gt; 100.00
        )

    [9] =&gt; Array
        (
            [u_id] =&gt; 3
            [userid] =&gt; feng002
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475478
            [pv_total] =&gt; 100.00
        )

    [10] =&gt; Array
        (
            [u_id] =&gt; 2
            [userid] =&gt; feng001
            [status] =&gt; 3
            [confirm_time] =&gt; 1428475622
            [pv_total] =&gt; 100.00
        )

    [11] =&gt; Array
        (
            [u_id] =&gt; 6
            [userid] =&gt; feng006
            [status] =&gt; 3
            [confirm_time] =&gt; 1428479200
            [pv_total] =&gt; 100.00
        )

    [12] =&gt; Array
        (
            [u_id] =&gt; 6
            [userid] =&gt; feng006
            [status] =&gt; 3
            [confirm_time] =&gt; 1428483519
            [pv_total] =&gt; 40.00
        )

)；
$count = count($res);
     $sql = "insert into users(periods,uid,username,pv) VALUES ";
           foreach($res as $key=&gt;$vo){
                if($key == $count-1){
                    $sql .= "(".$periods.",".$vo['u_id'].",'".$vo['userid']."',".$vo['pv_total'].")";
                }else{
                    $sql .= "(".$periods.",".$vo['u_id'].",'".$vo['userid']."',".$vo['pv_total']."),";
                }
            };
            M()-&gt;query($sql);
</code>

登入後複製

这样能行吗？没怎么用过批量操作数据库，请指导。

###代码大概像这样吧，手打的，没有测试###

<code>php</code><code>$sql = 'INSERT INTO TABLE (`u_uid`, `userid`,`status`,`confirm_time`,`pv_total`) VALUES';
foreach($arr as $k =&gt; $item) {
    $sql .= '(' . $item['u_uid'] . ',' . $item['userid'] . ',' . $item['status'] . ',' . $item['confirm_time'] . ',' . $item['pv_total'] . '),';
}
$sql = rtrim($sql, ',');
</code>

登入後複製

对，就是这样的。

<code>sql</code><code>INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....),(值1, 值2,....),(值1, 值2,....)
</code>

登入後複製

其实编程这玩意儿，你试试看就知道可不可行了。

本網站聲明

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

php中如何执行批量插入数据到mysql

回复内容：

###代码大概像这样吧，手打的，没有测试###

熱門文章

熱門工具標籤

熱門文章

熱門文章標籤

記事本++7.3.1

SublimeText3漢化版

禪工作室 13.0.1

Dreamweaver CS6

SublimeText3 Mac版

熱門話題