¥xÆW³Ì¤jµ{¦¡³]­pªÀ¸sºô¯¸
½u¤W¤H¼Æ
888
 
·|­ûÁ`¼Æ¡G246713
°Q½×¥DÃD¡G190131
Åwªï±z§K¶O¥[¤J·|­û
°Q½×°Ï¦Cªí >> MySQL >> ¹J¨ìŪ¼g°ÝÃD¡A·Ð½Ð¤j¤jÀ°¦£¸Ñµª
[]  
[§Ú­n¦^ÂÐ]
1
¦^À³¥DÃD ¥[¤J§ÚªºÃöª`¸ÜÃD ÀËÁ|¦¹½g°Q½× ±N´£°ÝªÌ¥[¤J­Ó¤H¶Â¦W³æ
¹J¨ìŪ¼g°ÝÃD¡A·Ð½Ð¤j¤jÀ°¦£¸Ñµª
»ù­È : 50 QP  ÂI¾\¼Æ:1138 ¦^À³¼Æ:7
¼Ó¥D

Alex
ªù¥~º~
0 2
62 14
µo°e¯¸¤º«H

®½ÃØ VP µ¹ Alex
­Ó¤H³]©w»PMysql³sµ²¦p¤U¡A¥D­n¬°Åª¨ú¸ê®Æ®w¸ê®Æ©ó­ì©lºô­¶Åã¥Ü¡A¨Ã³z¹LÅv­­³]©w¶}©ñ­×§ï¡A
­×§ï§¹¦¨«á¡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);
}

?>

·j´M¬ÛÃöTagsªº¤å³¹¡G [ ¸ê®ÆÂл\ ] , [ Mysql ] , [ php ] ,
¥»½g¤å³¹µoªí©ó2015-11-13 09:57
== ñ¦WÀÉ ==
«D¸ê¤u¬ÛÃö¬ì¨t¡A­Yµo°Ý¦³ÂI¥Õ½Ð¦h¦h¥]²[¡C
1¼Ó
¦^À³

¯EÃv¬PªÅ
®½ÃØ VP µ¹ ¯EÃv¬PªÅ ÀËÁ|¦¹¦^À³
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
®½ÃØ VP µ¹ 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¼Ó
¦^À³

¯EÃv¬PªÅ
®½ÃØ VP µ¹ ¯EÃv¬PªÅ ÀËÁ|¦¹¦^À³
¤£­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§A­nªºª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
®½ÃØ VP µ¹ 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ªÅ
®½ÃØ VP µ¹ ¯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Äæ¦ì¶Ü???¨º¬O­n¦s¤°»ò???
¥»½g¤å³¹¦^ÂЩó2015-11-25 10:23
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
6¼Ó
§@ªÌ¦^À³

Alex
®½ÃØ VP µ¹ Alex ÀËÁ|¦¹¦^À³
­ì©lªººô­¶³]­p»¡©ú¦p¤U¡A¥D­n¬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
®½ÃØ VP µ¹ Alex ÀËÁ|¦¹¦^À³
¦Û¦æ¥[³]¤@¨Ç¥\¯à¡A±ý¸j­q¤H­ûÅv­­«á¡A¤è¥iÅã¥Ü¨Ã¶i¦æ¸Ñ°£Âê©w¡A¶i¦æ¸ê®ÆÅܧó«á¦A¦æ¤W¶ÇÂл\­ì©l¸ê®Æ¡A
©Ò¥H¤~·|Åã¥Ü¤W­z°ÝÃD¡A
Åܧó«áµ{¦¡½X¦p¤U¡G


¥»½g¤å³¹¦^ÂЩó2015-11-25 14:53
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
   
1

¦^ÂÐ
¦p­n¦^À³,½Ð¥ýµn¤J.