✏ EDIT: book_parts.php

<?php
// Public page to request spare parts
$pageTitle = 'Parts Request';
require_once __DIR__ . '/includes/header.php';

// Initialise flags for success and error messages
$success = false;
$error = '';

// Build a list of products for the dropdown.  If the products table
// doesn’t exist, $productList will remain empty.
$productList = [];
$tableCheck = $conn->query("SHOW TABLES LIKE 'products'");
if ($tableCheck && $tableCheck->num_rows > 0) {
    $resProdList = $conn->query("SELECT id, title FROM products ORDER BY title ASC");
    if ($resProdList) {
        while ($row = $resProdList->fetch_assoc()) {
            $productList[] = $row;
        }
    }
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Selected product from the dropdown (ID).  Zero or empty means none selected.
    $selectedProductId = isset($_POST['product_id']) ? (int)$_POST['product_id'] : 0;
    // Optional custom part name when the desired part is not listed
    $manualPartName = trim($_POST['part_name'] ?? '');
    $quantity  = (int)($_POST['quantity'] ?? 1);
    $name   = trim($_POST['name'] ?? '');
    $email  = trim($_POST['email'] ?? '');
    $phone  = trim($_POST['phone'] ?? '');
    $message = trim($_POST['message'] ?? '');
    $measurements = trim($_POST['measurements'] ?? '');

// Determine human‑readable part name based on selection or manual entry
    $selectedPartName = '';
    if ($selectedProductId > 0) {
        $stmtProd = $conn->prepare("SELECT title FROM products WHERE id = ? LIMIT 1");
        if ($stmtProd) {
            $stmtProd->bind_param('i', $selectedProductId);
            $stmtProd->execute();
            $resSel = $stmtProd->get_result();
            if ($resSel && $resSel->num_rows > 0) {
                $prow = $resSel->fetch_assoc();
                $selectedPartName = $prow['title'];
            }
            $stmtProd->close();
        }
    }
    if (!$selectedPartName) {
        $selectedPartName = $manualPartName;
    }

// Compose a combined message to include product ID and measurements
    $combinedMessage = '';
    if ($selectedProductId > 0) {
        $combinedMessage .= 'Selected Product ID: ' . $selectedProductId . "\n";
    }
    if ($measurements) {
        $combinedMessage .= 'Measurements: ' . $measurements . "\n";
    }
    if ($message) {
        $combinedMessage .= $message;
    }

// Basic validation: require a part name (either selected or manual), positive quantity and contact details
    if ($selectedPartName && $quantity > 0 && $name && $email && $phone) {
        $stmtIns = $conn->prepare("INSERT INTO parts_bookings (part_name, quantity, name, email, phone, message) VALUES (?, ?, ?, ?, ?, ?)");
        if ($stmtIns) {
            $stmtIns->bind_param('sissss', $selectedPartName, $quantity, $name, $email, $phone, $combinedMessage);
            if ($stmtIns->execute()) {
                $success = true;
            } else {
                $error = 'Could not save your request. Please try again later.';
            }
            $stmtIns->close();
        } else {
            $error = 'Database error.';
        }
    } else {
        $error = 'Please fill in all required fields.';
    }
}
?>
<main>
    <div class="container bordered-section">
        <h1 style="text-align:center;margin-top:30px;">Parts Request</h1>
        <?php if ($success): ?>
            <p style="color:green;text-align:center;font-weight:bold;">Thank you! Your parts request has been received. Our team will contact you shortly.</p>
        <?php elseif ($error): ?>
            <p style="color:red;text-align:center;font-weight:bold;">
                <?php echo e($error); ?>
            </p>
        <?php endif; ?>
        <form method="post" class="booking-form">
            
            <select name="product_id" style="width:100%;padding:10px;margin-bottom:10px;border:1px solid #ccc;border-radius:4px;">
                <option value="">Select Product (Optional)</option>
                <?php foreach ($productList as $prod): ?>
                    <option value="<?php echo $prod['id']; ?>" <?php echo (isset($_POST['product_id']) && (int)$_POST['product_id'] === (int)$prod['id']) ? 'selected' : ''; ?>><?php echo e($prod['title']); ?></option>
                <?php endforeach; ?>
            </select>
            
            <input type="text" name="part_name" placeholder="Part Name (if not listed)" value="<?php echo isset($_POST['part_name']) ? e($_POST['part_name']) : ''; ?>">
            <input type="number" name="quantity" min="1" placeholder="Quantity" value="<?php echo isset($_POST['quantity']) ? e($_POST['quantity']) : '1'; ?>" required>
            <input type="text" name="name" placeholder="Your Name" value="<?php echo isset($_POST['name']) ? e($_POST['name']) : ''; ?>" required>
            <input type="email" name="email" placeholder="Email Address" value="<?php echo isset($_POST['email']) ? e($_POST['email']) : ''; ?>" required>
            <input type="text" name="phone" placeholder="Phone Number" value="<?php echo isset($_POST['phone']) ? e($_POST['phone']) : ''; ?>" required>
            
            <textarea name="measurements" placeholder="Measurements / Additional Notes (Optional)" style="resize:vertical;"><?php echo isset($_POST['measurements']) ? e($_POST['measurements']) : ''; ?></textarea>
            <textarea name="message" placeholder="Message (Optional)" style="resize:vertical;"><?php echo isset($_POST['message']) ? e($_POST['message']) : ''; ?></textarea>
            <button type="submit">Submit Request</button>
        </form>
    </div>
</main>
<?php require __DIR__ . '/includes/footer.php'; ?>

[✗] CANCEL