Question

php必须满足两个条件（id和title）才输出结果

<form action="search.php" method="POST">
部门名称：<input type="text" size=25 name="id" value=""> <br><br>
员工姓名: <input type="text" size=25 name="title" value=""> <br><br>
<input type="submit" name="提交" value="提交">
</form>

<?php

//注释1-----------------------------
$id=$_POST["id"];
$title=$_POST["title"];

//注释2------------------------
if(
$id != null){
$a = " and id like '%$id%'";}

if($title != null){
$b = " and title like '%$title%'";}

//注释3------------------------
$q = "SELECT * FROM dede_archives where (1=1)";
$q .=$a;
$q .=$b;

//注释4------------------------------------------
mysql_query("SET NAMES GB2312");
$rs = mysql_query($q, $link);
echo "<table>";
echo "<tr><td>部门</td><td>员工姓名</td></tr>";
while($row = mysql_fetch_object($rs))
echo "<tr><td>$row->id</td><td>$row->title</td></tr>";
echo "</table>";

mysql_close($link);

?>
目前是任意一样满足就输出了结果

Answer 1

//注释2------------------------
if($id){
$a = " and id like '%$id%'";}

if($title){
$b = " and title like '%$title%'";}

追问

如果只输入一样 同样可以查询结果的 希望是必须满足两样才输出结果

追答

if(! $id || ! $title){
echo "需要完善搜索条件！";
return；

}