prepare("INSERT INTO credit_customers (name, contact, address, credit_limit) VALUES (?, ?, ?, ?)"); $stmt->execute([$name, $contact, $address, $credit_limit]); $customer_message = '

Customer added successfully!

'; } catch (PDOException $e) { $customer_message = '

Error: ' . $e->getMessage() . '

'; } } else { $customer_message = '

Customer name is required.

'; } } // Handle form submission for adding a new vehicle if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_vehicle'])) { $customer_id = $_POST['customer_id']; $vehicle_number = trim($_POST['vehicle_number']); if (!empty($customer_id) && !empty($vehicle_number)) { try { $stmt = $pdo->prepare("INSERT INTO vehicles (customer_id, vehicle_number) VALUES (?, ?)"); $stmt->execute([$customer_id, $vehicle_number]); $vehicle_message = '

Vehicle added successfully!

'; } catch (PDOException $e) { $vehicle_message = '

Error: ' . $e->getMessage() . '

'; } } else { $vehicle_message = '

Vehicle number is required.

'; } } // Fetch all customers $customers_stmt = $pdo->query("SELECT * FROM credit_customers ORDER BY name"); $customers = $customers_stmt->fetchAll(PDO::FETCH_ASSOC); // Fetch all vehicles and group by customer $vehicles_stmt = $pdo->query("SELECT * FROM vehicles ORDER BY vehicle_number"); $all_vehicles = $vehicles_stmt->fetchAll(PDO::FETCH_ASSOC); $vehicles_by_customer = []; foreach ($all_vehicles as $vehicle) { $vehicles_by_customer[$vehicle['customer_id']][] = $vehicle; } ?>

Manage Credit Customers

Existing Customers

Name	Contact	Address	Credit Limit	Vehicles
No customers found.
				'; } } else { echo 'No vehicles'; } ?>

Manage Credit Customers

Existing Customers

Add New Customer

Add Vehicle to Customer