Advertisement
rabirajkhadka

random code php

Oct 18th, 2022
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. <?php
  2. $sql_pendingReg = $dm->conn->query("SELECT * FROM ".TREKKER." WHERE trek_status = 'Pending' AND reg_status = 'Complete' ORDER BY id DESC");
  3. while ($fth_pendingReg = $sql_pendingReg->fetch_array()) {
  4. $pTid = $fth_pendingReg['id'];
  5. $pt_firstname = $fth_pendingReg['first_name'];
  6. $pt_familyname = $fth_pendingReg['family_name'];
  7. $pt_bleDeviceId = ($fth_pendingReg['ble_device_id']);
  8. $pt_contactNo = $fth_pendingReg['contact_no'];
  9. $pt_email = $fth_pendingReg['email'];
  10. $sql_lastCheckpointInfo = $dm->conn->query("SELECT * FROM ".TREK_DETAILS." INNER JOIN ".CHECKPOINT."
  11. 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");
  12.  
  13. $fth_lastCheckpointInfo = $sql_lastCheckpointInfo->fetch_array();
  14. $lastCheckpointName = $fth_lastCheckpointInfo['name'] ?? '-';
  15.  
  16.  
  17.  
  18. ?>
  19.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement