使用php变量创建动态mysql查询

只需检查变量是否包含值，如果它们包含，就可以像下面这样构建查询：

unset($sql);if ($stationFilter) {    $sql[] = " STATION_NETWORK = '$stationFilter' ";}if ($verticalFilter) {    $sql[] = " VERTICAL = '$verticalFilter' ";}$query = "SELECt * FROM $tableName";if (!empty($sql)) {    $query .= ' WHERe ' . implode(' AND ', $sql);}echo $query;// mysql_query($query);