作者CAnthony15 (CAnthony)
看板PHP
標題[請益] 有關mysql_query : delete 問題
時間Tue Dec 1 18:50:08 2009
這是我的程式碼=================================================
檔名:test3.php
<!--
<form action = "take.php" method ="POST">
<input type = "text" name="a">
<br>
<input type = "submit" value = "send">
</form>
-->
<body>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8">
</head>
</body>
<?php
$s= mysql_connect("localhost","root","root") or die("FAILED!");
print "成功連線";
mysql_query("SET NAMES 'big5'");
mysql_select_db("itfca",$s); //使用資料庫
$a1_d = $_POST['a1'];
$a2_d = $_POST['a2'];
if($k = $_POST['add']){
mysql_query("insert into iftpm_dockind(KDNO,KDNAME)
VALUES('$a1_d','$a2_d')");
}else{
● mysql_query("DELETE FROM iftpm_dockind(KDNO,KDNAME) WHERE KDNO=$a1_d");
}
$re=mysql_query("SELECT * FROM iftpm_dockind");
print "<br>";
while($re2=mysql_fetch_array($re)){
print $re2[0];
print $re2[1]."<br>";
}
mysql_close($s);
?>
<a href="
http://localhost/take.php">上一頁</a>
===========================================================================
檔名:take.php
<!----------------------新增單筆資料----------------------->
<form method="POST" action="test3.php">
no.:<input type="text" name="a1"><br>
Name:<input type="text" name="a2" size=100 ><br>
<input type="submit" name="add" value="傳送">
</form>
<hr>
<!----------------------刪除單筆資料------------------------>
<form method="POST" action="test3.php">
no.:<input type="text" name="a1"><br>
Name:<input type="text" name="a2" size=20 ><br>
<input type="submit" name="del" value="刪除">
</form>
===========================================================================
但是可以新增單筆資料
卻無法刪除單筆資料
請問delete的部份 是不是有錯誤?!
感謝大大幫忙解惑!!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.30.14.18
→ scribeTW:DELETE FROM iftpm_dockind WHERE KDNO=$a1_d 就好了 12/01 19:02
→ CAnthony15:解決!!! 12/01 19:11
→ KC73:$a1_d = (int) $_POST['a1']; // 如果 a1 是數字 12/02 03:05