connect_error) {
die("Database connection failed: " . $conn->connect_error);
}
// get id from URL
$id = $_GET['id'] ?? null;
if (!$id) {
die("No ID provided.");
}
// query client data
$stmt = $conn->prepare("SELECT * FROM clients WHERE client_code = ?");
$stmt->bind_param("s", $id);
$stmt->execute();
$result = $stmt->get_result();
$client = $result->fetch_assoc();
if (!$client) {
die("Client not found.");
}
?>
ID Card - <?= htmlspecialchars($client['name']) ?>
Iqama:
Company:
 ?>)
 ?>)
Certificate:
Issue: | Expiry:
Examiner:
 ?>)