Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $sql_pendingReg = $dm->conn->query("SELECT * FROM ".TREKKER." WHERE trek_status = 'Pending' AND reg_status = 'Complete' ORDER BY id DESC");
- while ($fth_pendingReg = $sql_pendingReg->fetch_array()) {
- $pTid = $fth_pendingReg['id'];
- $pt_firstname = $fth_pendingReg['first_name'];
- $pt_familyname = $fth_pendingReg['family_name'];
- $pt_bleDeviceId = ($fth_pendingReg['ble_device_id']);
- $pt_contactNo = $fth_pendingReg['contact_no'];
- $pt_email = $fth_pendingReg['email'];
- $sql_lastCheckpointInfo = $dm->conn->query("SELECT * FROM ".TREK_DETAILS." INNER JOIN ".CHECKPOINT."
- ON ".TREK_DETAILS.".checkpoint_id = ".CHECKPOINT.".id WHERE ".TREK_DETAILS.".trekker_id = '$pTid' AND ".TREK_DETAILS.".device_id = '$pt_bleDeviceId' AND ".TREK_DETAILS.".check_in = 1 ORDER BY ".TREK_DETAILS.".id DESC LIMIT 1");
- $fth_lastCheckpointInfo = $sql_lastCheckpointInfo->fetch_array();
- $lastCheckpointName = $fth_lastCheckpointInfo['name'] ?? '-';
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement