include 'system/db.php';
$now = time();
$result2 = $conn->query("SELECT * FROM `adboard_ads` WHERE `ad_end` > '$now'");
if(isset($_GET['key'])){
$cat = $_GET['c'];
$location = $_GET['l'];
$term = $_GET['term'];
if($cat == 'All'){
if($location == 'All'){
$result2 = $conn->query("SELECT * FROM adboard_ads WHERE ad_title LIKE '%$term%'");
} else {
$result2 = $conn->query("SELECT * FROM adboard_ads WHERE ad_title LIKE '%$term%' AND `ad_location` = '$location'");
}
} else {
if($location == 'All'){
$result2 = $conn->query("SELECT * FROM adboard_ads WHERE ad_title LIKE '%$term%' AND `ad_cat` = '$cat'");
} else {
$result2 = $conn->query("SELECT * FROM adboard_ads WHERE ad_title LIKE '%$term%' AND `ad_cat` = '$cat' AND `ad_location` = '$location'");
}
}
}
if(isset($_GET['location'])){
$location = $conn->real_escape_string($_GET['location']);
$result2 = $conn->query("SELECT * FROM adboard_ads WHERE ad_location LIKE '%$location%' OR ad_city LIKE '%$location%'");
}
if(isset($_GET['cat'])){
$cat = $conn->real_escape_string($_GET['cat']);
$result2 = $conn->query("SELECT * FROM adboard_ads WHERE ad_cat LIKE '%$cat%' OR ad_sub_cat LIKE '%$cat%'");
}
$getTITLE = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM `header_system` WHERE `header_name` = 'title_1'"));
$metatitle = $getTITLE['header_content'];
$getDESC = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM `header_system` WHERE `header_name` = 'description_1'"));
$metadesc = $getDESC['header_content'];
$getKEY = mysqli_fetch_assoc(mysqli_query($conn, "SELECT * FROM `header_system` WHERE `header_name` = 'keywords_1'"));
$metakey = $getKEY['header_content'];
?>
echo $metatitle; ?>
$result = $conn->query("SELECT ad_cat, COUNT(ad_cat) as 'amount' FROM adboard_ads GROUP BY ad_cat ORDER BY amount DESC");
while ($row = $result->fetch_assoc()) {
$ad_cat = $row['ad_cat'];
$amount = $row['amount'];
?>