![]() ![]() ![]() ![]() |
|||||
|
|||||
¼Ó¥D Alex ![]()
![]() ![]() |
×§ï§¹¦¨«á¡A±N¸ê®ÆÂл\¤W쥻¸ê®Æ¤º®e¡A×§ï«á°T®§¦p¤U¡G ק異±Ñ!! 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 "1111".(¬Ù²¤) at line 1 ·Ð½Ð¤j¤jÀ°¦£¬Ý¬Ý¨ºÃä¥X¤F°ÝÃD¾ÉPµLªk»\¤W¡AÁÂÁÂ! <?php session_start(); if( $_SESSION["login_session"]!=true ){ header("Location: ../../login.php"); } $user_name = $_SESSION['user_name']; $user_permission = $_SESSION['user_permission']; $checknum = null; if( isset($_GET['query_checkno']) ) { $checknum = $_GET['query_checkno']; } $link = mysql_connect('localhost', 'AAA', 'AAA') or die("¸ê®Æ®wµLªk³s±µ\n"); mysql_select_db('e-forms_opening_check', $link); mysql_query("SET NAMES utf8"); $sql = "SELECT * FROM `XXXXXXXX` WHERE `checkno`='".$checknum."'"; $result = mysql_query($sql, $link); $row = mysql_fetch_array($result); if( isset($_GET['checknum']) ) { $checknum = $_GET['checknum']; } if( isset($_GET['submit_checknum']) ) { $checknum = $_GET['submit_checknum']; $temp = preg_split('[-]',$checknum); $shift = $_SESSION['current_shift']; $area = $temp[2]; $station = $temp[3]; $machine = $temp[4]; $number = $temp[5]; $time = $temp[6]; } if( isset($_GET['data_array']) ){ $data_array = preg_split('[,]',$_GET['data_array']); $field = array("date","time","shift","area","station","machine","number","checkno","prepared_by_person","doc_no","1","2","3","4","5","6","7"); $value = array(date("Y-m-d"),$time,$shift,$area,$station,$machine,$number,$checknum,$user_name,"AAAAAAAA)"); $value_Index = 10; for( $i=0; $i<count($data_array); $i++ ){ $value[$value_Index++] = $data_array[$i]; } $temp1 = implode("`,`",$field); $temp2 = implode("','",$value); $sql_update = "update `XXXXXXXX` Set temp1='{$temp1}',temp2='{$temp2}'"; if (mysql_query($sql_update, $link)) { echo '<script type="text/javascript">alert("ק令¥\!!\nFinish!!")</script>'; header("Refresh: 0.1; url=..\..\main.php"); } else{ echo '<script type="text/javascript">alert("ק異±Ñ!!\nError!!\n'.mysql_error().'")</script>'; header("Refresh: 0.1; url=..\..\main.php"); } mysql_close($link); } ?>
== ñ¦WÀÉ ==
«D¸ê¤u¬ÛÃö¬ì¨t¡AYµo°Ý¦³ÂI¥Õ½Ð¦h¦h¥]²[¡C |
1¼Ó |
1.½Ðµ½¥Îµ{¦¡¼Ðñ
¨Ì·Ó§Aªº¿ù»~°T®§¥Nªíªº¬Osql»yªk¤£¥¿±`¡C ¥Ñ©ó§A¨Ã¥¼¥Îµ{¦¡¼Ðñ¡C¤ñ¸ûÃø¸ò§A»¡©ú¡C ¤£¹L¤j¬ùª¾¹D§A¥i¯àªº°ÝÃD¬Oµo¥Í¦b $temp2 = implode("','",$value); ³o¬O°²³]§Aªº$valueȬOArray('a','b') §Aªºsql»yªk«á±´N·|Åܦ¨ temp2='a','b'; ³o¼Ë¤l¥Î¬Ýªº¤]ª¾¹Dsql»yªk´N¤£¥¿½T¤F¡C
¥»½g¤å³¹¦^ÂЩó2015-11-13 10:25
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
2¼Ó
§@ªÌ¦^À³
Alex ![]() ![]() |
Dear ¤j¤j
¥i¬Oì©lºô¶Àɮ׬O¥i¥H¦s¤Jªº¡A¦s¤JMysql¤]¬O¥¿½Tªº¡A¦ý¬O²{¦b¬O×§ï¸ê®Æ®É¡Aµo¥Í°ÝÃD¡A $value = array(date("Y-m-d"),$time,$shift,$area,$station,$machine,$number,$checknum,$user_name,"AAAAAAAA)"); ½Ð°Ý±z»¡ªºµ{¦¡¼ÐÅÒ¬O¤°»ò·N«ä¡H
¥»½g¤å³¹¦^ÂЩó2015-11-13 17:20
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
3¼Ó |
¤£n¥h»¡¤°»òì©lÀÉ®×¥i¥H¦s¤Jªº°ÝÃD¡C¦]¬°¨º¤£¬O§A¥ÎªºªF¦è¡C
°t¸mªº¤è¦¡¤]¬O¤£¦P¡C «ÂI¬O¡A§Ú¥i¥H«Oµýªº»¡¡A§A¤@©w¬O¹ïì©lÀɮתº¼gªk¤£¤F¸Ñ¡C¤~·|µo¥Í³o¼Ëªº¨Æ¡C §Ú¤W±»¡¤F¡A¥ú¬Ý§A«á±¿é¥Xªº»yªk´N¤w¸g¬O¤£¥¿½T¤F¡C §A¦]¸Ón©¹³o¤è±¥h·Q¡C¦Ó¤£¬O»¡¡u§Ú©ú©ú·Ó§Û¨Ï¥Î¤F¡A¬°¦ó¤£¯à°Ê¡Aì¨Óªº¥i¥H°Ú¡v ·|¤£¯à¥Îªºì¦]¡A¤@©w¬O§A¹ï°Ñ¼Æªº¥Î·N¤£¤F¸Ñ¡C ì¨Óªº¥i¥H¥Î???¦ý¤£¯à²Å¦X§AnªºªF¦è´N¬O¤£¯à¥ÎªºªF¦è¡C³oÂI¹D²z§A¦]¸ÓnÀ´ªº¡C µ{¦¡¼Ðñ¡A´N¬O³oùتº½s¿è¾¹¤W¡C¤£¬O¦³«Ü¦h¡uc»y¨¥¡v¡ujs¡v¡uvb¡v......³o¨Ç¶Ü??? ±Nµ{¦¡½X©ñ¨ì³o¨Ç¼Ðñªº¤º®e¤º¡C´N·|¥X²{¦æ¸¹¡C¨Ã¥B·|¨Ì·Óµ{¦¡ªº±Æª©Åã¥Ü¡C¤£·|¦Û°Ê¾a¥ª¡C(¤£Ä±±o§Aªºµ{¦¡½X³o¼Ë«ÜÃø§PÂ_¶Ü??) §Ú¥uª`·N¨ì§A³oÃ䪺°ÝÃD ¨ä¹ê¬Ý§A³o¼Ë¼g¡A´N¥i¥H©ú¥Õ§A¤@©w¬O¹ïì¨ÓÀɮתºªF¦è¤£¤F¸Ñ¡C¤~·|Åܦ¨³o¼Ë¡C ³oÃä¤@¬Ý´Nª¾¹D¡C¨ä$field´N¬OÄæ¦ìÈ¡C$value¬O¸ê®ÆÈ¡C ©Ò¥H¤~·|¦³³o¼Ëªºµ²¦X¤å¦r¦êªº¤è¦¡¡C ¦ý§A¥Î¿ù¤F~~~~§A±N¨âÓ³£·í¸ê®ÆÈ¨Ï¥Î¡C¦ÛµM´N¥X¿ù¤F¡C ¦ý§A§ï¦¨update¥Îªºset»yªk¡C¤£¹L§A¤£¤F¸Ñ¥¦ªº¥Î·N¬O°µ¤°»ò¥Îªº¡C §Ú¥Î²³æªº»¡©ú¦n¤F¡C§A¥i¥H¦b¨º¬q $sql_update ¤U©ñÓecho $sql_update; µM«á¬Ý¤@¤U¥¦¹ê»Ú¸ÑŪ¥X¨Óªºsql»yªk¬O¤°»ò¡C ¦pªG§A¹ïsql»yªk¼ôªº¸Ü¡C¦ÛµM´N¥i¥H¬Ý¥X°ÝÃD¦bþ¤F¡C ¦pªG§A¹ïsql»yªk¤£¼ô¡C¯u¤£ª¾¹Dµo¥Í¤°»ò¨Æ¡C§Ú¦A¨Ó§i¶D§A«ç»ò×§ï¡C ¦ý§Ú§Æ±æ§A¦Û¦æ¥h¤F¸Ñ¬°¦ó¤£¯à¹B¦æ¡C »{¯u¨Ó»¡¡A³o¤w¸g¤£¬Omysqlªº°ÝÃD¤F¡C¦Ó¬Ophpªº°ÝÃD¤F¡C
¥»½g¤å³¹¦^ÂЩó2015-11-17 14:47
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
4¼Ó
§@ªÌ¦^À³
Alex ![]() ![]() |
ÁÂÁ¤j¤jªº¦^À³¡A¦³§âecho $sql_update;¥[¤J
±o¨ì ק異±Ñ!! 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 "1111".(¬Ù²¤) at line 1 update 'XXXXXX' Set temp1='¬Ù²¤'....,temp2 = '¬Ù²¤'.... ¿é¥Xªº¼ÆÈÁÙ¬O¤@¼Ëªº¡Aµ²ªG¤Ï¦ÓµLªk¦s¤J¶i¥h¡A ¤p§Ì½T¹ê¤£¬O¸ê¤u¬ÛÃöªº¡A·Ð½Ð«ü¾É¤@¤U¡AÁÂÁ¡C
¥»½g¤å³¹¦^ÂЩó2015-11-23 17:14
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
5¼Ó
³Ì¦³»ùȸѵª
¯EÃv¬PªÅ ![]() ![]() |
¨º´N½Ð§A´£¨Ñ§Aªº¸ê®Æªí¸`ºc¡CÁÙ¬O§A¥´ºâ°µ¤°»ò¨Æ¡C
§Ú·Pı§A¤w¸g¬O§¹¥þ·d²V¤F¡C ²³æ¨Ó°Ý¦n¤F¡C§Aªºxxxxx¸ê®Æªí¤º¡C¦³temp1Äæ¦ì¶Ü???¨º¬On¦s¤°»ò???
¥»½g¤å³¹¦^ÂЩó2015-11-25 10:23
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
6¼Ó
§@ªÌ¦^À³
Alex ![]() ![]() |
ì©lªººô¶³]p»¡©ú¦p¤U¡A¥Dn¬O¬d¸ß¹L©¹ªº¬ö¿ý¡A¨Ã¥BÅã¥Ü¦bì©l¶ñ¼gªí³æªº¶±¤è¦¡§e²{¡A
¥»½g¤å³¹¦^ÂЩó2015-11-25 14:51
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
7¼Ó
§@ªÌ¦^À³
Alex ![]() ![]() |
¦Û¦æ¥[³]¤@¨Ç¥\¯à¡A±ý¸jq¤HûÅv«á¡A¤è¥iÅã¥Ü¨Ã¶i¦æ¸Ñ°£Âê©w¡A¶i¦æ¸ê®ÆÅܧó«á¦A¦æ¤W¶ÇÂл\ì©l¸ê®Æ¡A
©Ò¥H¤~·|Åã¥Ü¤Wz°ÝÃD¡A Åܧó«áµ{¦¡½X¦p¤U¡G
¥»½g¤å³¹¦^ÂЩó2015-11-25 14:53
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ-- |
¦^ÂÐ |
¦pn¦^À³,½Ð¥ýµn¤J. |