php删除数据

最新推荐文章于 2021-03-19 01:49:45 发布

weixin_30340745

最新推荐文章于 2021-03-19 01:49:45 发布

阅读量126

点赞数

文章标签： php xhtml

原文链接：http://www.cnblogs.com/forqiwen/p/8324314.html

版权

租房子题目

1.先将页面做出来

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<script src="js/jquery-1.11.2.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</head>

<body>
<table class="table table-striped">
  <caption>发布新闻</caption>
  <thead>
    <tr>
      <th>关键字</th>
      <th>区域</th>
      <th>使用面积</th>
      <th>租金</th>
      <th>租赁类型</th>
      <th>房屋类型</th>
      <th>删除</th>
      <th>编辑</th>
    </tr>
  </thead>
  <tbody>
<?php
	require_once "./DBDA.class.php";
	$db = new DBDA();
	$sql = "select * from house";
	$arr = $db->query($sql);
	foreach($arr as $v){
		echo "
	<tr>
    	<td>{$v[1]}</td>
        <td>{$v[2]}</td>
        <td>{$v[3]}</td>
        <td>{$v[4]}</td>
        <td>{$v[5]}</td>
        <td>{$v[6]}</td>
		<td><a href='./shanchuhouse.php?ids={$v[0]}' οnclick=\"return confirm('确认删除吗?')\">删除</a></td>
		<td><a href='./xghouse.php?ids={$v[0]}'>编辑</a></td>
    </tr>
";
	}
?>
<div><a href="./tianjiahouse.php">添加数据</a></div>

当要点击删除按钮时

ids值在这种情况下用$_GET得到传过来

 1 <?php
 2 $ids = $_GET["ids"];
 3 $db = new MySQLi("localhost","root","123","phptext");
 4 $sql = "delete from house where ids = '{$ids}'";
 5 $result = $db->query($sql);
 6 if($result){
 7     header("location:housejs.php");
 8 }else{
 9     echo "删除失败";
10     }

显示在页面结果如下

转载于:https://www.cnblogs.com/forqiwen/p/8324314.html

weixin_30340745

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
php删除数据

租房子题目1.先将页面做出来<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">...
复制链接

扫一扫