Displaying markers on google map from mysql database using php/javascript

Question

In my database I have lat/lng values and I'm trying to display markers on a google map. (I have my map coming up ok but can't get the markers going!).

 // Selects all the rows in the tester table.
$query = 'SELECT * FROM tester WHERE 1';
$result = mysql_query($query);

if (!$result) 
{
die('Invalid query: ' . mysql_error());
}

    while ($row = mysql_fetch_assoc($result))
    {?>
       var marker = new google.maps.Marker({
    position: <?php $row['lat']?>, <?php $row['lng']?> ,
    map: map,
    title:"Hello World!"
});   

}

Any help would be great thanks!

gusjap · Accepted Answer · 2015-08-06 13:07:03Z

1

I think you need to use "echo":

position: <?php echo $row['lat']?>, <?php echo $row['lng']?> ,

answered Aug 6, 2015 at 13:07

gusjap

2,5455 gold badges26 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RiggsFolly · Accepted Answer · 2015-08-06 16:11:37Z

1

It gets quite complex when you start writing javascript out from PHP as its very easy to get lost in all the semi-colons.

Also I find it easier to do it all in PHP rather than keep jumping in and out of HTML-PHP-HTML-PHP etc

Try this

// Selects all the rows in the tester table.
$query = 'SELECT * FROM tester WHERE 1';
$result = mysql_query($query);

if (!$result) {
    die('Invalid query: ' . mysql_error());
}

echo '<script type="text/javascript">';

$i = 0;
while ($row = mysql_fetch_assoc($result))
    echo 'var myLatlng = new google.maps.LatLng(' . $row['lat'] ',' . $row['lng'] . ');';

    echo 'var marker' . $i . ' = new google.maps.Marker({';
    echo '  position: myLatLng ,';
    echo '  map: map,';
    echo '  title:"Hello World!"';
    echo '});';
    echo 'marker' . $i . 'setMap(map);';
    $i++;
}               


echo '<script>';

edited Aug 6, 2015 at 16:11

answered Aug 6, 2015 at 15:45

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

2 Comments

fst104 Over a year ago

Gave that a go and still no luck! when I remove the php from initialize() function the map loads ok, but with it added in the map does not appear at all!

RiggsFolly Over a year ago

What initialize() you did not post anything about initialize()

Collectives™ on Stack Overflow

Displaying markers on google map from mysql database using php/javascript

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related