$handle = fopen(ROOT_PATH.'public/static/index/index/bp_data.csv', 'r');//打开文件
fgetcsv($handle); //去掉第一条标题内容
//需要新增的字段
$filed = ['username','password','truename','gender','area','mobile','company','category','business','address','content','thumb','email','capital','homepage'];
//循环拿到数据
$resData = array();
$i = 0;
while(($data = fgetcsv($handle)) !== FALSE){
foreach ($filed as $k=>$v){
$v = str_replace('"','',$v);
$resData[$i][$v] = $data[$k];
}
$i++;
}
//清空数据表
db('data')->execute("truncate table bp_data");
//新增数据
db('data')->insertAll($resData);
return 'ok';