php使用excel表格数据库数据,PHPexcel将excel表格数据导入数据库

根据以下代码执行&＃xff0c;肯定不会出错。。

// index.php

//insertdb.php

header("Content-type:text/html;charset:utf-8");

//全局变量

$succ_result&＃61;0;

$error_result&＃61;0;

&＃64;$file&＃61;$_FILES[&＃39;filename&＃39;];

$max_size&＃61;"2000000"; //最大文件限制(单位&＃xff1a;byte)

$fname&＃61;$file[&＃39;name&＃39;];

$ftype&＃61;strtolower(substr(strrchr($fname,&＃39;.&＃39;),1));

//文件格式

$uploadfile&＃61;$file[&＃39;tmp_name&＃39;];

if($_SERVER[&＃39;REQUEST_METHOD&＃39;]&＃61;&＃61;&＃39;POST&＃39;){

if(is_uploaded_file($uploadfile)){

if($file[&＃39;size&＃39;]>$max_size){

echo "Import file is too large";

exit;

}

if($ftype!&＃61;&＃39;xls&＃39;){

echo "Import file type is error";

exit;

}

}else{

echo "The file is not empty!";

exit;

}

}

$dsn&＃61;"mysql:dbname&＃61;me;host&＃61;127.0.0.1;charset&＃61;utf8";

$user&＃61;"root";

$pwd&＃61;&＃39;root&＃39;;

$pdo&＃61;new PDO($dsn,$user,$pwd);  //连接mysql数据库

//调用phpexcel类库

require_once &＃39;Classes/PHPExcel.php&＃39;;

require_once &＃39;Classes/PHPExcel/IOFactory.php&＃39;;

require_once &＃39;Classes/PHPExcel/Reader/Excel5.php&＃39;;

$objReader &＃61; PHPExcel_IOFactory::createReader(&＃39;Excel2007&＃39;);//use excel2007 for 2007 format

$objPHPExcel &＃61; $objReader->load($uploadfile);

$sheet &＃61; $objPHPExcel->getSheet(0);

$highestRow &＃61; $sheet->getHighestRow(); // 取得总行数

$highestColumn &＃61; $sheet->getHighestColumn(); // 取得总列数

$arr_result&＃61;array();

$strs&＃61;array();

for($j&＃61;2;$j<&＃61;$highestRow;$j&＃43;&＃43;)

{

unset($arr_result);

unset($strs);

for($k&＃61;&＃39;A&＃39;;$k<&＃61; $highestColumn;$k&＃43;&＃43;)

{

//读取单元格

&＃64;$arr_result  .&＃61; $objPHPExcel->getActiveSheet()->getCell("$k$j")->getValue().&＃39;,&＃39;;

}

$strs&＃61;explode(",",$arr_result);

$sql&＃61;"insert into goods(id,name,content,decs) values ($strs[0],&＃39;$strs[1]&＃39;,&＃39;$strs[2]&＃39;,$strs[3])";

echo $sql."
";

$result&＃61;$pdo->exec($sql) or die("执行错误");

if($result>0){

$succ_result&＃43;&＃61;1;

}else{

$error_result&＃43;&＃61;1;

}

}

echo "插入成功".$succ_result."条数据&＃xff01;&＃xff01;&＃xff01;
";

echo "插入失败".$error_result."条数据&＃xff01;&＃xff01;&＃xff01;";

?>