作者iversonjimmy (还没想到捏)
看板PHP
标题[请益] 删掉资料库内的资料 找不到错误...@"@
时间Thu Nov 1 17:31:25 2007
以下是我两个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)
1F：推 buganini:2.php $result1$a 11/01 17:42
※ 编辑: iversonjimmy 来自: 140.130.189.39 (11/01 17:53)
2F：推 iversonjimmy:不好意思 刚刚修改忘记补上逗号了...@"@ 11/01 17:53
3F：→ iversonjimmy:还是不行.... 11/01 17:53
4F：推 iversonjimmy:耶~~我找到错误了~~真开心~ 谢谢你们!! 11/01 18:01
5F：→ fatcats:是因为数字开头吗...@@" 11/02 09:40
6F：推 iversonjimmy:是在2.php里 if叙述的lock这里 忘记加$a了....@"@ 11/03 00:29