我做了一个删除功能,点击删除都显示删除失败代码如下:bbs_small_type.php
<body>
<?php
include("conn/conn.php");
$sql=mysql_query("select count(*) as total from lt_small_type ",$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_small_type order by lt_date desc limit ".($page-1)*$pagesize.",$pagesize",$conn);
?><form id="form1" name="form1" method="post" action="bbs_add_small_type_ok.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="137" height="35">所属专区</td>
<td width="137" height="35">所属板块</td>
<td width="137" height="35">创建时间</td>
<td height="35" colspan="2">操作</td>
</tr>
<?php
include("conn/conn.php"); //包含conn.php文件
$select=mysql_query("select * from lt_small_type limit ".($page-1)*$pagesize.",$pagesize"); //查询数据
while($row=mysql_fetch_array($select)){ //循环输出查询内容
?>
<tr>
<td height="40"><?php echo $row['lt_big_type_content'];?></td>
<td height="40"><?php echo $row['lt_small_type_content'];?></td>
<td height="40"><?php echo $row['lt_small_type_date'];?></td>
<td width="81" height="40"><a href="bbs_delete_small_type.php?delete_id=<?php echo $row['lt_small_type_id'];?>">删除</a>
<input type="hidden" name="delete_id" value="<?php echo $row['lt_small_type_id'];?>"/> </td>
<td width="96"><a href="bbs_add_small_type.php?id=<?php echo $row['lt_small_type_id'];?>">添加</a>
<input type="hidden" name="id2" value="<?php echo $row['lt_small_type_id'];?>" /></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_small_type.php?id=<?php echo $id;?>&page=1" title="首页"><font face="webdings"> 9 </font></a> <a href="bbs_small_type.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_small_type.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php
}
}else{
for($i=1;$i<=4;$i++){
?>
<a href="bbs_small_type.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php }?>
<a href="bbs_small_type.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="后一页"><font face="webdings"> 8 </font></a> <a href="bbs_small_type.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>" title="尾页"><font face="webdings"> : </font></a>
<?php }?></td>
</tr>
</table> <p> </p></td>
</tr>
<tr>
<td height="32" background="images/right_bottom.gif"> </td>
</tr>
</table><?php
}
?>
</form>
</body>
第二个程序:bbs_small_type_ok.php
<?php
include("conn/conn.php");
if(isset($_GET['delete_id'])){
$id=$_GET['delete_id'];
$query="delete from lt_small_type where lt_small_type_id='$id'";
$result=mysql_query($query);
if($result==true){ echo "<script>alert('删除成功!');window.location.href='bbs_small_type.php';</script>";
}else{
echo "<script>alert('删除失败!');window.location.href='bbs_small_type.php';</script>";
}
}else{
echo "<script>alert('您不具备访问权限!');window.location.href='admin_user.php';</script>";
}
?>我觉着就是红色那几行的问题,补充:数据表是:lt_small_type 字段是:lt_small_type_id
<body>
<?php
include("conn/conn.php");
$sql=mysql_query("select count(*) as total from lt_small_type ",$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_small_type order by lt_date desc limit ".($page-1)*$pagesize.",$pagesize",$conn);
?><form id="form1" name="form1" method="post" action="bbs_add_small_type_ok.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="137" height="35">所属专区</td>
<td width="137" height="35">所属板块</td>
<td width="137" height="35">创建时间</td>
<td height="35" colspan="2">操作</td>
</tr>
<?php
include("conn/conn.php"); //包含conn.php文件
$select=mysql_query("select * from lt_small_type limit ".($page-1)*$pagesize.",$pagesize"); //查询数据
while($row=mysql_fetch_array($select)){ //循环输出查询内容
?>
<tr>
<td height="40"><?php echo $row['lt_big_type_content'];?></td>
<td height="40"><?php echo $row['lt_small_type_content'];?></td>
<td height="40"><?php echo $row['lt_small_type_date'];?></td>
<td width="81" height="40"><a href="bbs_delete_small_type.php?delete_id=<?php echo $row['lt_small_type_id'];?>">删除</a>
<input type="hidden" name="delete_id" value="<?php echo $row['lt_small_type_id'];?>"/> </td>
<td width="96"><a href="bbs_add_small_type.php?id=<?php echo $row['lt_small_type_id'];?>">添加</a>
<input type="hidden" name="id2" value="<?php echo $row['lt_small_type_id'];?>" /></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_small_type.php?id=<?php echo $id;?>&page=1" title="首页"><font face="webdings"> 9 </font></a> <a href="bbs_small_type.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_small_type.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php
}
}else{
for($i=1;$i<=4;$i++){
?>
<a href="bbs_small_type.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php }?>
<a href="bbs_small_type.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="后一页"><font face="webdings"> 8 </font></a> <a href="bbs_small_type.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>" title="尾页"><font face="webdings"> : </font></a>
<?php }?></td>
</tr>
</table> <p> </p></td>
</tr>
<tr>
<td height="32" background="images/right_bottom.gif"> </td>
</tr>
</table><?php
}
?>
</form>
</body>
第二个程序:bbs_small_type_ok.php
<?php
include("conn/conn.php");
if(isset($_GET['delete_id'])){
$id=$_GET['delete_id'];
$query="delete from lt_small_type where lt_small_type_id='$id'";
$result=mysql_query($query);
if($result==true){ echo "<script>alert('删除成功!');window.location.href='bbs_small_type.php';</script>";
}else{
echo "<script>alert('删除失败!');window.location.href='bbs_small_type.php';</script>";
}
}else{
echo "<script>alert('您不具备访问权限!');window.location.href='admin_user.php';</script>";
}
?>我觉着就是红色那几行的问题,补充:数据表是:lt_small_type 字段是:lt_small_type_id
你看看HTML源代码value的值是不是取到了。
2.
mysql_query($query);
if( mysql_affected_rows() > 0 ){ echo "<script>alert('删除成功!');window.location.href='bbs_small_type.php';</script>";
}else{
echo "<script>alert('删除失败!". mysql_error() ."');window.location.href='bbs_small_type.php';</script>";
}
删除失败的话肯定有错误或者 'delete_id' 没取到值,连带着打印出来不就知道该改哪了
你的是这样
<a href="bbs_delete_small_type.php?...>
后面你说的文件名是这样
第二个程序:bbs_small_type_ok.php
我的压缩包里面不止一两样东西哦,那可是我学习和工作的所有资料,不管是学习还是工作都会需要。
http://download.csdn.net/user/yangtonghai