php的mysql模糊查询,可以允许空值(空值则查询全部),具体代码如下:
$sql = "SELECT * FROM user WHERE name LIKE '%".$name."%' AND age LIKE '%".$age."%' AND sex LIKE '%".$sex."%' ORDER BY id ASC
php的mysql模糊查询,可以允许空值(空值则查询全部),具体代码如下:
$sql = "SELECT * FROM user WHERE name LIKE '%".$name."%' AND age LIKE '%".$age."%' AND sex LIKE '%".$sex."%' ORDER BY id ASC