5月9 租房子练习题

搜索页面：

仍然是用到加载类：在上一级的test0506文件夹中

<?php
class DBDA

{
	public $host = "localhost";//数据库地址
	public $uid = "root";//数据库用户名
	public $pwd = "";//数据库密码
	
	//执行SQL语句，返回相应的方法
	//参数：$sql代表要执行的SQL语句，$type是SQL语句类型0代表查询1代表其他，$db代表要操作的数据库
	public function Query($sql,$type=0,$db="mydb")//经常操作的数据库名称
	{
		//造连接对象
		$dbconnect = new MySQLi($this->host,$this->uid,$this->pwd,$db);	
		//判断连接是否有误
		!mysqli_connect_error() or die("连接失败");
		//执行SQL语句
		$result = $dbconnect->query($sql);
		
		if($type==0)//查询时肯定是返回数组的
		{
			return $result->fetch_all();
		}
		else//增删改时只看看执行是否成功即可
		{
			return $result;	
		}
	}	
}

　　

主页面代码-------0510.php

<!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>
</head>

<body>
<form action="0510.php" method="post">
<div>区域：<input type="checkbox" onclick="CheckAll(this,'qy')" />全选</div>
<div>
<?php
include("../test0506/DBDA.class.php");
$db = new DBDA();

$sqlqy = "select distinct Area from House";
$attrqy = $db->Query($sqlqy);
//var_dump($attrqy);

foreach($attrqy as $v)
{
	echo "<input class='qy' type='checkbox' value='{$v[0]}' name='qy[]'/>{$v[0]} ";		
}
?>
</div><br />

<div>租赁类型：<input type="checkbox" onclick="CheckAll(this,'zl')"  />全选</div>
<div>
<?php

$sqlzl = "select distinct RentType from House";
$attrzl = $db->Query($sqlzl);

foreach($attrzl as $v)
{
	echo "<input class='zl' type='checkbox' value='{$v[0]}' name='zl[]'/>{$v[0]} ";		
}
?>
</div><br />

<div>房屋类型：<input type="checkbox" onclick="CheckAll(this,'fw')"  />全选</div>
<div>
<?php

$sqlfw = "select distinct HouseType from House";
$attrfw = $db->Query($sqlfw);
//var_dump($attrqy);

foreach($attrfw as $v)
{
	echo "<input class='fw' type='checkbox' value='{$v[0]}' name='fw[]'/>{$v[0]} ";		
}
?>
</div><br />

<div>关键字：<input type="text" name="keyword" id="key" />
</form>
<br />
<input type="submit" value="搜索" />

<br />
<br />
<br />

<table cellpadding="0" cellspacing="0" border="1" width="100%">
    <tr>
        <td>关键字</td>
        <td>区域</td>
        <td>面积</td>
        <td>租金</td>
        <td>租赁类型</td>
        <td>房屋类型</td>
    </tr>

<?php

$tj = "";
$tj1 = "1=1";
$tj2 = "1=1";
$tj3 = "1=1";
$tj4 = "1=1";

if(!empty($_POST["qy"]))
{
	$attr = $_POST["qy"];
	$str = implode("','",$attr);
	$tj1 = " Area in ('{$str}')";	
}

if(!empty($_POST["zl"]))
{
	$attr = $_POST["zl"];
	$str = implode("','",$attr);
	$tj2 = " RentType in ('{$str}')";	
}

if(!empty($_POST["fw"]))
{
	$attr = $_POST["fw"];
	$str = implode("','",$attr);
	$tj3 = " HouseType in ('{$str}')";	
}

if(!empty($_POST["keyword"]))
{
	$attr = $_POST["keyword"];
	$tj3 = " keyword like '%{$attr}%'";	
}

$tj = " Where {$tj1} and {$tj2} and {$tj3} and {$tj4}";

$sql = "select * from House".$tj;
$attrall = $db->Query($sql);
//var_dump($attrall);

foreach($attrall 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>
		</tr>";	
}

?>

</table>

</body>
<script type="text/javascript">
function CheckAll(a,b)//this表示该
{
	var qx = a.checked;
	var ck = document.getElementsByClassName(b);
	for(var i =0;i<ck.length;i++)
	{
		ck[i].checked = qx;	
	}
}

</script>

</html>

初始页面效果　　

增删改的练习：

主页面-----Main.php(都是在test0509中)

<!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>
</head>

<body>
<table width="100%" cellpadding="0" cellspacing="0" border="1">
<tr>
<td></td>
<td></td>
<td>关键字</td>
<td>区域</td>
<td>使用面积</td>
<td>租金</td>
<td>租赁类型</td>
<td>房屋类型</td>
</tr>

<?php
include("../test0506/DBDA.class.php");
$db = new DBDA();

$sql = "select * from House";
$attr = $db->Query($sql);

foreach($attr as $v)
{
	echo "<tr>
			
			<td><a href='update.php?id={$v[0]}'>编辑</a></td>
			
			<td><a href='delete.php?id={$v[0]}'>删除</a></td>
			
			<td>{$v[1]}</td>
			<td>{$v[2]}</td>
			<td>{$v[3]}</td>
			<td>{$v[4]}</td>
			<td>{$v[5]}</td>
			<td>{$v[6]}</td>	 
		 </tr>";
}
?>

</table><br />

<div>
<a href="Add.php"><input type="button" value="添加数据" /></a>
<a href="search.php"><input type="button" value="搜索查询" /></a>
</div>
</body>
</html>

　

  页面显示效果

　添加房屋信息的页面----Add.php

<!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>
</head>

<body>
<h1>添加信息</h1>
<form action="Addchuli.php" method="post">
<div>关键字：  <input type="text" name="keyword" style="350px; height:30px" /></div><br />

<div>区域:     <input type="text" name="area" style="350px; height:30px" /></div><br />
<div>使用面积: <input type="text" name="squaremeter" style="150px; height:30px" /></div><br />
<div>租金:     <input type="text" name="rent" style="350px; height:30px" /></div><br />
<div>租赁类型: <input type="text" name="renttype" style="350px; height:30px" /></div><br />
<div>房屋类型: <input type="text" name="housetype" style="350px; height:30px" /></div><br />
<br />
<input type="submit" value="插入信息" />  
<a href="Main.php"><input type="button" value="返回主页" /></a>


</form>

</body>
</html>

　　

　　页面显示效果

　　添加处理页面----Addchuli.php

<?php

$keyword = $_POST["keyword"];
$area = $_POST["area"];
$squaremeter = $_POST["squaremeter"];
$rent = $_POST["rent"];
$renttype = $_POST["renttype"];
$housetype = $_POST["housetype"];

include("../test0506/DBDA.class.php");
$db = new DBDA();

$sql = "insert into house values('','{$keyword}','{$area}','{$squaremeter}','{$rent}','{$renttype}','{$housetype}')";

$result = $db->Query($sql,1);
if($result)
{
	header("location:Main.php");	
}
else
{
	echo "添加失败";	
}

　　

　　删除页面-----delete.php

<?php

//没有用加载类
$id = $_GET["id"];

$db = new MySQLi("localhost","root","","mydb");
$sql = "delete from house where id = '{$id}'";
$result = $db->query($sql);
if($result)
{
	header("location:Main.php");	
}
else
{
	echo "删除失败";	
}

　　

　　修改信息----update.php

<!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>
</head>

<body>
<h1>修改页面</h1>
<?php
include("../test0506/DBDA.class.php");
$db = new DBDA();
$id = $_GET["id"];
$sql = "select * from house where id = '{$id}'";
$attr = $db->Query($sql);
//var_dump($attr);
?>

<form action="updatechuli.php" method="post">
<div>关键字：  
<input type="text" name="keyword" style="350px; height:30px" value="<?php echo $attr[0][1] ?>" /></div><br />

<div>区域:     
<input type="text" name="area" style="350px; height:30px" value="<?php echo $attr[0][2] ?>" /></div><br />

<div>使用面积: 
<input type="text" name="squaremeter" style="150px; height:30px" value="<?php echo $attr[0][3] ?>" /></div><br />

<div>租金:     
<input type="text" name="rent" style="350px; height:30px" value="<?php echo $attr[0][4] ?>" /></div><br />

<div>租赁类型: 
<input type="text" name="renttype" style="350px; height:30px" value="<?php echo $attr[0][5] ?>" /></div><br />

<div>房屋类型: 
<input type="text" name="housetype" style="350px; height:30px" value="<?php echo $attr[0][6] ?>" /></div><br />
<br />
<input type="submit" value="修改" />
<a href="Main.php"><input type="button" value="查看" /></a>


</form>

</body>
</html>

　　页面显示效果

　　修改处理----updatechuli.php

<?php

//使用加载类
	include("../test0506/DBDA.class.php");
	$db = new DBDA();
	
	$keyword = $_POST["keyword"];
	$area = $_POST["area"];
	$squaremeter = $_POST["squaremeter"];
	$rent = $_POST["rent"];
	$renttype = $_POST["renttype"];
	$housetype = $_POST["housetype"];
	
	$sql = "update house set keyword ='{$keyword}',area ='{$area}',squaremeter ='{$squaremeter}',rent ='{$rent}',
	renttype ='{$renttype}',housetype ='{$housetype}' where id = '{$id}' ";
	
	$attr = $db->Query($sql,1);
	if($attr)
	{
		header("location:Main.php");	
	}
	else
	{
		echo "修改失败";	
	}

　　以上是对于练习租房子的全部内容

以下是对于搜索页面全选，及多选的以及字符串拼接的整理

关于checkbox:多选时name是以数组的形式提交

<input type ="checkbox" name ="xx[]"/>这个只是一个类型，要实现全选功能使用JavaScript的方法

<form action="checkbox.php" method="post">
<div>全选：<input type="checkbox" id="qy" onclick="CheckAll()" /></div>
<?php
include("../test0506/DBDA.class.php");
$db = new DBDA();

$sql = "select distinct Area from House";
$attr = $db->Query($sql);

foreach($attr as $v)
{
	echo "<input class='qy' type='checkbox' value='{$v[0]}' name='qy[]'/>{$v[0]}";	
}
?>
</form>
</body>
<script type="text/javascript">
function CheckAll()
{
	var qx = document.getElementById("qy").checked;
	
	var ck = document.getElementsByClassName("qy");
	for(var i=0;i<ck.length;i++)
	{
		ck[i].checked = qx;	
	}	
}
</script>
</html>

　　function CheckAll()可以写参数的，像题中的this表示该，表示当前的，特别是像很多都可以用同一个方法实现时

紧接着上面的内容：$_POST["qy"]是以数组的形式输出的，写进SQL语句中要使用字符串才可以，因此有字符串的拼接implode,expolde是拆分字符串

<?php
//var_dump($_POST["qy"]);输出取得的所有名字，以数组的形式

$attr1 = $_POST["qy"];
$str = implode("','",$attr1);
$tj = " where Area in ('{$str}')";

$sql1 = "select * from House where Area in ('{$str}')";
$sql1 = "select * from House".$tj;
echo $sql1;
?>

　　

 

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/Duriyya/p/5477119.html