
­­­­­­­­­­­­­­­­­­
<!DOCTYPE html>
<html>
<?php
$servername = "localhost";  // Change this if necessary
$username = "balubaid_autozoneoffers";         // Your database username
$password = "Vision@2050";             // Your database password
$database = "balubaid_autozoneoffers";  // Your database name

// Create a connection
$conn = new mysqli($servername, $username, $password, $database);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Fetch special offers from database
$sql = "SELECT * FROM special_offers ORDER BY id DESC";
$result = $conn->query($sql);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Special Offers</title>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css">
</head>
<body>
    <div class="container text-center my-5">
        <h1 class="mb-4">Special Offers</h1>
        <div class="row">
            <?php while ($row = $result->fetch_assoc()) { ?>
                <div class="col-md-6 mb-4">
                    <div class="card shadow-sm">
                        <img src="<?php echo $row['image_url']; ?>" class="card-img-top" alt="Offer Image">
                        <div class="card-body">
                            <h5 class="card-title"><?php echo $row['title']; ?></h5>
                            <p class="card-text"><?php echo $row['description']; ?></p>
                            <p class="fw-bold">Starting from: <?php echo $row['price']; ?> SAR</p>
                            <a href="<?php echo $row['button_link']; ?>" class="btn btn-primary"><?php echo $row['button_text']; ?></a>
                        </div>
                    </div>
                </div>
            <?php } ?>
        </div>
    </div>
</body>
</html>

<?php
$conn->close();
?>
