รบกวนดูให้หน่อยค่ะ มันไม่อัพเดทลงฐานข้อมูล ช่วยดูให้หน่อยนะคะ รีบจริง ๆ
เช็คสถานะโดยแสดงเป็นปุ่ม เมื่อคลิกก็เข้าไปยังหน้า save_edit.phpCode (PHP) <table border=1 align="center" / >
<tr bgcolor='#3399FF'><th height="30" valign="top" bgcolor="#99CCFF">ID</th>
<th width="160" bgcolor="#99CCFF">Name</th>
<th width="133" bgcolor="#99CCFF">Company </th>
<th width="150" bgcolor="#99CCFF">Position </th>
<th width="111" bgcolor="#99CCFF">Mobile Phone</th>
<th width="233" bgcolor="#99CCFF">E-mail </th>
<th width="auto" bgcolor="#99CCFF">Check </th>
</tr>
<p>
<?
include "connect.php";
$sql="select * from member where name like '%".$_GET["txtKeyword1"]."%' || surname like '%".$_GET["txtKeyword1"]."%' || company like '%".$_GET[txtKeyword1]."%' || position like '%".$_GET[txtKeyword1]."%' order by id asc ";
//$sql = "SELECT * FROM pipe_detail where id order by acc_company asc ";
$result=mysql_db_query($dbname,$sql);
$x=1;
$add=$_GET[add];
while($row=mysql_fetch_array($result))
{
echo"<td>",$x,"</td>";
$id = $row['id'];
echo"<td>",$row["name" ]." ". $row["surname"],"<center/></a></td>";
echo"<td>",$row["company"],"</td>";
echo"<td>",$row["position"],"</td>";
echo"<td>",$row["mobile"],"</td>";
echo"<td>",$row["email"],"</td>";
//echo $row["add"];
if ($row["add"] == "y"){
echo"<td><a href=\"save_edit.php? id=$id &f=1 \">
<center/><input name = 'add' type='button' value='y'></a></td>";}
else if ($row["add"] == "n" || " ") {
echo"<td><a href=\"save_edit.php? id=$id &f=2 \">
<center/><input name = 'add' type='button' value='n'></a></td>";}
echo"</tr>";
$x++;
}
?>
</p>
</table>
Code (PHP) <?php
$f=$_GET['f'];
$id=$_GET[id];
$add=$_GET[add];
include "connect.php";
if ($f == '1'){
$sql="UPDATE member SET add = 'n' where id=$id ";
$result = mysql_db_query("sales",$sql);
echo "Activate Successfully !";
echo '<meta http-equiv="refresh" content="5;url=member.php">'; }
else if($f =='2') {
$sql="UPDATE member SET add = 'y' where id=$id ";
$result = mysql_db_query("sales",$sql);
echo "Activate Successfully !";
echo '<meta http-equiv="refresh" content="5;url=member.php">'; }
echo $sql;
mysql_close();
?>
Tag PHP
Date :
2012-06-25 10:32:51By :
IIAMPEREView :
883Reply :
8
echo $result ดูครับ ว่ามันมีค่าอะไรออกมาหรือเปล่า
Date :
2012-06-25 10:56:19By :
juder
มันไม่ขึ้นอะไรเลย ตรงส่วน result ค่ะ
Date :
2012-06-25 10:58:29By :
IIAMPERE
Code (PHP) $result = mysql_db_query("sales",$sql) or die(mysql_error());
Date :
2012-06-25 16:57:09By :
mr.win
มันเตือนว่า query ว่างค่ะ
Date :
2012-06-27 12:07:50By :
IIAMPERE
ใส่แบบนี้ครับCode (PHP) <?php
$f=$_GET['f'];
$id=$_GET[id];
$add=$_GET[add];
include "connect.php";
if ($f == '1'){
$sql="UPDATE member SET add = 'n' where id='$id' ";
$result = mysql_db_query("sales",$sql);
echo "Activate Successfully !";
echo '<meta http-equiv="refresh" content="5;url=member.php">'; }
else if($f =='2') {
$sql="UPDATE member SET add = 'y' where id='$id' ";
$result = mysql_db_query("sales",$sql);
echo "Activate Successfully !";
echo '<meta http-equiv="refresh" content="5;url=member.php">'; }
echo $sql;
mysql_close();
?>
Date :
2012-06-27 12:15:08By :
000su000
ก็ยังเป็นเหมือนเดิมค่ะ
Date :
2012-06-27 13:42:05By :
IIAMPERE
ลองดูนะ ถ้ายังไงเอา error มาดู Code (PHP) <?php
$f=$_GET['f'];
$id=$_GET[id];
$add=$_GET[add];
include "connect.php";
if ($f == '1'){
$sql="UPDATE member SET add = 'n' where id='$id' ";
$result = mysql_query($sql)or die (mysql_error());
echo "Activate Successfully !";
echo '<meta http-equiv="refresh" content="5;url=member.php">'; }
else if($f =='2') {
$sql1="UPDATE member SET add = 'y' where id='$id' ";
$result = mysql_query($sql1)or die (mysql_error());
echo "Activate Successfully !";
echo '<meta http-equiv="refresh" content="5;url=member.php">'; }
echo $sql;
mysql_close();
?>
ประวัติการแก้ไข
Date :
2012-06-27 13:57:49By :
000su000
Server 01
Load balance : Server 01
