//excel导入成mysql数据
$links = file('zxx4.csv');
foreach($links as $value)
{
$result = explode(',',$value);
if(isset($result[1]))
{
$result[0] = trim(mb_convert_encoding($result[0], 'utf-8', 'gbk'));
$result[1] = trim(mb_convert_encoding($result[1], 'utf-8', 'gbk'));
$sql = "SELECT s_id FROM uc_school WHERE s_name = '$result[0]' AND p_s_id != 0";
$s_id = $this->model->selectschool($sql);
if ($s_id)
{
$sql = "INSERT INTO uc_school(p_s_id,s_name)VALUES($s_id,'$result[1]')";
$this->model->insertschool($sql);
}
}
}
$links = file('zxx4.csv');
foreach($links as $value)
{
$result = explode(',',$value);
if(isset($result[1]))
{
$result[0] = trim(mb_convert_encoding($result[0], 'utf-8', 'gbk'));
$result[1] = trim(mb_convert_encoding($result[1], 'utf-8', 'gbk'));
$sql = "SELECT s_id FROM uc_school WHERE s_name = '$result[0]' AND p_s_id != 0";
$s_id = $this->model->selectschool($sql);
if ($s_id)
{
$sql = "INSERT INTO uc_school(p_s_id,s_name)VALUES($s_id,'$result[1]')";
$this->model->insertschool($sql);
}
}
}
转载于:https://blog.51cto.com/caixia/711226