ขอความช่วยเหลือด้วยครับ อัพเดทข้อมูลลงฐานข้อมูลไม่ได้ งงมากเลยครับ
Code (PHP) <form name="checkForm" action="edit_add_member.php" method="post" onSubmit="return check2();">
<table border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td width="248"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">คำนำหน้า </font></td>
<td><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<select name="titleid" id="titleid">
<?php
$q="select title.titleid, title.titlename, member.titleid from title LEFT JOIN member on title.titleid=member.titleid";
$qr=mysql_query($q);
while($rs=mysql_fetch_array($qr)){
?>
<option value="<?=$rs['titileid']?>" selected>
<?=$rs['titlename']?>
</option>
<?php } ?>
</select>
</font></td>
<td width="201"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">Username <u><b><?php echo $dbarr['Username'] ; ?></b></u></font></td>
</tr>
<tr>
<td><font size="2" face="MS Sans Serif, Tahoma, sans-serif">ชื่อ-นามสกุล
: </font></td>
<td colspan="2"><div align="left"></div>
<font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<input name="name" type="text" size="20" value="<?php echo "$dbarr[name]" ; ?>">
</font></td>
</tr>
<tr>
<td><font size="2" face="MS Sans Serif, Tahoma, sans-serif">เพศ</font></td>
<td colspan="2"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<input name="sex" type="text" value="<?php echo $dbarr['sex'] ; ?>" size="5" maxlength="3">
</font></td>
</tr>
<tr>
<td height="2"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">วัน/เดือน/ปีเกิด</font></td>
<td colspan="2"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<input name="date" type="text" id="date" value="<?php echo $dbarr['date'] ; ?>" size="20">
</font></td>
</tr>
<tr>
<td><font size="2" face="MS Sans Serif, Tahoma, sans-serif">รหัสนักศึกษา</font></td>
<td colspan="2"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<input name="std_id" type="text" id="std_id" value="<?php echo $dbarr['std_id'] ; ?>" size="20">
</font></td>
<tr>
<td><font size="2" face="MS Sans Serif, Tahoma, sans-serif">อายุ</font></td>
<td colspan="2"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<input name="age" type="text" value="<?php echo $dbarr['age'] ; ?>" size="5" maxlength="3">
</font></td>
<tr>
<td colspan="6"><div align="center"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">..............................................................................................................................................</font></div></td>
<tr>
<td colspan="6"><p><img src="image/home0.gif" width="16" height="15">
<font color="#0000FF" size="3" face="MS Sans Serif, Tahoma, sans-serif"><u><font color="#CC00FF">ที่อยู่ในการติดต่อ</font></u>
<br>
<br>
</font></p></td>
</tr>
<tr>
<td><font size="2" face="MS Sans Serif, Tahoma, sans-serif">บ้านเลขที่
</font></td>
<td colspan="4"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<input name="address" type="text" value="<?php echo $dbarr['address'] ; ?>">
</font></td>
<td width="59"><img src="image/w1.gif" width="19" height="19" align="absmiddle"><font color="#FF0000" size="2" face="MS Sans Serif, Tahoma, sans-serif">(edit)</font></td>
</tr>
<tr>
<td><font size="2" face="MS Sans Serif, Tahoma, sans-serif">อำเภอ</font></td>
<td colspan="5"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<select name="AMPHUR_ID" id="AMPHUR_ID">
<?php
$q="select * from amphur ";
$qr=mysql_query($q);
while($rs=mysql_fetch_array($qr)){
?>
<option value="<?=$rs['AMPHUR_ID']?>">
<?=$rs['AMPHUR_NAME']?>
</option>
<?php } ?>
</select>
</font></td>
</tr>
<tr>
<td><font size="2" face="MS Sans Serif, Tahoma, sans-serif">จังหวัด</font></td>
<td width="182"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<select name="PROVINCE_ID" id="PROVINCE_ID">
<?php
$q="select * from province ";
$qr=mysql_query($q);
while($rs=mysql_fetch_array($qr)){
?>
<option value="<?=$rs['PROVINCE_ID']?>" selected>
<?=$rs['PROVINCE_NAME']?>
</option>
<?php } ?>
</select>
</font></td>
<td colspan="4"> </td>
</tr>
<tr>
<td><div align="left"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">รหัสไปรษณีย์</font></div></td>
<td width="182"><div align="left"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<input name="zipcode" type="text" value="<?php echo $dbarr['zipcode'] ; ?>" size="10" maxlength="15">
</font></div></td>
<td colspan="4"> </td>
</tr>
<tr>
<td><font size="2" face="MS Sans Serif, Tahoma, sans-serif">เบอร์โทรศัพท์</font></td>
<td colspan="5"><font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<input name="phone" type="text" id="phone" value="<?php echo $dbarr['phone'] ;?>">
</font></td>
</tr>
</table>
<div align="center"><br>
<input name="member_id" type="hidden" id="member_id" value="<?php echo $dbarr['member_id'] ; ?>">
<a href="logout.php"><img src="image/logout.gif" width="58" height="22" border="0" align="absbottom"></a>
<font size="2" face="MS Sans Serif, Tahoma, sans-serif">
<input type="submit" name="Submit2" value="บันทึกการเปลี่ยนแปลง">
</font></div>
Tag PHP
ประวัติการแก้ไข
Date :
2014-03-07 03:39:50By :
nyebankView :
772Reply :
6
Code (PHP) <?php
include("config.inc.php") ;
mysql_select_db($db) ;
$sql[0] = "update member set titleid='$titleid' where Username='$Username' ";
$sql[1]= "update member set name='$name' where Username='$Username' ";
$sql[2] = "update member set sex='$sex' where Username='$Username' ";
$sql[3] = "update member set date='$date' where Username='$Username' ";
$sql[4] = "update member set age='$age' where Username='$Username' ";
$sql[5] = "update member set address='$address' where Username='$Username' ";
$sql[6] = "update member set AMPHUR_ID='$AMPHUR_ID' where Username='$Username' ";
$sql[7] = "update member set PROVINCE_ID='$PROVINCE_ID' where Username='$Username' ";
$sql[8] = "update member set zipcode='$zipcode' where Username='$Username' ";
$sql[9] = "update member set phone='$phone' where Username='$Username' ";
for($i=0;$i<10;$i++) {
$result = mysql_query($sql[$i]) or die("Err program") ;
}
if($result) {
echo "<br><br><center><font size=\"3\" face='MS Sans Serif'><b>รายละเอียดของคุณ ได้ถูกบันทึกใหม่แล้วครับ</b></font></center>" ;
echo "<meta http-equiv='refresh' content='4; url=member_detail.php'>" ;
}
Date :
2014-03-07 03:41:15By :
nyebank
ทำไมไม่เขียนให้มันอยู่ในคิวรี่ชุดเดียวกันหว่า ?
Date :
2014-03-07 09:46:16By :
ทองมี
ไม่ขึ้นอาการอะไรเลยครับ ขึ้นข้อมูลอัพเดทเรียบร้อยแล้ว พอไปดูในฐานข้อมูล ไม่มีอะไรเลย
Date :
2014-03-07 15:51:59By :
nyebank
ลองดีบั๊คดูครับ echo query มาดูครับ
Date :
2014-03-07 17:20:30By :
Dragons_first
งง มากเลยครับ
Date :
2014-03-08 08:37:01By :
nyebank
echo '<br>', $sql[$i];
Date :
2014-03-08 08:41:57By :
{Cyberman}
Server 02
Load balance : Server 02
