php 分批处理数据方法,PHP分批处理MYSQL数据导入

public function import_excel($id){

$id = $this->input->get('id');

$file_name = dr_get_file($id);

$f = fopen($file_name, 'r');

$columns = fgetcsv($f);

$rows[] = $columns;

$_insert_func = function($data) {

$this->db->insert_batch('imt_1_mall', $data);

};

while ($row2 = fgetcsv($f)) {

$row = array_combine($columns, $row2);

$row2 = [

'title' => trim(iconv('GBK','utf-8',$row['title'])),

'thumb' => '',

'keywords'=>'',

'description'=>trim(iconv('GBK', 'UTF-8', $row['description'])),

'contents'=>trim(iconv('GBK', 'UTF-8', $row['content'])),

'hits'=>'',

'uid'=>1,

'catid' =>dr_trans_catid(trim(iconv('GBK','utf-8',$row['erjifenlei']))),

'author' => 'mutaoinc',

'status'=>'9',

'url'=>'',

'link_id'=>'',

'tableid'=>'',

'inputip'=>$this->input->ip_address(),

'inputtime'=>SYS_TIME,

'updatetime'=>SYS_TIME,

'comments'=>'',

'favorites' => 0,

'displayorder' => 0,

'order_price'=>trim(iconv('GBK','utf-8',$row['order_price'])),

'order_quantity'=>trim(iconv('GBK','utf-8',$row['order_quantity'])),

'order_volume'=>trim(iconv('GBK','utf-8',$row['order_volume'])),

'order_specification'=>'',

'order_shipping'=>'',

'order_shipping_param'=>'',

'order_city'=>'',

'order_status'=>'',

'order_sn'=>trim(iconv('GBK','utf-8',$row['order_sn'])),

'cpbh'=>trim(iconv('GBK','utf-8',$row['cpbh'])),

'biaozhunzhi'=>trim(iconv('GBK','utf-8',$row['biaozhunzhi'])),

'cashao'=>trim(iconv('GBK','utf-8',$row['cashao'])),

'guige'=>trim(iconv('GBK','utf-8',$row['guige'])),

'huoqi'=>trim(iconv('GBK','utf-8',$row['huoqi'])),

'youxiaoqi'=>trim(iconv('GBK','utf-8',$row['youxiaoqi'])),

'yanzhidanwei'=>trim(iconv('GBK','utf-8',$row['yanzhidanwei'])),

'biaozhunjia'=>trim(iconv('GBK','utf-8',$row['biaozhunjia'])),

'zhuanshujia'=>trim(iconv('GBK','utf-8',$row['zhuanshujia'])),

'goods_ename'=>trim(iconv('GBK','utf-8',$row['goods_ename'])),

'picihao'=>trim(iconv('GBK','utf-8',$row['picihao'])),

'pinpai'=>trim(iconv('GBK','utf-8',$row['pinpai'])),

'jinjia'=>trim(iconv('GBK','utf-8',$row['jinjia'])),

'zhiliangnongdu'=>trim(iconv('GBK','utf-8',$row['zhiliangnongdu'])),

'staff_remark'=>trim(iconv('GBK','utf-8',$row['staff_remark']))

];

$rows[] = $row2;

//满一百条执行一次

if (count($rows) >= 100) {

unset($rows[0]);

$_insert_func($rows);

$rows =[];

$rows[0] = $columns;

}

}

//剩余不满100条执行

if ($rows){

unset($rows[0]);

$_insert_func($rows);

}

}

发表评论电子邮件地址不会被公开。 必填项已用*标注

评论

姓名 *

电子邮件 *

站点