```php
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$stmt = $conn->prepare("INSERT INTO service_records
(client_name, contact_number, equipment_type, brand, serial_number,
issue_description, service_date, technician, service_notes, status)
VALUES
(:clientName, :contactNumber, :equipmentType, :brand, :serialNumber,
:issueDescription, :serviceDate, :technician, :serviceNotes, 'Completed')");
$stmt->execute([
':clientName' => $_POST['clientName'],
':contactNumber' => $_POST['contactNumber'],
':equipmentType' => $_POST['equipmentType'],
':brand' => $_POST['brand'],
':serialNumber' => $_POST['serialNumber'],
':issueDescription' => $_POST['issueDescription'],
':serviceDate' => $_POST['serviceDate'],
':technician' => $_POST['technician'],
':serviceNotes' => $_POST['serviceNotes']
]);
$success = "Service record saved successfully!";
}
// Get all records
$records = $conn->query("SELECT * FROM service_records ORDER BY service_date DESC LIMIT 20")->fetchAll(PDO::FETCH_ASSOC);
} catch(PDOException $e) {
$error = "Database error: " . $e->getMessage();
}
?>
Service Records | BHBM
|
() |
30 ? '...' : '' ?> |
|
|
View
Delete
|
```