Advertisement
minilose

Untitled

Mar 13th, 2023
219
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>BUTTON QUERY</title>
  4. <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.1/jquery.js"></script>
  5. <script type="text/javascript">
  6. $(document).ready(function()
  7. {
  8. $('button.hello').click(function(e)
  9. {
  10. $.get("table.php?name=" + $('input[name="fname"]').val() + "&fam="
  11. + $('input[name="lname"]').val(), function(data){
  12. $(".view").html(data);
  13. });
  14. return false;
  15. });
  16. });
  17. </script>
  18. </head>
  19. <body>
  20. First name: <input type="text" name="fname"><br>
  21. Last name: <input type="text" name="lname"><br>
  22. <button type="button" class="hello">PRESSSSS</button>
  23. <div class = "view">
  24.  
  25. </div>
  26. </body>
  27. </html>
  28.  
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.  
  39.  
  40.  
  41.  
  42. <?php
  43. include ('config/boot.php');
  44.  
  45. $person_name = $_GET['name'];
  46. $person_fam = $_GET['fam'];
  47.  
  48. //var_dump($person_name, $person_fam);
  49.  
  50. $dbcursor = $db->query("
  51. SELECT *
  52. FROM PERSONS_TBL
  53. WHERE NAME ='" . $person_name . "' AND FAM = '" . $person_fam. "'");
  54.  
  55. $person = $dbcursor->fetch_object();
  56.  
  57. //var_dump($person);
  58. if($person == null) {echo "Does not exist!!"; exit;}
  59.  
  60. $dbcursor = $db->query("
  61. SELECT *
  62. FROM TELS_TBL T, TELTYPES_TBL TT
  63. WHERE PID=$person->ID AND T.TID = TT.ID
  64. ");
  65.  
  66. $tels = [];
  67.  
  68. while($helptels = $dbcursor->fetch_object()) $tels[] = $helptels;
  69. ?>
  70. <table>
  71. <tr>
  72. <th>NOMER</th>
  73. <th>TELTYPE</th>
  74. </tr>
  75. <?php foreach($tels as $row){?>
  76. <tr>
  77. <td><?php echo $row->NOMER;?></td>
  78. <td><?php echo $row->TELTYPE;?></td>
  79. </tr>
  80. <?php } ?>
  81. </table>
  82.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement