php and java (google maps)

hyster · September 15, 2011

i have code that i found and modified slightly that pulls data from mysql and plots it on a google map.

this works fine as is.

what i want to do is change the pin colour depending on a value from mysql.

the java is outside of the while loop and i can not get it to work from inside the loop.

this line of code changes the pin colour

var icon = new google.maps.MarkerImage("http://maps.google.com/mapfiles/ms/micons/red.png",

im crap with javascript and sorry if this is better in java forum.

any help greatly appreciated

$dbcnx = mysql_connect ("$dbserver", "$dbuser", "$dbpass");
mysql_select_db("$dbname") or die(mysql_error());

?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
<title>Google Map API V3 with markers</title>
<style type="text/css">
body { font: normal 10pt Helvetica, Arial; }
#map { width: 700px; height: 600px; border: 0px; padding: 0px; }
</style>
<script src="http://maps.google.com/maps/api/js?v=3&sensor=false" type="text/javascript"></script>
<script type="text/javascript">
//Sample code written by August Li
var icon = new google.maps.MarkerImage("http://maps.google.com/mapfiles/ms/micons/red.png",
new google.maps.Size(32, 32), new google.maps.Point(0, 0),
new google.maps.Point(16, 32));
var center = null;
var map = null;
var currentPopup;
var bounds = new google.maps.LatLngBounds();
function addMarker(lat, lng, info) {
var pt = new google.maps.LatLng(lat, lng);
bounds.extend(pt);
var marker = new google.maps.Marker({
position: pt,
icon: icon,
map: map
});
var popup = new google.maps.InfoWindow({
content: info,
maxWidth: 300
});
google.maps.event.addListener(marker, "click", function() {
if (currentPopup != null) {
currentPopup.close();
currentPopup = null;
}
popup.open(map, marker);
currentPopup = popup;
});
google.maps.event.addListener(popup, "closeclick", function() {
map.panTo(center);
currentPopup = null;
});
}
function initMap() {
map = new google.maps.Map(document.getElementById("map"), {
center: new google.maps.LatLng(0, 0),
zoom: 14,
mapTypeId: google.maps.MapTypeId.ROADMAP,
mapTypeControl: false,
mapTypeControlOptions: {
style: google.maps.MapTypeControlStyle.HORIZONTAL_BAR
},
navigationControl: true,
navigationControlOptions: {
style: google.maps.NavigationControlStyle.SMALL
}
});
<?php

$query = mysql_query("SELECT * FROM poi_example");
while ($row = mysql_fetch_array($query)){
$name=$row['name'];
$lat=$row['lat'];
$lon=$row['lon'];
$desc=$row['desc'];
echo ("addMarker($lat, $lon,'<b>$name</b><br/>$name');\n");
}

?>
center = bounds.getCenter();
map.fitBounds(bounds);

}
</script>
</head>
<body onload="initMap()" style="margin:0px; border:0px; padding:0px;">
<div id="map"></div>
</html>

ManiacDan · September 15, 2011

First of all, Java and JavaScript are two entirely separate languages that are unrelated. They're not even the same language paradigm.

Now, as for your problem:

You have a function called addMarker()

Inside that function, you use the variable icon

The variable icon represents the already-colored icon for the pin.

What you need to do is:

- Remove the initial declaration of icon.

- In your while loop, when you call addMarker(), include the color (or the filename for the color) of the marker you wish to use when you call addMarker()

- Add the color as an argument to the addMarker() function

- Inside of addMarker(), create a new icon object every time with the color specified.

-Dan

Sign In

php and java (google maps)

Recommended Posts

hyster

Link to comment

Share on other sites

ManiacDan

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information