复制代码
2，执行页面insertdb.php
$max_size){ echo import file is too large; exit; } if($ftype!='xls'){ echo import file type is error; exit; } }else{ echo the file is not empty!; exit; } }require(./conn.php); //连接mysql数据库//调用phpexcel类库
require_once 'phpexcel.php'; require_once 'phpexcel\iofactory.php';require_once 'phpexcel\reader\excel5.php';$objreader = phpexcel_iofactory::createreader('excel5');//use excel2007 for 2007 format
$objphpexcel = $objreader->load($uploadfile); $sheet = $objphpexcel->getsheet(0); $highestrow = $sheet->gethighestrow(); // 取得总行数 $highestcolumn = $sheet->gethighestcolumn(); // 取得总列数 $arr_result=array(); $strs=array();for($j=2;$j {
unset($arr_result); unset($strs); for($k='a';$k { //读取单元格 $arr_result .= $objphpexcel->getactivesheet()->getcell($k$j)->getvalue().','; } $strs=explode(,,$arr_result); $sql=insert into student(typeid,name,sex,age) values ($strs[0],'$strs[1]','$strs[2]',$strs[3]); echo $sql.
; mysql_query(set names utf8); $result=mysql_query($sql) or die(执行错误); $insert_num=mysql_affected_rows();
if($insert_num>0){ $succ_result+=1; }else{ $error_result+=1; }}echo 插入成功.$succ_result.条数据！！！
;
echo 插入失败.$error_result.条数据！！！;?>
复制代码