;检查对应于你的mysql服务器版本使用附近的正确的语法手册_您的SQL语法错误; 检查对应于你的MySQL服务器版本使用附近的“正确的语法手册(You ha...

这是PHP代码，其中当正在上传它对其执行phpexcel

if($model =="R2"){

for($j=8;$j

{

$content[$data[0]][$counter_2] = "JCY";

$content[$data[2]][$counter_2] = "Penang";

$content[$data[3]][$counter_2] = $objWorksheet->getCellByColumnAndRow(1,$j)->getCalculatedValue();

$content[$data[4]][$counter_2] = $objWorksheet->getCellByColumnAndRow(2,$j)->getCalculatedValue();

$content[$data[5]][$counter_2] = $model;

$content[$data[6]][$counter_2] = $objWorksheet->getCellByColumnAndRow(3,$j)->getCalculatedValue();

$cmd = substr($content[$data[6]][$counter_2],0,1);

if($cmd =='Y')

{

$content[$data[1]][$counter_2] = 'AFA';

}

else

{

$content[$data[1]][$counter_2] = 'APFA';

}

$date = PHPExcel_Style_NumberFormat::toFormattedString($objWorksheet->getCellByColumnAndRow(4,$j)->getCalculatedValue(), 'yyyy-mm-dd');

$time = PHPExcel_Style_NumberFormat::toFormattedString($objWorksheet->getCellByColumnAndRow(5,$j)->getCalculatedValue(), 'hh:mm:ss');

$combine = $date.' '.$time;

$combine_02 = strtotime("$combine");

$content[$data[7]][$counter_2] = date("Y-m-d H:i:s",$combine_02);

//echo $content[$data[7]][$counter_2];

$content[$data[8]][$counter_2] = $objWorksheet->getCellByColumnAndRow(6,$j)->getCalculatedValue(); //lot

$content[$data[9]][$counter_2] = $objWorksheet->getCellByColumnAndRow(12,$j)->getCalculatedValue(); //lower coil height

$content[$data[10]][$counter_2] = $objWorksheet->getCellByColumnAndRow(11,$j)->getCalculatedValue(); //upper coil height

$content[$data[11]][$counter_2] =''; //armrollH0Front

$content[$data[12]][$counter_2]=''; //armrollH0Mid

$content[$data[13]][$counter_2]=$objWorksheet->getCellByColumnAndRow(13,$j)->getCalculatedValue(); //armrollH0Rear

$content[$data[14]][$counter_2]=''; //armrollH1Front

$content[$data[15]][$counter_2]=''; //armrollH1Mid

$content[$data[16]][$counter_2]=$objWorksheet->getCellByColumnAndRow(14,$j)->getCalculatedValue(); //armrollH1Rear

$content[$data[17]][$counter_2]='';

$content[$data[18]][$counter_2]=''; //armrollH2Mid

$content[$data[19]][$counter_2]=$objWorksheet->getCellByColumnAndRow(15,$j)->getCalculatedValue(); //armrollH2Rear

$content[$data[20]][$counter_2]=''; //armrollH3Front

$content[$data[21]][$counter_2]=''; //armrollH3Mid

$content[$data[22]][$counter_2]=$objWorksheet->getCellByColumnAndRow(16,$j)->getCalculatedValue(); //armrollH3Rear

$content[$data[23]][$counter_2]=''; //armrollH4Front

$content[$data[24]][$counter_2]=''; //armrollH4Mid

$content[$data[25]][$counter_2]=$objWorksheet->getCellByColumnAndRow(17,$j)->getCalculatedValue(); //armrollH4Rear

$content[$data[26]][$counter_2]=''; //armrollH5Front

$content[$data[27]][$counter_2]=''; //armrollH5Mid

$content[$data[28]][$counter_2]=$objWorksheet->getCellByColumnAndRow(18,$j)->getCalculatedValue(); //armrollH5Rear

$content[$data[29]][$counter_2]=''; //armrollH6Front

$content[$data[30]][$counter_2]=''; //armrollH6Mid

$content[$data[31]][$counter_2]=''; //armrollH6Rear

$content[$data[32]][$counter_2]=''; //armrollH7Front

$content[$data[33]][$counter_2]=''; //armrollH7Mid

$content[$data[34]][$counter_2]=''; //armrollH7Rear

$content[$data[35]][$counter_2]=''; //armrollH8Front

$content[$data[36]][$counter_2]=''; //armrollH8Mid

$content[$data[37]][$counter_2]=''; //armrollH8Rear

$content[$data[38]][$counter_2]=''; //armrollH9Front

$content[$data[39]][$counter_2]=''; //armrollH9Mid

$content[$data[40]][$counter_2]=''; //armrollH9Rear

$content[$data[41]][$counter_2]=''; //armrollH10Front

$content[$data[42]][$counter_2]=''; //armrollH10Mid

$content[$data[43]][$counter_2]=''; //armrollH10Rear

$content[$data[44]][$counter_2]=''; //armrollH11Front

$content[$data[45]][$counter_2]=''; //armrollH11Mid

$content[$data[46]][$counter_2]=''; //armrollH11Rear

$content[$data[47]][$counter_2]=''; //armrollH12Front

$content[$data[48]][$counter_2]=''; //armrollH12Mid

$content[$data[49]][$counter_2]=''; //armrollH12Rear

$content[$data[50]][$counter_2]=''; //armrollH13Front

$content[$data[51]][$counter_2]=''; //armrollH13Mid

$content[$data[52]][$counter_2]=''; //armrollH13Rear

$content[$data[53]][$counter_2]=''; //armrollH14Front

$content[$data[54]][$counter_2]=''; //armrollH14Mid

$content[$data[55]][$counter_2]=''; //armrollH14Rear

$content[$data[56]][$counter_2]=''; //armrollH15Front

$content[$data[57]][$counter_2]=''; //armrollH15Mid

$content[$data[58]][$counter_2]=''; //armrollH15Rear

$content[$data[59]][$counter_2]=''; //armrollH16Front

$content[$data[60]][$counter_2]=''; //armrollH16Mid

$content[$data[61]][$counter_2]=''; //armrollH16Rear

$content[$data[62]][$counter_2]=''; //armrollH17Front

$content[$data[63]][$counter_2]=''; //armrollH17Mid

$content[$data[64]][$counter_2]=''; //armrollH17Rear

$content[$data[65]][$counter_2] =''; //minpivottorque

$content[$data[66]][$counter_2] =''; //averagepivottorque

$content[$data[67]][$counter_2] =''; //peakpivottorque

$content[$data[68]][$counter_2] =''; //pivotparallelism

$content[$data[69]][$counter_2] =''; //flextodatumd

$content[$data[70]][$counter_2] =''; //ubendstiffener

$content[$data[71]][$counter_2] =''; //tring

$content[$data[72]][$counter_2] ='Y'; //OQA

$content[$data[74]][$counter_2] =''; //armrollheadbottomfront

$content[$data[75]][$counter_2] =''; //armrollBottomMid

$content[$data[76]][$counter_2] =''; //armrollheadbottomrear

$content[$data[77]][$counter_2] =''; //armrollheadtopfront

$content[$data[78]][$counter_2] ='';

$content[$data[79]][$counter_2] =''; //armrollheadtoprear

$content[$data[80]][$counter_2] = '';

//81=>'pnta1',

$content[$data[81]][$counter_2] ='';

//82=>'pnta2',

$content[$data[82]][$counter_2] ='';

//83=>'pnta3',

$content[$data[83]][$counter_2] ='';

//84=>'pnta4',

$content[$data[84]][$counter_2] ='';

//85=>'pnta5',

$content[$data[85]][$counter_2] ='';

//86=>'pnta6',

$content[$data[86]][$counter_2] ='';

//87=>'pnta7',

$content[$data[87]][$counter_2] ='';

//88=>'pnta8',

$content[$data[88]][$counter_2] ='';

//89=>'pnta9',

$content[$data[89]][$counter_2] ='';

//90=>'pnta10',

$content[$data[90]][$counter_2] ='';

//91=>'pnta11',

$content[$data[91]][$counter_2] ='';

//92=>'pnta12',

$content[$data[92]][$counter_2] ='';

//93=>'pnta13',

$content[$data[93]][$counter_2] ='';

//94=>'pnta14',

$content[$data[94]][$counter_2] ='';

//95=>'pnta15',

$content[$data[95]][$counter_2] ='';

//96=>'pnta16',

$content[$data[96]][$counter_2] ='';

//97=>'pntb1',

$content[$data[97]][$counter_2] ='';

//98=>'pntb2',

$content[$data[98]][$counter_2] ='';

//99=>'pntb3',

$content[$data[99]][$counter_2] ='';

//100=>'pntb4',

$content[$data[100]][$counter_2] ='';

//101=>'pntb5',

$content[$data[101]][$counter_2] ='';

//102=>'pntb6',

$content[$data[102]][$counter_2] ='';

//103=>'pntb7',

$content[$data[103]][$counter_2] ='';

//104=>'pntb8',

$content[$data[104]][$counter_2] ='';

//105=>'pntb9',

$content[$data[105]][$counter_2] ='';

//106=>'pntb10',

$content[$data[106]][$counter_2] ='';

//107=>'pntb11',

$content[$data[107]][$counter_2] ='';

//108=>'pntb12',

$content[$data[108]][$counter_2] ='';

//109=>'pntb13',

$content[$data[109]][$counter_2] ='';

//110=>'pntb14',

$content[$data[110]][$counter_2] ='';

//111=>'pntb15',

$content[$data[111]][$counter_2] ='';

//112=>'pntb16',

$content[$data[112]][$counter_2] ='';

//113=>'armp1',

$content[$data[113]][$counter_2] ='';

//114=>'armp2',

$content[$data[114]][$counter_2] ='';

//115=>'armp3',

$content[$data[115]][$counter_2] ='';

//116=>'armp4',

$content[$data[116]][$counter_2] ='';

//117=>'armp5',

$content[$data[117]][$counter_2] ='';

//118=>'armp6',

$content[$data[118]][$counter_2] ='';

//119=>'armp7',

$content[$data[119]][$counter_2] ='';

//120=>'armp8',

$content[$data[120]][$counter_2] ='';

//121=>'armp9',

$content[$data[121]][$counter_2] ='';

//122=>'armp10',

$content[$data[122]][$counter_2] ='';

//122=>'armp10',

$content[$data[123]][$counter_2] ='';

//123=>'armp11',

$content[$data[124]][$counter_2] ='';

//124=>'armp12',

$content[$data[125]][$counter_2] ='';

//125=>'armp13',

$content[$data[126]][$counter_2] ='';

//126=>'armp14',

$content[$data[127]][$counter_2] ='';

//128=>'armp16',

$content[$data[128]][$counter_2] ='';

//129=>'starttorque',

$content[$data[129]][$counter_2] ='';

//130=>'torque45',

$content[$data[130]][$counter_2] =''; //P-P Torque 45

//131=>'torque360'

$content[$data[131]][$counter_2] =''; //P-P Torque 360

$content[$data[132]][$counter_2]=$objWorksheet->getCellByColumnAndRow(19,$j)->getCalculatedValue();//Arm Height Center Line Point a H1

$content[$data[133]][$counter_2]=$objWorksheet->getCellByColumnAndRow(20,$j)->getCalculatedValue(); //Arm Height Center Line Point a H2

$content[$data[134]][$counter_2]=$objWorksheet->getCellByColumnAndRow(21,$j)->getCalculatedValue(); //Arm Height Center Line Point a H3

$content[$data[135]][$counter_2]=$objWorksheet->getCellByColumnAndRow(22,$j)->getCalculatedValue(); //Arm Height Center Line Point a H4

$counter_2++;

}

}

MySQL查询到这里，

if($model == "R2"){

//72, 73

//73 => 'N'

$strSQL_0 = "INSERT INTO overall_data(".$data[0].", ".$data[1].", ".$data[2].", ".$data[3].", ".$data[4].", ".$data[5].",

".$data[6].", ".$data[7].", ".$data[8].", ".$data[9].", ".$data[10].", ".$data[13].", ".$data[16].", ".$data[19].",

".$data[22].", ".$data[25].", ".$data[28].", ".$data[66].", ".$data[67].", ".$data[68].", ".$data[72].", ".$data[73].", ".$data[131].", ".$data[132]."., ".$data[133]."., ".$data[134]."., ".$data[135].")

VALUES('". ${$data[0]} ."', '". ${$data[1]} ."', '". ${$data[2]} ."', '". ${$data[3]} ."', '". ${$data[4]} ."',

'". ${$data[5]} ."', '". ${$data[6]} ."', '". ${$data[7]} ."', '". ${$data[8]} ."', '". ${$data[9]} ."',

'". ${$data[10]} ."', '". ${$data[13]} ."', '". ${$data[16]} ."', '". ${$data[19]} ."', '". ${$data[22]} ."', '". ${$data[25]} ."', '". ${$data[28]} ."', '". ${$data[66]} ."', '". ${$data[67]} ."', '". ${$data[68]} ."', '". ${$data[72]} ."', 'N', '". ${$data[131]} ."', '". ${$data[132]} ."', '". ${$data[133]} ."', '". ${$data[134]} ."', '". ${$data[135]} ."')";

//echo "
SQL: ".$strSQL_0."
";

$ins_dataz = mysql_query ($strSQL_0,$link) or die ( "Sql error R2 : sql: ".$strSQL_0."
error:".mysql_error());

//here

}

我也尝试检查，我所有的数据都是正确的，但它仍然显示此错误：

SQL错误R2：SQL：INSERT INTO overall_data(supplier_name，商品，supplier_site，WD_part_number，条码，prod_codes，trayno，datetimez，lotno，lowercoilheight，uppercoilheight，armrollH0Rear，armrollH1Rear，armrollH2Rear，armrollH3Rear，armrollH4Rear，armrollH5Rear，averagepivottorque，peakpivottorque，pivotparallelism， OQA，exp_sts，torque360，armhtctlineA_h1。，armhtctlineA_h2，armhtctlineA_h3。，armhtctlineA_h4)VALUES( 'JCY'， 'AFA'， '槟'， '2053800250B07'， '7CG1FA11DD0R2'， 'R2'， 'YCG12053800250B07BE02M0'，“2019- 07-10 12时58分43' 秒，'02 -0776' ， '5.1793'， '7.3747'， '0.03'， '0.036'， '0.051'， '0.097'， '0.045'， '0.097'， '' ， ''， ''， 'Y'， 'N'， ''， ''， ''， ''， '')的错误：你在你的SQL语法错误; 检查对应于你的MySQL服务器版本使用附近的正确语法手册“armhtctlineA_h2，armhtctlineA_h3，armhtctlineA_h4)VALUES(” JCY“‘AFA’，”第3行