ดุโค๊ดอัพเดทให้หน่อยครับพี่ๆๆพอดีเพิ่งหัดเขียนครับ
Code (PHP) include("scripts/ConnectDB.php");
if (!$link)
echo "ERROR MYSQL";
else
{
mysql_select_db($DBName,$link);
$strSQL = "UPDATE sttb SET ";
$strSQL .="st_num = '".$_POST["st_num"]."' ";
$strSQL .="st_id = '".$_POST["st_id"]."' ";
$strSQL .=",st_card = '".$_POST["txtid_cade"]."' ";
$strSQL .=",st_mrs = '".$_POST["fmail"]."' ";
$strSQL .=",st_fname = '".$_POST["txtname"]."' ";
$strSQL .=",st_lname = '".$_POST["txtlastname"]."' ";
$strSQL .=",st_nickname = '".$_POST["txtnickname"]."' ";
$strSQL .=",st_nationality = '".$_POST["nationalit"]."' ";
$strSQL .=",st_nr = '".$_POST["nr"]."' ";
$strSQL .=",st_brday = '".$_POST["txtbrday"]."' ";
$strSQL .=",st_address = '".$_POST["address1"]."' ";
$strSQL .=",st_level = '".$_POST["level"]."' ";
$strSQL .=",st_age = '".$_POST["txtAge"]."' ";
$strSQL .=",income = '".$_POST["txtincome"]."' ";
$strSQL .=",ft_name = '".$_POST["txtftname"]."' ";
$strSQL .=",mt_name = '".$_POST["txtmtname"]."' ";
$strSQL .=",fmt_address = '".$_POST["address"]."' ";
$strSQL .=",fmt_tel = '".$_POST["txtphone"]."' ";
$strSQL .=",fmt_work = '".$_POST["work"]."' ";
$strSQL .="WHERE st_id = '".$_POST["st_id"]."' ";
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "Save Done.";
}
else
{
echo "Error Save [".$strSQL."]";
//echo "รหัส $ID";
}
mysql_close($link);
Tag
Date :
2010-02-06 14:46:53By :
นศ.View :
728Reply :
3
ลองเพิ่มส่วนสีแดงดูนะครับ มันจะแจ้ง error ว่าผิดพลาดอะไรor die (mysql_error()) ;
Date :
2010-02-06 15:04:13By :
DownsTream
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 'st_card = '0-0084-15333-33-2' ,st_mrs = 'ด.ช.' ,st_fname = 'สุรศักดิ์' ,st_lname' at line 1
Date :
2010-02-06 15:10:15By :
นศ.
ผมเปลี่ยนมาใช้อีกรูปแบบหนึ่งครับ Code (PHP) $stnum=$_POST["st_num"];
$stid=$_POST["st_id"];
$stcade=$_POST["txtid_cade"];
$stfmail=$_POST["fmail"];
$stname=$_POST["txtname"];
$stlname=$_POST["txtlastname"];
$stnickname=$_POST["txtnickname"];
$stnation=$_POST["nationalit"];
$stnr=$_POST["nr"];
$stbrday=$_POST["txtbrday"];
$staddress1=$_POST["address1"];
$stlevel=$_POST["level"];
$stAge=$_POST["txtAge"];
$stincome=$_POST["txtincome"];
$ftname=$_POST["txtftname"];
$mtname=$_POST["txtmtname"];
$address=$_POST["address"];
$tel=$_POST["txtphone"];
$work=$_POST["work"];
echo $work;
include("scripts/ConnectDB.php");
if (!$link)
echo "ERROR MYSQL";
else
{
mysql_select_db($DBName,$link);
//mysql_query("SET NAMES TIS620");
mysql_query("SET NAMES UTF8");
$strSQL=" UPDATE tbst SET st_card='$stcade',st_mrs='$stfmail',st_lname='$stlname',st_nickname='$stnickname',st_nationality='$stnation',st_nr='$stnr',st_brday='$stbrday',st_address='$staddress1',st_level='$stlevel',st_age='$stAge',income='$stincome',ft_name='$ftname',mt_name='$mtname',fmt_address='$address',fmt_tel='$tel',fmt_work='$work' WHERE st_id='$stid' ";
$objQuery = mysql_query($strSQL)or die (mysql_error());
if($objQuery)
{
echo "Save Done.";
echo $stid;
}
else
{
echo "Error Save [".$strSQL."]";
//echo "รหัส $ID";
}
mysql_close($link);
Date :
2010-02-06 15:47:46By :
นศ.
Server 03
Load balance : Server 03
