轻量应用服务器做网站/seo排名软件价格
租房页面如图：
代码如下：
租房子//引入bootstrap前端框架的三个文件
.yangshi{
margin-left: 69px;
}
.ys{
margin-left: 69px;
}
.juli{
margin-left: 28px;
}
//form表单中使用get方式进行提交租房子
//连接数据库并利用去重查询取出列名为区域的这一组数据
require_once "./DBDA.class.php";
require_once "./page.class.php";
$db = new DBDA();
$sqy = "select distinct area from housedb"; //去重查询
$aqy =$db->query($sqy,0);
foreach($aqy as $v){
echo " {$v[0]}";
}
?>
效果如图：
//连接数据库并利用去重查询取出列名为租房类型的这一组数据
$srt = "select distinct renttype from housedb";
$art = $db->query($srt,0);
foreach($art as $v){
echo " {$v[0]}";
}
?>
效果如图：
//连接数据库并利用去重查询取出列名为户型的这一组数据
$sht = "select distinct housetype from housedb";
$aht = $db->query($sht,0);
foreach($aht as $v){
echo " {$v[0]}";
}
?>
效果如图：
//关键字查询
搜索
效果如图：
//使用表格在页面输出全部数据信息
关键字区域房子面积租价租房类型户型
$tj1 = " 1=1 "; //分别对不同查询的条件做一个恒成立的条件
$tj2 = " 1=1 ";
$tj3 = " 1=1 ";
$tj4 = " 1=1 ";
if(!empty($_GET["qy"])){ //区域的条件判断
$qy = $_GET["qy"];
$str = implode("','", $qy);
$tj1 = "area in ('{$str}')";
}
if(!empty($_GET["zflx"])){ //租房类型的条件判断
$zflx = $_GET["zflx"];
$str = implode("','", $zflx);
$tj2 = "renttype in ('{$str}')";
}
if(!empty($_GET["hx"])){ //户型的条件判断
$hx = $_GET["hx"];
$str = implode("','", $hx);
$tj3 = "housetype in ('{$str}')";
}
if(!empty($_GET["keyword"])){ //关键字查询的条件判断
$keyword = $_GET["keyword"];
$tj4 = "keyword like '%{$keyword}%'";
}
$zts = "select count(*) from housedb where {$tj1} and {$tj2} and {$tj3} and {$tj4}";
$ats = $db->query($zts,0);
$page = new page($ats[0][0],3); //分页查询取总数，设置每页显示的行数据
效果如图：
$sql = "select * from housedb where {$tj1} and {$tj2} and {$tj3} and {$tj4}".$page->limit; //利用拼接字符串方式将调取分页方法与条件进行拼接
$arr = $db->query($sql,0);
foreach($arr as $v){
echo "
{$v[1]}{$v[2]}{$v[3]}{$v[4]}{$v[5]}{$v[6]}";}
?>
效果如图：
echo $page->fpage();
?>
//使用JS实现全选功能
function qx(qx){
var ck1 = document.getElementsByClassName("ck1");
for(var i=0;i
ck1[i].checked=qx.checked;
}
}
function zflx(zflx){
var ck2 = document.getElementsByClassName("ck2");
for(var i=0;i
ck2[i].checked=zflx.checked;
}
}
function hx(hx){
var ck3 = document.getElementsByClassName("ck3");
for(var i=0;i
ck3[i].checked=hx.checked;
}
}