prepare("INSERT INTO pumps (bunk_id, tank_id, pump_number) VALUES (?, ?, ?)");
$stmt->execute([$bunk_id, $tank_id, $pump_number]);
$message = 'Pump added successfully!
';
} catch (PDOException $e) {
$message = 'Error: ' . $e->getMessage() . '
';
}
} else {
$message = 'Please fill in all fields.
';
}
}
// Fetch related data for forms
$bunks = $pdo->query("SELECT id, name FROM bunks ORDER BY name")->fetchAll(PDO::FETCH_ASSOC);
$tanks = $pdo->query("
SELECT t.id, t.name as tank_name, b.name as bunk_name, ft.name as fuel_type_name
FROM tanks t
JOIN bunks b ON t.bunk_id = b.id
JOIN fuel_types ft ON t.fuel_type_id = ft.id
ORDER BY b.name, t.name
")->fetchAll(PDO::FETCH_ASSOC);
// Fetch all pumps with their bunk and tank name
$stmt = $pdo->query("
SELECT p.id, p.pump_number, b.name AS bunk_name, t.name as tank_name, ft.name as fuel_type_name
FROM pumps p
JOIN bunks b ON p.bunk_id = b.id
LEFT JOIN tanks t ON p.tank_id = t.id
LEFT JOIN fuel_types ft ON t.fuel_type_id = ft.id
ORDER BY b.name, p.pump_number
");
$pumps = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
Manage Pumps
List of all fuel pumps and their assigned tanks.
| Pump Number |
Bunk |
Tank |
Fuel Type |
| No pumps found. Add one to get started. |
|
|
|
|