­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ 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 CONCAT(id,'-',offer_name) = '$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 valid and active offer details from database $sql = "SELECT * FROM offers_details WHERE offer_id = '$offer_id'"; $result = $conn->query($sql); // Check if query was successful if (!$result) { die("Error in SQL query: " . $conn->error); } ?> <?php echo $title; ?>

fetch_assoc()) { $originalImage = $row['image_url']; $kdoriginalImage = "/home/balubaid/specialoffers.autozone.com.sa/assets/".$offer_slug."/".$row['imagename']; $kdwebpImage = preg_replace('/\.(jpg|jpeg|png)$/i', '.webp', $kdoriginalImage); $webpImage = preg_replace('/\.(jpg|jpeg|png)$/i', '.webp', $originalImage); if (!file_exists($kdwebpImage)) { convertToWebP($kdoriginalImage, $kdwebpImage); } $endDate = $row['end_date']; $offerId = "countdown-" . $row['id']; ?>
Offer Image

Offer Valid Till

Request Cash Request Installment
close(); ?>