$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="insertintousers(periods,uid,username,pv)VALUES";foreach($resas$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);这样能行吗?没怎么用过批量操作数据库,请指导。
30秒到达战场
摇曳的蔷薇
相关分类