問題代碼如下：error_reporting(E_ALL?^?E_NOTICE); ?//包含excel讀取類文件 ?require_once?'excel_reader2.php'; ?$data?=?new?Spreadsheet_Excel_Reader(); ?//設(shè)置文本輸出編碼 ?$data->setOutputEncoding('GBK'); ?//讀取Excel文件?$tmp_name為服務(wù)器存儲(chǔ)的臨時(shí)文件 ?$data->read($tmp_name); ? ?//把文件內(nèi)容存放到bhhn數(shù)據(jù)庫的reports表格中 ? ?//屏蔽報(bào)錯(cuò)機(jī)制 ?error_reporting(E_ALL?^?E_DEPRECATED); ?//連接sql數(shù)據(jù)庫 ?$link=mysql_connect("127.0.0.1","root",""); ?mysql_select_db('bhhn'); ?//設(shè)置文本輸出編碼 ?mysql_query("set?names?'GBK'"); ? ?//向reports數(shù)據(jù)表插入數(shù)據(jù) ?$arr=array($data->sheets[0]['cells'][2][3],$data->sheets[0]['cells'][2][5],$data->sheets[0]['cells'][2][8],$data->sheets[0]['cells'][2][10],$data->sheets[0]['cells'][5][2],$data->sheets[0]['cells'][5][3],$data->sheets[0]['cells'][5][4],$data->sheets[0]['cells'][5][5],$data->sheets[0]['cells'][5][6],$data->sheets[0]['cells'][5][7],$data->sheets[0]['cells'][5][8],$data->sheets[0]['cells'][5][9],$data->sheets[0]['cells'][5][10],$data->sheets[0]['cells'][5][11],$data->sheets[0]['cells'][7][2],$data->sheets[0]['cells'][7][4],$data->sheets[0]['cells'][7][5],$data->sheets[0]['cells'][7][6],$data->sheets[0]['cells'][7][7],$data->sheets[0]['cells'][8][3],$data->sheets[0]['cells'][8][8],$data->sheets[0]['cells'][10][2],$data->sheets[0]['cells'][10][3],$data->sheets[0]['cells'][10][4],$data->sheets[0]['cells'][10][5],$data->sheets[0]['cells'][10][6],$data->sheets[0]['cells'][10][7],$data->sheets[0]['cells'][10][8],$data->sheets[0]['cells'][10][9],$data->sheets[0]['cells'][13][2],$data->sheets[0]['cells'][13][3],$data->sheets[0]['cells'][13][4],$data->sheets[0]['cells'][13][5],$data->sheets[0]['cells'][13][6],$data->sheets[0]['cells'][13][7],$data->sheets[0]['cells'][13][8],$data->sheets[0]['cells'][13][9],$data->sheets[0]['cells'][13][10],$data->sheets[0]['cells'][13][11],$data->sheets[0]['cells'][14][2],$data->sheets[0]['cells'][15][2],$data->sheets[0]['cells'][16][2]);? //在這個(gè)位置插入print_r($arr)；可以看到arr數(shù)組中的數(shù)據(jù)是正確的 ?$sql="insert?into?reports(wellName,reportTime,DDName,tellNum,bigginDate,wellDepth,dateDrilling,bitTime,position,lithology,casingPipeDiameter,casingPipeDepth,KOPDepth,pipeDiameter,bitData,weightOnBit,rateOfFlow,RPM,pressure,deviceType,troubleAnalysis,density,viscosity,fluidLoss,mudCake,initialGelStrength,10-minutoGelStrength,PH,sandContent,MD,Inc,Azi,TVD,CloD,CloAz,forecastTargetDepth,targetTVD,forecastTargetCloD,forecastTargetCloAz,drillingToolStructure,projectPrograss,troubles)?values('$arr[0]','$arr[1]','$arr[2]','$arr[3]','$arr[4]','$arr[5]','$arr[6]','$arr[7]','$arr[8]','$arr[9]','$arr[10]','$arr[11]','$arr[12]','$arr[13]','$arr[14]','$arr[15]','$arr[16]','$arr[17]','$arr[18]','$arr[19]','$arr[20]','$arr[21]','$arr[22]','$arr[23]','$arr[24]','$arr[25]','$arr[26]','$arr[27]','$arr[28]','$arr[29]','$arr[30]','$arr[31]','$arr[32]','$arr[33]','$arr[34]','$arr[35]','$arr[36]','$arr[37]','$arr[38]','$arr[39]','$arr[40]','$arr[41]')"; ?mysql_query($sql);運(yùn)行的結(jié)果沒有報(bào)錯(cuò)，但是刷新Mysql數(shù)據(jù)庫沒有接到數(shù)據(jù)。嘗試了只對(duì)前邊5個(gè)字段插入，可以成功是插入語句對(duì)values值有個(gè)數(shù)限制呢，還是有其他錯(cuò)誤？初學(xué)，望不吝賜教