Excel导入mysql数据丢失
昨天晚上弄了一个晚上都没解决,来这里求助下,谢谢各位了
for($j=3;$j<=$highestRow;$j++)//表头不读取
{
$a = $objPHPExcel->getActiveSheet()->getCell("A".$j)->getValue();
$a=iconv("UTF-8","GBK//IGNORE",$a);//转码
$b = $objPHPExcel->getActiveSheet()->getCell("B".$j)->getValue();
$b=iconv("UTF-8","GBK//IGNORE",$b);//转码
//$c = $objPHPExcel->getActiveSheet()->getCell("C".$j)->getValue();
//$d = $objPHPExcel->getActiveSheet()->getCell("D".$j)->getValue();
//$e = $objPHPExcel->getActiveSheet()->getCell("E".$j)->getValue();
$sql = "INSERT INTO paee_course VALUES('".$a."','".$b."')";//,".$c.",".$d.",".$e."
echo $sql."$j&#