ããPHP+Mysqlå¤æ¡ä»¶å¤å¼æ¥è¯¢ç¤ºä¾ä»£ç ï¼
index.html代ç ï¼
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>SQLå¤æ¡ä»¶æ¥è¯¢ç¤ºä¾</title>
</head>
<body>
<form method="post" action="deal.php">
<h1>æ¿å±åºç§</h1>
æ¿å±ç±»åï¼<select name="type">
<option value="1">ä¸å±
室</option>
<option value="2">äºå±
室</option>
<option value="3">ä¸å±
室</option>
</select><br/>
é¢ç§¯ï¼<input name="area" type="text"/><br/>
å°åï¼<input name="addr" type="text"/><br/>
<input name="btn" type="submit" value="æç´¢" /><br/>
</form>
</body>
</html>
deal.phpæ件ï¼
<?php
//è¿æ¥æ°æ®åº
$conn=mysql_connect("localhost","root","");
//éæ©æ°æ®åº
$db=mysql_select_db("æ°æ®åºå");
//æ¥æ¶ åæ°
$type=$_POST['type'];
$area=$_POST['area'];
$addr=$_POST['addr'];
//SQLè¯å¥ä¸»é¢
$query="select * from room where ";
//æ ¹æ®æ¡ä»¶åä¼ çå¼æ¼æ¥sqlè¯å¥
//å¤æé¢ç§¯ä¸ä¸ºç©º
if($type!=""){
//ç¶åæ ¹æ®å
·ä½é¢ç§¯åæ
åµæ¼æ¥
switch($type){
case 1:
//ä¸å±
室
$query.=" room_type=1";
break;
case 2:
$query.=" room_type=2";
break;
case 3:
$query.=" room_type=3";
break;
}
}
//é¢ç§¯
if($area!=""){
$query.=" and area ={$area}";
}
//å°å
if($addr!=""){
$query.=" and addr like '%{$addr}%'"; //å°å
}
//æ§è¡æ¥è¯¢
$result=mysql_query($query);
//éåç»æ
echo "ææç»æå¦ä¸ï¼";
while($row=mysql_fetch_array($result)){
echo "å°åï¼".$row['addr'];
echo "<br/>";
echo "é¢ç§¯ï¼".$row['area'];
echo "<br/>";
echo "å±
室ï¼".$row['type'];
echo "<br/>";
echo "ä»·æ ¼ï¼".$row['addr'];
echo "<br/>";
//çç
}
?>