php 多條件查詢 例子

標籤：select   value   fetch   method   result   pac   eth   color   name   

<hl>表單的多條件查詢</h1>

<form action="這個表.php" method="post">

<div>
請輸入查詢的名字：<input type="text" name="name" />
請輸入查詢址性別：<input type="text" name="sex" />
<input type="submit" value="查詢" />
</div>

</form>

<br />

<table width="100%" border="1" cellpadding="0" cellspacing="0">

<tr>
<td>ID</td>
<td>名字</td>
<td>性別</td>
<td>生日</td>
<td>地址</td>
</tr>

<?php

$db = new MySQLi("localhost","root","root","資料庫名");

$tj1 = " 1 = 1 ";
$tj2 = " 1 = 1 ";
if(!empty($_POST["name"]))
{
$name = $_POST[‘name‘];
$tj1 = " name like ‘%{$name}%‘ ";
}

if(!empty($_POST["sex"]))
{
$sex = $_POST["sex"];
$tj2 = " sex = ‘{$sex}‘";
}

$sql = "select * from 表名 where {$tj1} and {$tj2}";
echo $sql;

$result = $db -> query($sql);

while($arr = $result -> fetch_row())
{

echo "<tr>
<td>{$arr[0]}</td>
<td>{$arr[1]}</td>
<td>{$arr[2]}</td>
<td>{$arr[3]}</td>
<td>{$arr[5]}</td>
</tr>";
}

?>

</table>

php 多條件查詢 例子