$pdo=new PDO('mysql:host=localhost;dbname=broadmesse','root',''); $name = $pdo->query('set names utf8'); $file_stu=$_FILES['file_stu']; //print_r($file_stu['name']);die; $ss=substr($file_stu['name'],strrpos($file_stu['name'],'.')+1);//截取后缀名 if($ss!="xls"){ echo "文件格式不正确";die; } $file=file_get_contents($file_stu['tmp_name']); $html = iconv("gb2312", "utf-8//IGNORE",$file); $arr=explode("\n",$html); unset($arr[0]); foreach($arr as &$v){ $v=explode("\t",$v); $str=$pdo->query("insert into aa(a1,a2,a3,a4) VALUES ('$v[0]','$v[1]','$v[2]','$v[3]')"); } if($str){ echo "导入成功"; }else{ echo "导入失败"; }
php 原生excel导入
最新推荐文章于 2024-04-28 11:25:26 发布