php mysql delete数据记录删除
操作时点击删除连接时就会会获取到当前条目的id然后程序获取到当前id进行删除操作。
<?php教程 include("conn.php"); $query = "select * from new order by id desc"; $res = mysql教程_query($query); while($rows =mysql_fetch_array($res)){ //将查询到结果拆到$rows数组中 <table> <tr> <td>标题:<?php echo$rows['title']</td><td><a href="del.php?<?php $tid = $rows['id'] ">[删除]</a></td><td><a href="">[修改]</a></td> </tr> <table> <?php } <form action="addnews.php" method="post"> 作者:<input type="text" name="author"/><br/><br/> 标题:<input type="text" name="title" size="20"><br/><br/> 内容:<textarea name="content" cols="20" rows="20"></textarea> <input type="submit" value="提交" name="submit"/> </form>
del.php代码
<?php $del = "delect from test where id in ($tid)"; $res = mysql_query($del); if($res){ echo "删除成功"; }else{ echo "删除失败"; }
教程地址:http://www.phprm.com/database/36763.html
欢迎转载!但请带上文章地址^^