下面是为了实现删除会员以及会员的连带关系的代码,
每次点击删除时,都有显示删除成功,但实际没有删除。
<?PHP include("conn/conn.php");
$delete_id=$_GET['delete_id'];
$query=mysql_query("delete from lt_user where id='$delete_id'");
if($query==true){
$query_1=mysql_query("delete from lt_reply where lt_reply_user='$delete_user'");
$query_2=mysql_query("delete from lt_send where lt_send_user='$delete_user'");
echo "<script>alert('删除成功!');history.back();</script>";
}else{
echo "<script>alert('删除失败!');history.back();</script>";
}
?>
每次点击删除时,都有显示删除成功,但实际没有删除。
<?PHP include("conn/conn.php");
$delete_id=$_GET['delete_id'];
$query=mysql_query("delete from lt_user where id='$delete_id'");
if($query==true){
$query_1=mysql_query("delete from lt_reply where lt_reply_user='$delete_user'");
$query_2=mysql_query("delete from lt_send where lt_send_user='$delete_user'");
echo "<script>alert('删除成功!');history.back();</script>";
}else{
echo "<script>alert('删除失败!');history.back();</script>";
}
?>
delete from lt_user where id='$delete_id'
这句话打印出来。
看是否取到值了
echo $delete_user;//有东西输出吗
<body>
<?php
include("conn/conn.php");
$sql=mysql_query("select count(*) as total from lt_user ",$conn);
$info=mysql_fetch_array($sql);
$total=$info[total];
if($total==0)
{
echo "本站暂无记录!";
}
else
{
$pagesize=8;
if ($total<=$pagesize){
$pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==""){
$page=1;
}else{
$page=intval($_GET[page]);
}
$sql1=mysql_query("select * from lt_user order by lt_date desc limit ".($page-1)*$pagesize.",$pagesize",$conn);
?><form id="form1" name="form1" method="post" action="bbs_update_hygl.php">
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="32" background="images/right_line.gif"> 您现在的位置:校园馨浪网站后台管理系统</td>
</tr>
<tr>
<td height="32" background="images/right_top.gif"> </td>
</tr>
<tr>
<td height="488" align="center" valign="top" background="images/right_middle.gif"><table width="600" border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="92" height="35">会员昵称</td>
<td width="123" height="35">会员密码</td>
<td width="82" height="35">注册时间</td>
<td width="64" height="35">所属类型</td>
<td width="81" height="35">操作</td>
<td width="144" height="35"> </td>
</tr>
<?php
include("conn/conn.php"); //包含conn.php文件
$select=mysql_query("select * from lt_user limit ".($page-1)*$pagesize.",$pagesize"); //查询数据
while($myrow=mysql_fetch_array($select)){ //循环输出查询内容
?>
<tr>
<td height="40"> <?php echo $myrow[lt_user];?></td>
<td height="40"><?php echo $myrow[true_pwd];?></td>
<td height="40"><?php echo $myrow[lt_date];?></td>
<td height="40"><?php echo $myrow[lt_type];?></td>
<td height="40"><a href="bbs_delete.php?delete_id=<?php echo $myrow[id];?>&&delete_user=<?php echo $myrow[lt_user];?>" class="STYLE1">删除会员</a></td>
<td height="40"><select name="lt_type" id="lt_type">
<option value="0">版主</option>
<option value="1">会员</option>
</select>
<input type="submit" name="Submit" value="权限设置" /></td>
</tr>
<?php
} //结束循环
?>
</table>
<table width="600">
<tr>
<td>本站共有公告
<?php
echo $total;
?>
条 每页显示 <?php echo $pagesize;?> 条 第 <?php echo $page;?> 页/共 <?php echo $pagecount; ?> 页
<?php
if($page>=2)
{
?>
<a href="bbs_hygl.php?id=<?php echo $id;?>&page=1" title="首页"><font face="webdings"> 9 </font></a> <a href="bbs_hygl.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="前一页"><font face="webdings"> 7 </font></a>
<?php
}
if($pagecount<=4){
for($i=1;$i<=$pagecount;$i++){
?>
<a href="bbs_hygl.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php
}
}else{
for($i=1;$i<=4;$i++){
?>
<a href="bbs_hygl.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php }?>
<a href="lt_user.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="后一页"><font face="webdings"> 8 </font></a> <a href="bbs_hyglr.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>" title="尾页"><font face="webdings"> : </font></a>
<?php }?></td>
</tr>
</table></td>
</tr>
<tr>
<td height="32" background="images/right_bottom.gif"> </td>
</tr>
</table>
<?php
}
?></form>
</body>
删除的网页是bbs_delete.php代码就是最前面发的,也就是:<?PHP include("conn/conn.php");
$delete_id=$_POST['id'];
$query=mysql_query("delete from lt_user where id='$delete_id'");
if($query==true){
$query_1=mysql_query("delete from lt_reply where lt_reply_user='$delete_user'");
$query_2=mysql_query("delete from lt_send where lt_send_user='$delete_user'");
echo "<script>alert('删除会员成功!');history.back();</script>";
}else{
echo "<script>alert('删除会员失败!');history.back();</script>";
}
?>
这是GET提交方式么 , $delete_id=$_POST['id']; 改成 $delete_id=$_GET['id'];
<a href="bbs_delete.php?delete_id=<?php echo $myrow[id];?>&&delete_user=<?php echo $myrow[lt_user];?>" class="STYLE1">删除会员</a>
这种转义后的& 符号恐怕不行吧! <a href="bbs_delete.php?delete_id=<?php echo $myrow[id]; ?>&delete_user=<?php echo $myrow[lt_user]; ?>" class="STYLE1">删除会员</a>而且按表单的参数名
$delete_id = $_GET['delect_id'];
$delete_user = $_GET['delect_user'];
$query_2=mysql_query("delete from lt_send where lt_send_user=".$delete_user,$conn);
试试这样,OK不