<?php//引入PHPExcelrequire("./phpexcel/PHPExcel.php");require("./phpexcel/PHPExcel/Reader/Excel2007.php");require("./phpexcel/PHPExcel/Reader/Excel5.php");require("./phpexcel/PHPExcel/Cell.php");header('Content-Type:text/html;charset=utf-8;');$isUpLoadSuccess = false;$failReason = null;if ($_FILES["filePath"]["type"] == "application/octet-stream"){if ($_FILES["filePath"]["error"] > 0) {$failReason = "Return Code: ".$_FILES["filePath"]["error"];//echo "Return Code: ".$_FILES["filePath"]["error"]."<br />";} else {if (file_exists ( "upload/" . $_FILES ["filePath"] ["name"] )) {//echo $_FILES ["filePath"]["name"]."already exists.";$failReason = $_FILES ["filePath"]["name"]."already exists.";$failReason = "该文件已存在";} else {move_uploaded_file ($_FILES["filePath"]["tmp_name"], "upload/".$_FILES["filePath"]["name"]);$isUpLoadSuccess = true;//echo "Stored in: " . "upload/".$_FILES["filePath"]["name"];}}} else {//echo "Invalid file";$failReason = '未选中文件或文件不可见或文件类型错误';}if ($isUpLoadSuccess){//echo "<Script>alert('上传成功');</Script>";}else{echo "<Script>alert('".$failReason."');</Script>";echo "<Script>window.location.href='adminDoAddBook.php'</Script>";exit(0);}$filePath = "./upload/".$_FILES["filePath"]["name"];$objPHPExcel = new PHPExcel();$objPHPExcelReader = new PHPExcel_Reader_Excel2007();//判断文件是否可以读if($objPHPExcelReader->canRead($filePath)){//echo "yes";}else{//版本不对的时候切换版本$objPHPExcelReader = new PHPExcel_Reader_Excel5();if($objPHPExcelReader->canRead($filePath)){}else{echo "<Script>alert('文件不存在或者文件不可读，，请检查后重试！');</Script>";return;}}$objPHPExcel = $objPHPExcelReader->load($filePath);//读取excel文件中的第一个工作表$currentSheet = $objPHPExcel->getSheet(0);//取到最大的列号$allColumn = $currentSheet->getHighestColumn();//取到最大的行号$allRow = $currentSheet->getHighestRow();//连接数据库$link = mysql_connect("127.0.0.1", "root", "")or die("不能连接到数据库".mysql_error());if($link){//echo "连接成功！";}$db_select = mysql_select_db("libray");if ($db_select) {//echo "yes";}$allInsertNumber = 0;$insertSuccessNumber = 0;for($currentRow = 2; $currentRow <= $allRow; $currentRow++){$sql = "insert INTO Book values (";for($currentColumn = 'A'; $currentColumn <= $allColumn; $currentColumn++){$str = $currentColumn.$currentRow;$val = $currentSheet->getCell($str)->getValue();if($currentColumn == 'B' || $currentColumn == 'C'|| $currentColumn == 'D' || $currentColumn == 'F'){//$val = convertToUTF8($val);$val = "'".$val."'";}if ($currentColumn == 'E') {$val = excelTime($val);$val = "'".$val."'";}if ('A' != $currentColumn) {$sql = $sql.",";}$sql = $sql.$val;}$sql = $sql.")";$b = mysql_query($sql);//echo "$sql<br>";$allInsertNumber++;if ($b) {//echo "yes";$insertSuccessNumber++;}else{//echo "no";}//echo "$sql";}$result = "共 $allInsertNumber 条数据,成功执行 $insertSuccessNumber 条数据!";echo "<Script>alert('".$result."');</Script>";echo "<Script>window.location.href='adminDoAddBook.php'</Script>";//工具函数 解决中文乱码function convertToUTF8($str){return iconv('utf-8','gb2312', $str);}function excelTime($date, $time = false) {if(function_exists('GregorianToJD')){if (is_numeric( $date )) {$jd = GregorianToJD( 1, 1, 1970 );$gregorian = JDToGregorian( $jd + intval ( $date ) – 25569 );$date = explode( '/', $gregorian );$date_str = str_pad( $date [2], 4, '0', STR_PAD_LEFT )."-". str_pad( $date [0], 2, '0', STR_PAD_LEFT )."-". str_pad( $date [1], 2, '0', STR_PAD_LEFT ). ($time ? " 00:00:00" : '');return $date_str;}}else{$date=$date>25568?$date+1:25569;/*There was a bug if Converting date before 1-1-1970 (tstamp 0)*/$ofs=(70 * 365 + 17+2) * 86400;$date = date("Y-m-d",($date * 86400) – $ofs).($time ? " 00:00:00" : '');}return $date;}?>
相反，某天也许你会忽然发现，心早已沦陷。
