您的SQL语法有误。查看与您的MySQL服务器版本相对应的手册，以获取在'附近使用的正确语法 [英] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
本文介绍了您的SQL语法有误。查看与您的MySQL服务器版本相对应的手册，以获取在'附近使用的正确语法的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
这是php代码，在上传时会执行phpexcel
This is the php code, where it perform phpexcel when it is being uploaded
if($model =="R2"){
for($j=8;$j<$avail_row;$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查询在这里，
Mysql query goes here,
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 "<br/>SQL: ".$strSQL_0."<br/>";
$ins_dataz = mysql_query ($strSQL_0,$link) or die ( "Sql error R2 : sql: ".$strSQL_0." <br/>error:".mysql_error());
//here
}
我确实尝试检查并我所有的数据都是正确的，但仍然显示此错误：
I did try check and all my data are correct,but it still showing this error:
Sql错误R2：sql：插入INTO total_data（supplier_name，商品，vendor_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'，'Penang'，'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服务器版本相对应的手册以获取正确的语法，以在第3行的'armhtctlineA_h2。，armhtctlineA_h3。，armhtctlineA_h4）VALUES（'JCY'，'AFA'，'附近使用
Sql error R2 : sql: INSERT INTO overall_data(supplier_name, commodity, supplier_site, WD_part_number, barcode, 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', 'Penang', '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', '', '', '', '', '') error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' armhtctlineA_h2., armhtctlineA_h3., armhtctlineA_h4) VALUES('JCY', 'AFA',' at line 3
推荐答案
您的查询应该像这样。
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 "<br/>SQL: ".$strSQL_0."<br/>";
$ins_dataz = mysql_query ($strSQL_0,$link) or die ( "Sql error R2 : sql: ".$strSQL_0." <br/>error:".mysql_error());
//here
}
或者如果您想防止SQL注入。
Or if you want to prevent-sql-injection.
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
set_exception_handler(function($e) {
error_log($e->getMessage());
exit('Error connecting to database'); //Should be a message a typical user could understand
});
$mysqli = new mysqli("localhost", "username", "password", "databaseName");
$mysqli->set_charset("utf8mb4");
$stmt = $mysqli->prepare("INSERT INTO myTable (".$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 (? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,?)");
$stmt->bind_param("si", ${$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]});
$stmt->execute();
$stmt->close();
这篇关于您的SQL语法有误。查看与您的MySQL服务器版本相对应的手册，以获取在'附近使用的正确语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
