✏ EDIT: product_detail.php

<?php
// Product detail page
require_once __DIR__ . '/includes/header.php';

// Get product ID from query string
$product_id = isset($_GET['id']) ? intval($_GET['id']) : 0;
if ($product_id <= 0) {
    redirect('/products.php');
}

// Fetch product
$stmt = $conn->prepare("SELECT * FROM products WHERE id = ? LIMIT 1");
$stmt->bind_param('i', $product_id);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows === 0) {
    // Product not found
    include __DIR__ . '/includes/footer.php';
    exit;
}
$product = $result->fetch_assoc();
?>
<main>

<section class="container bordered-section" style="padding:40px 0;">
        <h1><?php echo e($product['title']); ?></h1>
        <div style="display:flex;flex-wrap:wrap;gap:30px;margin-top:20px;">
            <div style="flex:1 1 400px;min-width:300px;">
                <?php
                    // Use the product image uploaded via the admin panel if available; otherwise use a generic placeholder.
                    $img = !empty($product['image_path']) ? $product['image_path'] : 'assets/images/placeholder_light_gray_block.png';
                ?>
                <img src="<?php echo e($img); ?>" alt="<?php echo e($product['title']); ?>" style="width:100%;border-radius:6px;object-fit:cover;">
            </div>
            <div style="flex:1 1 400px;min-width:300px;">
                <?php if (!empty($product['features'])): ?>
                    <h3>Features</h3>
                    <div style="margin-bottom:20px;">
                        <?php echo nl2br(e($product['features'])); ?>
                    </div>
                <?php endif; ?>
                <?php if (!empty($product['specifications'])): ?>
                    <h3>Specifications</h3>
                    <div>
                        <?php echo nl2br(e($product['specifications'])); ?>
                    </div>
                <?php endif; ?>
            </div>
        </div>
        
        <p style="margin-top:20px;font-size:16px;color:#555;">
            Our <?php echo e($product['title']); ?> solutions are engineered to meet the unique climate
            and operational needs of enterprises across Telangana and Andhra&nbsp;Pradesh.
            Whether you operate a food processing unit, pharmaceutical facility,
            horticulture venture or retail outlet, our systems deliver superior
            reliability and efficiency so your products remain fresh and safe.
            Contact us today to discover how we can customise this system to your
            requirements and help your business thrive.
        </p>
        
        <div class="booking-section" style="margin-top:30px;">
            <div class="booking-container">
                <div class="booking-card">
                    <i class="fas fa-calendar-check"></i>
                    <h3>Appointment</h3>
                    <p>Schedule a consultation or site visit at your convenience.</p>
                    <a href="/book_appointment.php" class="btn">Book Now</a>
                </div>
                <div class="booking-card">
                    <i class="fas fa-tools"></i>
                    <h3>Service Booking</h3>
                    <p>Request installation, maintenance or repairs for your equipment.</p>
                    <a href="/book_service.php" class="btn">Book Service</a>
                </div>
                <div class="booking-card">
                    <i class="fas fa-cubes"></i>
                    <h3>Parts Request</h3>
                    <p>Order spare parts and accessories for this product.</p>
                    <a href="/book_parts.php" class="btn">Request Parts</a>
                </div>
            </div>
        </div>
        <div style="margin-top:30px;">
            <a href="/products.php" style="color:#2674b3;font-weight:bold;">&larr; Back to Products</a>
        </div>
    </section>
</main>
<?php include __DIR__ . '/includes/footer.php'; ?>

[✗] CANCEL