Advertisement
vesso8

get-tels-html

Mar 7th, 2022
1,278
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.77 KB | None | 0 0
  1. <?php
  2. include('config/boot.php');
  3. $person_name = $_GET['name'];
  4. $person_fam = $_GET['fam'];
  5. // var_dump($person_name);
  6. // var_dump($person_fam);
  7. $dbcursor = $db->query("
  8. SELECT ID
  9. FROM PERSONS_TBL
  10. WHERE NAME = '$person_name' AND FAM = '$person_fam'
  11. ");
  12. $person = $dbcursor->fetch_object();
  13. // var_dump($person);
  14. if($person == null) {echo "Ist nicht da-a-a!!!"; exit;}
  15. $dbcursor = $db->query("
  16. SELECT *
  17. FROM TELS_TBL T, TELTYPES_TBL TT
  18. WHERE PID=$person->ID AND T.TID = TT.ID
  19. ");
  20. $tels = [];
  21. while($helptels = $dbcursor->fetch_object()) $tels[] = $helptels;
  22. // var_dump($tels);
  23. ?>
  24. <table class='grid'>
  25. <tr>
  26. <th>TelType</th>
  27. <th>Nomer</th>
  28. <tr>
  29. <?php
  30. foreach($tels as $t)
  31. {
  32. echo "<tr>
  33. <td>".$t->TELTYPE."</td>
  34. <td>".$t->NOMER."</td>
  35. </tr>";
  36. }
  37. ?>
  38. </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement