Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- </head>
- <body>
- <?php
- $servername = "localhost";
- $username = "username";
- $password = "password";
- mysql_connect($servername, $username, $password) or die(mysql_error());
- mysql_select_db("stuff") or die(mysql_error());
- $result = mysql_query("SELECT Location, Latitude, Longitude FROM Places WHERE Latitude IS NOT NULL GROUP BY Location, Latitude, Longitude");
- $places = array();
- while (($row = mysql_fetch_array($result, MYSQL_NUM)) !== false) {
- $places[] = $row;
- }
- ?>
- <script>
- function makeTableHTML(myArray) {
- var result = "<table border=1>";
- for(var i=0; i<myArray.length; i++) {
- result += "<tr>";
- for(var j=0; j<myArray[i].length; j++){
- result += "<td>"+myArray[i][j]+"</td>";
- }
- result += "</tr>";
- }
- result += "</table>";
- return result;
- }
- var places = <?php echo json_encode($places) ?>;
- makeTableHTML(places);
- </script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement