Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // php populate html table from mysql database
- $hostname = "localhost";
- $username = "root";
- $password = "";
- $databaseName = "detailsdb";
- // connect to mysql
- $connect = mysqli_connect($hostname, $username, $password, $databaseName);
- // mysql select query
- $query = "SELECT * FROM details ORDER BY Id DESC LIMIT 1";
- // result for method one
- $result1 = mysqli_query($connect, $query);
- // result for method two
- $result2 = mysqli_query($connect, $query);
- $query3="SELECT Latitude ,Longitude FROM details ";
- $result3=mysqli_query($connect, $query3);
- <!DOCTYPE html>
- <html>
- <head>
- <title>Hello User</title>
- <script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyDyXdL4cZlxo3ldIuvi6_HpZa2jhj7iOU0&callback=initMap"
- async defer></script>
- <style>#mapcanvas { height: 600px; width: 1500px}</style>
- <script>
- function loadmap() {
- <?php while( $row3 = mysqli_fetch_array($result3)):;?>
- var x=<?php echo $row3[0];?>;
- var y=<?php echo $row3[1];?>;
- <?php endwhile;?>
- var uluru = {lat: x, lng: y};
- var map = new google.maps.Map(document.getElementById('mapcanvas'), {zoom: 18,center: uluru });
- var marker = new google.maps.Marker({position: uluru,map: map})
- setInterval(loadmap,3000);
- }
- </script>
- </head>
- <body onload="loadmap()">
- <h1>Tracking Program</h1>
- <div id="mapcanvas"></div>
- <table style="background-color: red;">
- <tr>
- <th>First Name</th>
- <th>Last Name</th>
- <th>Id</th>
- <th>Phone Number</th>
- <th>Address</th>
- <th>Latitude</th>
- <th>Longitude</th>
- </tr>
- <?php $row1 = mysqli_fetch_array($result1);?>
- <tr>
- <td><?php echo $row1[0];?></td>
- <td><?php echo $row1[1];?></td>
- <td><?php echo $row1[2];?></td>
- <td><?php echo $row1[3];?></td>
- <td><?php echo $row1[4];?></td>
- <td><?php echo $row1[5];?></td>
- <td><?php echo $row1[6];?></td>
- </tr>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement