[請益] 刪掉資料庫內的資料 找不到錯誤...@"@
以下是我兩個php檔
1.php
<FORM action=2.php method=POST">
<table cellspacing=1 cellpadding=5 width=50% bgcolor=#E7E3E7>
<?
$link_ID = mysql_connect("localhost","root","");
//連接MySQL伺服器
mysql_select_db("talk");
//使用contact資料庫
mysql_query("set character set big5");
$str1="select * from bbs_form";
$result1=mysql_query($str1,$link_ID);
$l = mysql_num_rows($result1);
mysql_query("set character set big5");
echo "<tr height=23 align=center>";
echo "<td bgcolor=#3366CC>鎖版</td>";
echo "<td bgcolor=#3366CC>論壇</td>";
echo "<td bgcolor=#3366CC>版主</td></tr>";
for ($a=0; $a < $l ; $a++){
$row0 = mysql_result($result1,$a,"id");
$row1 = mysql_result($result1,$a,"title");
$row2 = mysql_result($result1,$a,"username");
echo "<tr height=23 align=center class='cbg'>";
echo "<td><input type=checkbox name=lock$a value=$a></td>";
echo "<td>$row1</td>";
echo "<td>$row2</td></tr>";
};?>
</table>
<INPUT Type="submit" value="刪除">
</form>
2.php
<?php
$link_ID = mysql_connect("localhost","root","");
//連接MySQL伺服器
mysql_select_db("talk");
//使用contact資料庫
mysql_query("set character set big5");
$str1="select * from bbs_form";
$result1=mysql_query($str1,$link_ID);
$l = mysql_num_rows($result1);
mysql_query("set character set big5");
for($a=0;$a<$l;$a++)
{
if(isset($_REQUEST["lock"]))
{
$row0 = mysql_result($result1,$a,"id");
$row1 = mysql_result($result1,$a,"title");
$row2 = mysql_result($result1,$a,"username");
$query1="DELETE FROM `bbs_form` WHERE `title`='$row1'";
mysql_query($query1);
}}
header ("Location:1.php");
?>
想請問 我錯在哪裡壓??
選一篇文章案刪除 卻都沒有動靜...已經困擾我兩天了@@"
可以幫忙一下嗎? 謝謝~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.130.189.39
※ 編輯: iversonjimmy 來自: 140.130.189.39 (11/01 17:38)
※ 編輯: iversonjimmy 來自: 140.130.189.39 (11/01 17:38)
推
11/01 17:42, , 1F
11/01 17:42, 1F
※ 編輯: iversonjimmy 來自: 140.130.189.39 (11/01 17:53)
推
11/01 17:53, , 2F
11/01 17:53, 2F
→
11/01 17:53, , 3F
11/01 17:53, 3F
推
11/01 18:01, , 4F
11/01 18:01, 4F
→
11/02 09:40, , 5F
11/02 09:40, 5F
推
11/03 00:29, , 6F
11/03 00:29, 6F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
151
156