根据你的问题,个人理解可以用PHP做一下$_POST值的判断,然后采用不同的SQL语句,例如:
header("Content-Type: text/html; charset=utf-8");
$zhanghao=$_POST["zhanghao"];
include("conn.php");
if(empty($zhanghao)){
$query = "select * from kadan";
}else{
$query = "select * from kadan where zhanghao = '$zhanghao' ";
}
*代替任意字符