Untitled

<?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);


$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>