header("refresh:30"); include $_SERVER['DOCUMENT_ROOT'] . "/WebApp/assesor/html.class.php"; $db = new DBMain(); $WebApp->pageHeading('BOOKINGS DASHBOARD'); $res = $db->exec_query('bookings', ['*'], '', '', '', '', "safesure_users_id = {$_SESSION['user_id']} AND status = 'APPROVED'", "ORDER BY record_id DESC"); if ($res->num_rows < 1) { echo "
| BOOKING DATE | STATUS | ASSESOR | CLIENT | |
|---|---|---|---|---|
| ' /> | ' /> | $user_res = $db->exec_query('safesure_users', ['*'], '', '', '', '', "record_id = {$row['safesure_users_id']}"); $assesor = $user_res->fetch_assoc(); ?> ' /> | $client_res = $db->exec_query('clients', ['*'], '', '', '', '', "record_id = {$row['clients_id']}"); $client = $client_res->fetch_assoc(); ?> ' /> |