Multi-conditional query for
<form action= " this table. PHP" method= "POST" >
<div>
Please enter the name of the query: <input type= "text" name= "name"/>
Please enter a query address gender: <input type= "text" name= "Sex"/>
<input type= "Submit" value= "Query"/>
</div>
</form>
<br/>
<table width= "100%" border= "1" cellpadding= "0" cellspacing= "0" >
<tr>
<td>ID</td>
<td> name </td>
<td> Sex </td>
<td> Birthdays </td>
<td> Address </td>
</tr>
<?php
$db = new Mysqli ("localhost", "root", "root", " database name ");
$TJ 1 = "1 = 1";
$TJ 2 = "1 = 1";
if (!empty ($_post["name"]))
{
$name = $_post[' name '];
$TJ 1 = "name like '%{$name}% '";
}
if (!empty ($_post["Sex"]))
{
$sex = $_post["Sex"];
$TJ 2 = "sex = ' {$sex} '";
}
$sql = "SELECT * from table name where {$TJ 1} and {$TJ 2}";
Echo $sql;
$result = Query ($sql), $db
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 Multi-Conditional Query Example