­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ connect_error) { die("Connection failed: " . $conn->connect_error); } // Ensure database timezone matches Riyadh timezone $conn->query("SET time_zone = '+03:00'"); // Function to convert images to WebP function convertToWebP($source, $destination, $quality = 65) { $info = getimagesize($source); if ($info['mime'] == 'image/jpeg' || $info['mime'] == 'image/jpg') { $image = imagecreatefromjpeg($source); } elseif ($info['mime'] == 'image/png') { $image = imagecreatefrompng($source); imagepalettetotruecolor($image); imagealphablending($image, true); imagesavealpha($image, true); } else { return false; } return imagewebp($image, $destination, $quality); } $subpage = $_GET['subpage']; // Fetch only valid and active special offers from database $sql = "SELECT * FROM special_offers WHERE id = '$subpage'"; $result = $conn->query($sql); // Check if query was successful if (!$result) { die("Error in SQL query: " . $conn->error); } //Fetch Offer Details while ($row1 = $result->fetch_assoc()) { $title = $row1['title']; $title_ar = $row1['title_ar']; $description = $row1['description']; $description_ar = $row1['description_ar']; $offer_id = $row1['id']; $offer_slug = $row1['offer_name']; $ogimage_url = $row1['image_url']; } // Fetch only select offer car details from database $sql = "SELECT * FROM offers_details WHERE offer_id = '$offer_id' order by rand()"; $result = $conn->query($sql); // Check if query was successful if (!$result) { die("Error in SQL query: " . $conn->error); } while ($row2 = $result->fetch_assoc()) { $car_names_en[] = $row2['car_name']; $car_names_ar[] = $row2['car_name_ar']; } if($_GET['car_id'] == ''){ }else{ $car_id = $_GET['car_id']; // Fetch only select offer car details from database $sql = "SELECT * FROM offers_details WHERE id = '$car_id'"; $result = $conn->query($sql); // Check if query was successful if (!$result) { die("Error in SQL query: " . $conn->error); } while ($row3 = $result->fetch_assoc()) { $single_car_names_en = $row3['car_name']; $single_car_names_ar = $row3['car_name_ar']; } } $utm_campaign = $_SESSION['utm_campaign']; $utm_source = $_SESSION['utm_source']; ?> <?php echo $title; ?>

Your Next Car is Just a Step Away – Get Started Today!

" name="utm_campaign">

close(); ?>