Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $username = "root";
- $password = "";
- $host = "localhost";
- $database="leafletdb";
- $server = mysqli_connect($host, $username, $password);
- $connection = mysqli_select_db($database, $server);
- $myquery = "
- SELECT `latitude`, `longitude` FROM `gpsdata`
- WHERE `lat` <> 0
- ";
- $query = mysqli_query($myquery);
- if ( ! $query ) {
- echo mysqli_error();
- die;
- }
- $data = array();
- echo "var points = [";
- for ($x = 0; $x < mysqi_num_rows($query); $x++) {
- $data[] = mysqli_fetch_assoc($query);
- echo "[",$data[$x]['lat'],",",$data[$x]['long'],"]";
- if ($x <= (mysqli_num_rows($query)-2) ) {
- echo ",";
- }
- }
- echo "];";
- mysql_close($server);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement