✏ EDIT: products.php

<?php
// Products listing page
$pageTitle = 'Our Products - Blueswirlz Engineers & Consultants';
require_once __DIR__ . '/includes/header.php';

// Fetch all products
$products = [];
$sql = "SELECT * FROM products ORDER BY id ASC";
$res = $conn->query($sql);
if ($res && $res->num_rows > 0) {
    while ($row = $res->fetch_assoc()) {
        $products[] = $row;
    }
}

?>
<main>
    <section class="container bordered-section" style="padding:40px 0;">
        <h1>Our Products</h1>
        <p>
            We design and manufacture a wide range of cold rooms and refrigeration
            solutions tailored to your business needs across Telangana and
            Andhra&nbsp;Pradesh. Browse our product categories below to discover
            systems that work for you, and click to learn more about each
            solution.
        </p>
        <div class="cards" style="display:flex;flex-wrap:wrap;gap:20px;justify-content:space-between;margin-top:30px;">
            <?php foreach ($products as $index => $product): ?>
                <?php
                    // Determine which image to use: use the admin‑uploaded image if available, otherwise use a generic placeholder.
                    $prodImg = !empty($product['image_path']) ? $product['image_path'] : 'assets/images/placeholder_light_gray_block.png';
                ?>
                <div class="product-card" style="flex:1 1 calc(33% - 20px);min-width:260px;">
                    <img src="<?php echo e($prodImg); ?>" alt="<?php echo e($product['title']); ?>" style="height:180px;object-fit:cover;border-radius:4px;width:100%;">
                    <h4 style="margin-top:15px;font-size:22px;color:#1c5a8a;"><?php echo e($product['title']); ?></h4>
                    <p style="height:80px;overflow:hidden;font-size:14px;color:#555;">
                        <?php echo e(truncate_words($product['description'], 25)); ?>
                    </p>
                    <a href="/product_detail.php?id=<?php echo $product['id']; ?>" style="background:#2674b3;color:#fff;padding:8px 15px;border-radius:4px;display:inline-block;font-size:14px;margin-top:10px;">Read More</a>
                </div>
            <?php endforeach; ?>
        </div>
    </section>
</main>
<?php include __DIR__ . '/includes/footer.php'; ?>

[✗] CANCEL