Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>BUTTON QUERY</title>
- <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.1/jquery.js"></script>
- <script type="text/javascript">
- $(document).ready(function()
- {
- $('button.hello').click(function(e)
- {
- $.get("table.php?name=" + $('input[name="fname"]').val() + "&fam="
- + $('input[name="lname"]').val(), function(data){
- $(".view").html(data);
- });
- return false;
- });
- });
- </script>
- </head>
- <body>
- First name: <input type="text" name="fname"><br>
- Last name: <input type="text" name="lname"><br>
- <button type="button" class="hello">PRESSSSS</button>
- <div class = "view">
- </div>
- </body>
- </html>
- <?php
- include ('config/boot.php');
- $person_name = $_GET['name'];
- $person_fam = $_GET['fam'];
- //var_dump($person_name, $person_fam);
- $dbcursor = $db->query("
- SELECT *
- FROM PERSONS_TBL
- WHERE NAME ='" . $person_name . "' AND FAM = '" . $person_fam. "'");
- $person = $dbcursor->fetch_object();
- //var_dump($person);
- if($person == null) {echo "Does not exist!!"; exit;}
- $dbcursor = $db->query("
- SELECT *
- FROM TELS_TBL T, TELTYPES_TBL TT
- WHERE PID=$person->ID AND T.TID = TT.ID
- ");
- $tels = [];
- while($helptels = $dbcursor->fetch_object()) $tels[] = $helptels;
- ?>
- <table>
- <tr>
- <th>NOMER</th>
- <th>TELTYPE</th>
- </tr>
- <?php foreach($tels as $row){?>
- <tr>
- <td><?php echo $row->NOMER;?></td>
- <td><?php echo $row->TELTYPE;?></td>
- </tr>
- <?php } ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement