在数据库中搜索多个用户输入的文本字段。示例： - 指定，位置，资格，性别等字段

User will input/output some fields and exclude some fields. We want php- SQL query so that it should search in database for only inputted textfield values and display output.

Please try like the following so this can help you from the search string

$query = array();

$query[] = empty($_POST['name']) ? : 'name='.$_POST['name'];
$query[] = empty($address) ? : 'address'.$_POST['address'];
$results = implode('AND', $query);
$test = "SELECT * FROM tableName where '".$results."'";