PHP制作查询租房表
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2 <html xmlns="http://www.w3.org/1999/xhtml">
3 <head>
4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
5 <title>无标题文档</title>
6 </head>
7
8 <body>
9
10 <!--<textarea style=" overflow: scroll;"></textarea>文本域-->
11 <!--当我点击查询的时候会把数据传到当前页面，提交到当前页面-->
12 <?php
13 $db = new MySQLi("localhost","root","511108","text");
14 //在这个页面就能把提交的数据放到这是用了
15 //做查询的时候传递过来几条数据就就做几个条件
16 $tj1 = " 1=1 ";
17 $tj2 = " 1=1 ";
18 $tj3 = " 1=1 ";
19 $tj4 = " 1=1 ";
20
21 //区域的条件
22 //var_dump($_POST["qx"]);//测试输出用
23 if(!empty($_POST["qx"]) && count($_POST["qx"])>0)//判断countyaodayu零如果等于零还是查所有
24 {
25 //$tj1 = "";
26 $qx = $_POST["qx"];//这是一个数组把数组要转化字符串
27 //select * from info where code in('类型','数量','','','')//数组里面每个元素就是一个值。如何拼成字符串：用拆分字符串implode方法（','拼接）
28 $str = implode("','",$qx);
29 //echo $str;//输出
30 $tj1 = " area in('{$str}') ";//完整的条件
31 //echo $tj1;//输出看看tj1 是不是完整条件
32 }
33 //租赁类型的条件
34 if(!empty($_POST["zl"]) && count($_POST["zl"])>0)
35 {
36 $zl = $_POST["zl"];
37 $str = implode("','",$zl);
38 $tj2 = " renttype in('{$str}') ";
39 }
40 //房屋类型的条件
41 if(!empty($_POST["fw"]) && count($_POST["fw"])>0)
42 {
43 $fw = $_POST["fw"];
44 $str = implode("','",$fw);
45 $tj3 = " housetype in('{$str}') ";
46 //echo $tj3; //测试输出
47 }
48 //关键字的条件
49 if(!empty($_POST["key"]))
50 {
51 $key = $_POST["key"];//把$_POST["key"]交给$key变量
52 $tj4 = " keyword like '%{$key}%' ";//不为空就变成关键字模糊查询,把$key变量拿过来
53 }
54
55
56 ?>
57
58
59 <h1>租房</h1>
60 <form action="fangwu12.php" method="post">
61 <div>
62 区域：
63 <input type="checkbox" name="qx" />全选
64 </div>
65 <div>
66 <?php
67 $sqlq = "select distinct area from house";//去重distinct
68 $rq = $db->query($sqlq);
69 $aq = $rq->fetch_all();
70 foreach($aq as $v)//循环输出
71 {
72 echo "<input type='checkbox' name='qx[]' value='{$v[0]}' />{$v[0]}";// name='qx[]'以数组形式提交
73 }
74 ?>
75 </div>
76 <br/>
77
78 <div>
79 租赁类型：
80 <input type="checkbox" name="qx" />全选</div>
81 <div>
82 <?php
83 $sqlz = "select distinct renttype from house";//去重distinct
84 $rz = $db->query($sqlz);
85 $az = $rz->fetch_all();
86 foreach($az as $v)//循环输出
87 {
88 echo "<input type='checkbox' name='zl[]' value='{$v[0]}' />{$v[0]}";
89 }
90 ?>
91 </div>
92 <br/>
93
94 <div>
95 房屋类型：
96 <input type="checkbox" name="qx" />全选</div>
97 <div>
98 <?php
99 $sqlf = "select distinct housetype from house";//去重distinct
100 $rf = $db->query($sqlf);
101 $af = $rf->fetch_all();
102 foreach($af as $v)//循环输出
103 {
104 echo "<input type='checkbox' name='fw[]' value='{$v[0]}' />{$v[0]} ";
105 }
106 ?>
107 </div>
108 <br/>
109 <div>
110 关键字：
111 <input type="text" name="key" />
112 <input type="submit" value="查询" />
113 </div>
114 <table width="100%" border="1" cellpadding="0" cellspacing="0">
115 <tr>
116 <td>关键字</td>
117 <td>区域</td>
118 <td>建筑面积</td>
119 <td>租金</td>
120 <td>租赁类型</td>
121 <td>房屋类型</td>
122 </tr>
123 <?php
124 $sqlall = "select * from house where {$tj1} and {$tj2} and {$tj3} and {$tj4}";
125 //echo $sqlall;//什么也不选就是默认所有
$rall = $db->query($sqlall);
126 $aall = $rall->fetch_all();
127 foreach($aall as $v)
128 {
129 echo "<tr>
130 <td>{$v[1]}</td>
131 <td>{$v[2]}</td>
132 <td>{$v[3]}</td>
133 <td>{$v[4]}</td>
134 <td>{$v[5]}</td>
135 <td>{$v[6]}</td>
136 </tr>";
137 }
138
139 ?>
140
141
142 </table>
143
144 </body>
145 </html>
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2 <html xmlns="http://www.w3.org/1999/xhtml">
3 <head>
4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
5 <title>无标题文档</title>
6 </head>
7
8 <body>
9
10 <!--<textarea style=" overflow: scroll;"></textarea>文本域-->
11 <!--当我点击查询的时候会把数据传到当前页面，提交到当前页面-->
12 <?php
13 $db = new MySQLi("localhost","root","511108","text");
14 //在这个页面就能把提交的数据放到这是用了
15 //做查询的时候传递过来几条数据就就做几个条件
16 $tj1 = " 1=1 ";
17 $tj2 = " 1=1 ";
18 $tj3 = " 1=1 ";
19 $tj4 = " 1=1 ";
20
21 //区域的条件
22 //var_dump($_POST["qx"]);//测试输出用
23 if(!empty($_POST["qx"]) && count($_POST["qx"])>0)//判断countyaodayu零如果等于零还是查所有
24 {
25 //$tj1 = "";
26 $qx = $_POST["qx"];//这是一个数组把数组要转化字符串
27 //select * from info where code in('类型','数量','','','')//数组里面每个元素就是一个值。如何拼成字符串：用拆分字符串implode方法（','拼接）
28 $str = implode("','",$qx);
29 //echo $str;//输出
30 $tj1 = " area in('{$str}') ";//完整的条件
31 //echo $tj1;//输出看看tj1 是不是完整条件
32 }
33 //租赁类型的条件
34 if(!empty($_POST["zl"]) && count($_POST["zl"])>0)
35 {
36 $zl = $_POST["zl"];
37 $str = implode("','",$zl);
38 $tj2 = " renttype in('{$str}') ";
39 }
40 //房屋类型的条件
41 if(!empty($_POST["fw"]) && count($_POST["fw"])>0)
42 {
43 $fw = $_POST["fw"];
44 $str = implode("','",$fw);
45 $tj3 = " housetype in('{$str}') ";
46 //echo $tj3; //测试输出
47 }
48 //关键字的条件
49 if(!empty($_POST["key"]))
50 {
51 $key = $_POST["key"];//把$_POST["key"]交给$key变量
52 $tj4 = " keyword like '%{$key}%' ";//不为空就变成关键字模糊查询,把$key变量拿过来
53 }
54
55
56 ?>
57
58
59 <h1>租房</h1>
60 <form action="fangwu12.php" method="post">
61 <div>
62 区域：
63 <input type="checkbox" onclick="checkall(this)" />全选
64 </div>
65 <div>
66 <?php
67 $sqlq = "select distinct area from house";//去重distinct
68 $rq = $db->query($sqlq);
69 $aq = $rq->fetch_all();
70 foreach($aq as $v)//循环输出
71 {
72 echo "<input type='checkbox' name='qx[]' value='{$v[0]}' class='qxlist' />{$v[0]}";// name='qx[]'以数组形式提交
73 }
74 ?>
75 </div>
76 <br/>
77
78 <div>
79 租赁类型：
80 <input type="checkbox" name="qx" />全选</div>
81 <div>
82 <?php
83 $sqlz = "select distinct renttype from house";//去重distinct
84 $rz = $db->query($sqlz);
85 $az = $rz->fetch_all();
86 foreach($az as $v)//循环输出
87 {
88 echo "<input type='checkbox' name='zl[]' value='{$v[0]}' />{$v[0]}";
89 }
90 ?>
91 </div>
92 <br/>
93
94 <div>
95 房屋类型：
96 <input type="checkbox" name="qx" />全选</div>
97 <div>
98 <?php
99 $sqlf = "select distinct housetype from house";//去重distinct
100 $rf = $db->query($sqlf);
101 $af = $rf->fetch_all();
102 foreach($af as $v)//循环输出
103 {
104 echo "<input type='checkbox' name='fw[]' value='{$v[0]}' />{$v[0]} ";
105 }
106 ?>
107 </div>
108 <br/>
109 <div>
110 关键字：
111 <input type="text" name="key" />
112 <input type="submit" value="查询" />
113 </div>
114 <table width="100%" border="1" cellpadding="0" cellspacing="0">
115 <tr>
116 <td>关键字</td>
117 <td>区域</td>
118 <td>建筑面积</td>
119 <td>租金</td>
120 <td>租赁类型</td>
121 <td>房屋类型</td>
122 </tr>
123 <?php
124 $sqlall = "select * from house where {$tj1} and {$tj2} and {$tj3} and {$tj4}";
125 //echo $sqlall;//什么也不选就是默认所有
126 $rall = $db->query($sqlall);
127 $aall = $rall->fetch_all();
128 foreach($aall as $v)
129 {
130 echo "<tr>
131 <td>{$v[1]}</td>
132 <td>{$v[2]}</td>
133 <td>{$v[3]}</td>
134 <td>{$v[4]}</td>
135 <td>{$v[5]}</td>
136 <td>{$v[6]}</td>
137 </tr>";
138 }
139
140 ?>
141
142
143 </table>
144 <!--下是控制区域全选，上面有个区域-->
145 <script type="text/javascript">
146
147 function checkall(a)
148 {
149 var ck = document.getElementsByClassName("qxlist");
150 <!--document.getElementById().setAttribute()用来设置属性的-->
151 if(a.checked)
152 {
153 for(var i=0;i<ck.length;i++)<!--通过这个循环-->
154 {
155 ck[i].setAttribute("checked","checked");<!--由他控制全选-->
156 }
157 }
158 else
159 {
160 for(var i=0;i<ck.length;i++)
161 {
162 ck[i].removeAttribute("checked");
163 }
164 }
165 }
166
167 </script>
168
169
170
171 </body>
172 </html>
图一，图二是运行区域全选的功能
图一
图2
浙公网安备 33010602011771号