fetch_product.php

<?php
include("database.php");

$lastProductID = isset($_GET['lastProductID']) ? intval($_GET['lastProductID']) : 0;
$randomMode = isset($_GET['randomMode']) && $_GET['randomMode'] == 'true';
$productType = isset($_GET['productType']) ? $_GET['productType'] : null; // New parameter for product type

$limit = 30;

// Start building the base query
$query = "SELECT * FROM products WHERE Stock > 0";

// Modify the query based on product type
$params = [];
if ($productType) {
    // If product type is not null, filter by that type
    $query .= " AND ProductType = ?";
    $params[] = $productType; // Add product type to params for binding
} else {
    // If product type is null, fetch both coffin and urn
    $query .= " AND ProductType IN ('coffin', 'urn')";
}

// If lastProductID is provided and not in random mode, add to query
if (!$randomMode && $lastProductID > 0) {
    $query .= " AND ProductID > ?";
    $params[] = $lastProductID; // Add lastProductID to params for binding
}

// Modify the query to use random order if randomMode is true
if ($randomMode) {
    $query .= " ORDER BY RAND()";
} else {
    $query .= " ORDER BY ProductID ASC";
}

$query .= " LIMIT $limit";

// Prepare the statement
$stmt = $connect->prepare($query);

// Bind parameters based on the number of params
if (!empty($params)) {
    // Create the binding types string
    $bindingTypes = str_repeat("s", count($params)); // Assuming all are strings
    $stmt->bind_param($bindingTypes, ...$params);
}

// Execute the statement
$stmt->execute();
$result = $stmt->get_result();

$products = [];
while ($row = $result->fetch_assoc()) {
    $products[] = $row;
}

// Set the content type and return the JSON response
header('Content-Type: application/json');
echo json_encode($products);
?>