php中如何执行批量插入数据到mysql
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了php中如何执行批量插入数据到mysql，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3973字，纯文字阅读大概需要6分钟。
内容图文
$arr = Array
(
[0] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1427940803
[pv_total] => 0.00
)
[1] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1428477888
[pv_total] => 0.00
)
[2] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1428475892
[pv_total] => 0.00
)
[3] => Array
(
[u_id] => 2
[userid] => feng001
[status] => 3
[confirm_time] => 1428482901
[pv_total] => 0.00
)
[4] => Array
(
[u_id] => 2
[userid] => feng001
[status] => 3
[confirm_time] => 1428483116
[pv_total] => 0.00
)
[5] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1428483542
[pv_total] => 20.00
)
[6] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1428475881
[pv_total] => 40.00
)
[7] => Array
(
[u_id] => 5
[userid] => feng005
[status] => 3
[confirm_time] => 1428474458
[pv_total] => 100.00
)
[8] => Array
(
[u_id] => 4
[userid] => feng004
[status] => 3
[confirm_time] => 1428475275
[pv_total] => 100.00
)
[9] => Array
(
[u_id] => 3
[userid] => feng002
[status] => 3
[confirm_time] => 1428475478
[pv_total] => 100.00
)
[10] => Array
(
[u_id] => 2
[userid] => feng001
[status] => 3
[confirm_time] => 1428475622
[pv_total] => 100.00
)
[11] => Array
(
[u_id] => 6
[userid] => feng006
[status] => 3
[confirm_time] => 1428479200
[pv_total] => 100.00
)
[12] => Array
(
[u_id] => 6
[userid] => feng006
[status] => 3
[confirm_time] => 1428483519
[pv_total] => 40.00
)
)；
$count = count($res);
$sql = "insert into users(periods,uid,username,pv) VALUES ";
foreach($res as $key=>$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()->query($sql);
这样能行吗？没怎么用过批量操作数据库，请指导。
回复内容：
$arr = Array
(
[0] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1427940803
[pv_total] => 0.00
)
[1] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1428477888
[pv_total] => 0.00
)
[2] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1428475892
[pv_total] => 0.00
)
[3] => Array
(
[u_id] => 2
[userid] => feng001
[status] => 3
[confirm_time] => 1428482901
[pv_total] => 0.00
)
[4] => Array
(
[u_id] => 2
[userid] => feng001
[status] => 3
[confirm_time] => 1428483116
[pv_total] => 0.00
)
[5] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1428483542
[pv_total] => 20.00
)
[6] => Array
(
[u_id] => 1
[userid] => feng003
[status] => 3
[confirm_time] => 1428475881
[pv_total] => 40.00
)
[7] => Array
(
[u_id] => 5
[userid] => feng005
[status] => 3
[confirm_time] => 1428474458
[pv_total] => 100.00
)
[8] => Array
(
[u_id] => 4
[userid] => feng004
[status] => 3
[confirm_time] => 1428475275
[pv_total] => 100.00
)
[9] => Array
(
[u_id] => 3
[userid] => feng002
[status] => 3
[confirm_time] => 1428475478
[pv_total] => 100.00
)
[10] => Array
(
[u_id] => 2
[userid] => feng001
[status] => 3
[confirm_time] => 1428475622
[pv_total] => 100.00
)
[11] => Array
(
[u_id] => 6
[userid] => feng006
[status] => 3
[confirm_time] => 1428479200
[pv_total] => 100.00
)
[12] => Array
(
[u_id] => 6
[userid] => feng006
[status] => 3
[confirm_time] => 1428483519
[pv_total] => 40.00
)
)；
$count = count($res);
$sql = "insert into users(periods,uid,username,pv) VALUES ";
foreach($res as $key=>$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()->query($sql);
这样能行吗？没怎么用过批量操作数据库，请指导。
###代码大概像这样吧，手打的，没有测试###
php$sql = 'INSERT INTO TABLE (`u_uid`, `userid`,`status`,`confirm_time`,`pv_total`) VALUES'; foreach($arr as $k => $item) { $sql .= '(' . $item['u_uid'] . ',' . $item['userid'] . ',' . $item['status'] . ',' . $item['confirm_time'] . ',' . $item['pv_total'] . '),'; } $sql = rtrim($sql, ',');
对，就是这样的。
sqlINSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....),(值1, 值2,....),(值1, 值2,....)
其实编程这玩意儿，你试试看就知道可不可行了。
内容总结
以上是互联网集市为您收集整理的php中如何执行批量插入数据到mysql全部内容，希望文章能够帮你解决php中如何执行批量插入数据到mysql所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】