query($updateSql)) { header("Location: detail_view.php?id={$recordID}&status_updated={$newStatus}"); exit; } } $sql = "SELECT * FROM customer_data WHERE id = $recordID LIMIT 1"; $result = $conn->query($sql); if ($result && $result->num_rows > 0) { $row = $result->fetch_assoc(); } else { echo "Record not found."; exit; } function fileLink($path) { return !empty($path) ? 'View' : 'N/A'; } ?>
Villa/Apartment No.: = htmlspecialchars($row['villa_apartment_no']) ?>
Building/Compound Name: = htmlspecialchars($row['building_name']) ?>
Street Name: = htmlspecialchars($row['street_name']) ?>
Area Name: = htmlspecialchars($row['area_name']) ?>
Emirate Name: = htmlspecialchars($row['emirate_name']) ?>
Landmark: = htmlspecialchars($row['landmark']) ?>
Mobile 1: = htmlspecialchars($row['mobile_1']) ?>
Email: = htmlspecialchars($row['personal_email']) ?>
Office No.: = htmlspecialchars($row['office_no']) ?>
Building Name: = htmlspecialchars($row['office_building_name']) ?>
Street Name: = htmlspecialchars($row['office_street_name']) ?>
Area Name: = htmlspecialchars($row['office_area_name']) ?>
Emirate Name: = htmlspecialchars($row['office_emirate_name']) ?>
Landmark: = htmlspecialchars($row['office_landmark']) ?>
HR Number: = htmlspecialchars($row['hr_number']) ?>
PO Box: = htmlspecialchars($row['po_box']) ?>
Date of Joining: = htmlspecialchars($row['date_of_joining']) ?>
Bank Name: = htmlspecialchars($row['bank_name']) ?>
IBAN: = htmlspecialchars($row['iban']) ?>
Account Number: = htmlspecialchars($row['account_number']) ?>
Salary: = htmlspecialchars($row['salary']) ?>
Reference 1 - Full Name: = htmlspecialchars($row['ref1_name']) ?>
Mobile No.: = htmlspecialchars($row['ref1_mobile']) ?>
Reference 2 - Full Name: = htmlspecialchars($row['ref2_name']) ?>
Mobile No.: = htmlspecialchars($row['ref2_mobile']) ?>
Family in UAE?: = htmlspecialchars($row['family_in_uae']) ?>
Marital Status: = htmlspecialchars($row['marital_status']) ?>
No. of Dependants: = htmlspecialchars($row['dependants']) ?>
No. of Children: = htmlspecialchars($row['children']) ?>
Children at School: = htmlspecialchars($row['children_at_school']) ?>
Emirates ID: = fileLink($row['emirates_id']) ?>
Passport: = fileLink($row['passport']) ?>
Visa: = fileLink($row['visa']) ?>
Salary Certificate: = fileLink($row['salary_certificate']) ?>
Bank Statement: = fileLink($row['bank_statement']) ?>
Salary Slip: = fileLink($row['salary_slip']) ?>