­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ ­ 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); } // Function to resize and convert images to WebP function resizeAndConvertToWebP($source, $destination, $quality = 65, $newWidth = 1080, $newHeight = 1080) { $info = getimagesize($source); if (!$info) { return false; // Invalid image } // Create image resource from 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; // Unsupported format } // Get original dimensions $width = imagesx($image); $height = imagesy($image); // Create a new true color image with the specified size $resizedImage = imagecreatetruecolor($newWidth, $newHeight); // Preserve transparency for PNG if ($info['mime'] == 'image/png') { imagealphablending($resizedImage, false); imagesavealpha($resizedImage, true); $transparent = imagecolorallocatealpha($resizedImage, 0, 0, 0, 127); imagefilledrectangle($resizedImage, 0, 0, $newWidth, $newHeight, $transparent); } // Resize image imagecopyresampled($resizedImage, $image, 0, 0, 0, 0, $newWidth, $newHeight, $width, $height); // Convert and save as WebP $result = imagewebp($resizedImage, $destination, $quality); // Free memory imagedestroy($image); imagedestroy($resizedImage); return $result; } // Fetch only valid and active special offers from database $sql = "SELECT * FROM special_offers WHERE isactive = 1 AND start_date <= CONVERT_TZ(NOW(), @@session.time_zone, '+03:00') AND end_date >= CONVERT_TZ(NOW(), @@session.time_zone, '+03:00') ORDER BY RAND()"; $result = $conn->query($sql); // Check if query was successful if (!$result) { die("Error in SQL query: " . $conn->error); } ?> عروض خاصة

عروض خاصة

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

العرض ساري حتى

/" class="btn first-button ">قدّم الآن
WhatsApp
close(); ?>