php租房数据查询及搜索处理方法-php开发知识文章-编程文章分享

这篇文章主要为大家详细介绍了php租房数据查询及搜索处理方法的相关资料，具有一定的参考价值，感兴趣的小伙伴们参考一下

数据库表

zufangzi.php文件

<html>
<body>
<h1>租房子</h1>
<form action="add.php" method="post">
    <div>区域：<input type="checkbox" name="qx" onclick="quanxuan(this,'qy')"/>全选</div>
    <div>
        <?php
        require "DBDA.class1.php";
        $db = new DBDA();
        $sqy = "select distinct area from house";//写SQL语句，并去重
        $aqy = $db->query($sqy);
        foreach ($aqy as $v) {
            echo "<input type='checkbox' name='qy[]' value='{$v[0]}' class='qy' />{$v[0]}";
        } ?>
    </div>
    <br/>
    <div>租赁类型：<input type="checkbox" name="zlqx" onclick="quanxuan(this,'zl')"/>全选</div>
    <div>
        <?php
        $szl = "select distinct renttype from house";
        $azl = $db->query($szl);
        foreach ($azl as $v) {
            echo "<input type='checkbox' name='zl[]' value='{$v[0]}' class='zl' />{$v[0]}";
        } ?>
    </div>
    <br/>
    <div>房屋类型：<input type="checkbox" name="fwqx" onclick="quanxuan(this,'fw')"/>全选</div>
    <div>
        <?php
        $sfw = "select distinct housetype from house";
        $afw = $db->query($sfw);
        foreach ($afw as $v) {
            echo "<input type='checkbox' name='fw[]' value='{$v[0]}' class='fw' />{$v[0]}";
        } ?>
    </div>
    <br/>
    <div>关键字：<input type="text" name="key"/> <input type="submit" value="查询"/></div>
</form>
<br/>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
    <tr>
        <td>关键字</td>
        <td>区域</td>
        <td>建筑面积</td>
        <td>租金</td>
        <td>租赁类型</td>
        <td>房屋类型</td>
    </tr>
    <?php $tj1 = " 1=1 ";
    $tj2 = " 1=1 ";
    $tj3 = " 1=1 ";
    $tj4 = " 1=1 ";
    if (!empty($_POST["qy"])) {
        $aqy = $_POST["qy"];
        $sqy = implode("','", $aqy);
        $tj1 = " area in ('{$sqy}') ";
    }
    if (!empty($_POST["zl"])) {
        $azl = $_POST["zl"];
        $szl = implode("','", $azl);
        $tj2 = " renttype in ('{$szl}') ";
    }
    if (!empty($_POST["fw"])) {
        $afw = $_POST["fw"];
        $sfw = implode("','", $afw);
        $tj3 = " housetype in ('{$sfw}') ";
    }
    if (!empty($_POST["key"])) {
        $k = $_POST["key"];
        $tj4 = " keyword like '%{$k}%' ";
    }
    $sql = "select * from house where {$tj1} and {$tj2} and {$tj3} and {$tj4}";
    echo $sql;
    $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>  </tr>";
    } ?></table>
</body>
<script>
    function quanxuan(qx, a) {  
        //找到该全选按钮对应的checkbox列表
        var ck = document.getElementsByClassName(a);  //找全选按钮选中状态  
        if (qx.checked) {
            for (var i = 0; i < ck.length; i++) {
                ck[i].setAttribute("checked", "checked");
            }
        } else {
            for (var i = 0; i < ck.length; i++) {
                ck[i].removeAttribute("checked");
            }
        }
    }</script>
</html>

数据库封装类 DBDA.class.php

class DBDA
{
    public $host = "localhost";
    public $uid = "root";
    public $pwd = "123456";
    public $dbname = "user";

    /**
     * 执行SQL语句返回相应的结果
     * @param $sql string 要执行的SQL语句
     * @param $type integer 代表SQL语句的类型，0代表增删改，1代表查询
     * @return boolean
     */
    function query($sql, $type = 1)
    {
        $db = new MySQLi($this->host, $this->uid, $this->pwd, $this->dbname);
        $result = $db->query($sql);
        if ($type) {      //如果是查询，显示数据
            return $result->fetch_all();
        } else {      //如果是增删改，返回true或者false
            return $result;
        }
    }
}

html页面

以上就是本文的php租房数据查询及搜索处理方法全部内容，希望对大家的学习有所帮助，也希望大家多多支持本站。

PHP基本语法

php租房数据查询及搜索处理方法

相关推荐

请登录