// Get filters
$state = isset($_GET['state']) ? trim($_GET['state']) : '';
$city = isset($_GET['city']) ? trim($_GET['city']) : '';
$category = isset($_GET['category']) ? trim($_GET['category']) : '';
// Base query
$sql = "SELECT * FROM ads WHERE 1";
// Filters
if($state != ''){
$state = mysqli_real_escape_string($conn, $state);
$sql .= " AND state='$state'";
}
if($city != ''){
$city = mysqli_real_escape_string($conn, $city);
$sql .= " AND city='$city'";
}
if($category != ''){
$category = mysqli_real_escape_string($conn, $category);
$sql .= " AND category='$category'";
}
// Order
$sql .= " ORDER BY pinned DESC, created_at DESC";
$result = mysqli_query($conn, $sql);
$ads = mysqli_fetch_all($result, MYSQLI_ASSOC);
?>
Classified Ads
Classified Ads
No ads found.
