File size: 2,422 Bytes
ff9ae2f | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | ```php
<?php
$id = $_GET['id'] ?? 0;
try {
$conn = new PDO("mysql:host=localhost;dbname=bhbm_service", "username", "password");
$stmt = $conn->prepare("SELECT * FROM service_records WHERE id = ?");
$stmt->execute([$id]);
$record = $stmt->fetch(PDO::FETCH_ASSOC);
} catch(PDOException $e) {
die("Database error: " . $e->getMessage());
}
?>
<!DOCTYPE html>
<html>
<head>
<title>View Record | BHBM</title>
<script src="https://cdn.tailwindcss.com"></script>
</head>
<body class="bg-gray-50 p-8">
<div class="max-w-4xl mx-auto bg-white rounded-lg shadow-md p-6">
<h1 class="text-2xl font-bold mb-6">Service Record Details</h1>
<?php if ($record): ?>
<div class="space-y-4">
<div class="grid grid-cols-1 md:grid-cols-2 gap-4">
<div><strong>Client Name:</strong> <?= htmlspecialchars($record['client_name']) ?></div>
<div><strong>Contact:</strong> <?= htmlspecialchars($record['contact_number']) ?></div>
</div>
<div class="grid grid-cols-1 md:grid-cols-2 gap-4">
<div><strong>Equipment:</strong> <?= htmlspecialchars($record['equipment_type']) ?></div>
<div><strong>Brand:</strong> <?= htmlspecialchars($record['brand']) ?></div>
</div>
<div><strong>Serial Number:</strong> <?= htmlspecialchars($record['serial_number']) ?></div>
<div><strong>Service Date:</strong> <?= date('m/d/Y', strtotime($record['service_date'])) ?></div>
<div><strong>Technician:</strong> <?= htmlspecialchars($record['technician']) ?></div>
<div><strong>Status:</strong> <span class="px-2 inline-flex text-xs leading-5 font-semibold rounded-full bg-green-100 text-green-800"><?= $record['status'] ?></span></div>
<div><strong>Issue Description:</strong><div class="mt-1 p-2 bg-gray-50 rounded"><?= nl2br(htmlspecialchars($record['issue_description'])) ?></div></div>
<div><strong>Service Notes:</strong><div class="mt-1 p-2 bg-gray-50 rounded"><?= nl2br(htmlspecialchars($record['service_notes'])) ?></div></div>
</div>
<div class="mt-6">
<a href="service_records.php" class="px-4 py-2 bg-green-500 text-white rounded">Back to Records</a>
</div>
<?php else: ?>
<p class="text-red-500">Record not found</p>
<?php endif; ?>
</div>
</body>
</html>
``` |