adding multiples markers to google map from a mysql database
hello,
i am trying to add markers to my googlemaps map. the latitudes and longitudes are strored in table called appreciation in a mysql database. i followed sevrel tutoriels including this one :
the problem is that i only get the map without the markers. please help
and here is the code adapted to my database :
$dbcnx = mysql_connect ("$dbserver", "$dbuser", "$dbpass");
mysql_select_db("$dbname") or die(mysql_error());
?>
<?
$query = mysql_query("SELECT * FROM appreciation");
while ($row = mysql_fetch_array($query)){
$name=$row['idAppreciation'];
$lat=$row['latitude'];
$lon=$row['longitude'];
$desc=$row['zone'];
echo "addMarker($lat, $lon,'<b>$name</b><br/>$desc');";
}
?>
<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: 350px; height: 300px; 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/blue.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
}
});
center = bounds.getCenter();
map.fitBounds(bounds);
}
</script>
</head>
<body onload="initMap()" style="margin:0px; border:0px; padding:0px;">
<div id="map"></div>
</html>
View Answers
Related Tutorials/Questions & Answers:
Advertisements
retrieve data from mysql databaseretrieve data
from mysql database hi am not familiar in php.....even... selected value on combobox which is to be retrieve the relevant data
from mysql database using php.... below my code is that..
<html>
<head>
Data retrieve from mysql databaseData retrieve
from mysql database Hi sir,
please give some example of jsp code for retrieving
mysql database values in multiple dropdown list...
from the dropdown, related data will get displayed on the textboxes. Here we have
How to retrieve image from mysql database in JSP?How to retrieve image
from mysql database in JSP? Hi,
I need JSP same codes for learning to get image which is stored in
MySQL Database.
How to retrieve image
from mysql database in JSP?
Thanks
Hi,
You can write
How to access (MySQL)database from J2ME?How to access (
MySQL)
database from J2ME? I am new to J2ME. I am using NetBeans.
Can anyone help me?
How to access (
MySQL)
database from J2ME?
( I search a lot I found that there is need to access
database through servlet
google map with jsf - Java Server Faces Questionsgoogle map with jsf hi,
i am using jsf with googlemap.i load... values(latlong) to googlemap
from jsf bean values.i want to show mutiple
markers from database values.could u help me.
thanks,
Regards,
krishnaraj
MySql Databse query to fetch results from databaseMySql Databse query to fetch results
from database Hi. I have a field in
database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to retrieve these data
from Google Map Integration - AjaxGoogle Map Integration Hi All,
I am working on a vehicle tracking system project. I have to read data
from sql server
database and
map the vehicle position in
google map. I need to use ajax as the data is updated in every
image is display from path of mysql databaseimage is display
from path of
mysql database <%@ page import="java.io.,java.sql.,java.util.zip.*" %>
<%
String saveFile="";
String...;%
Connection connection = null;
String connectionURL = "jdbc:
mysql://localhost
retrieve related data from database using jsp and mysqlretrieve related data
from database using jsp and mysql Hi sir,
please give some example of jsp code for retrieving
mysql database values in multiple dropdown list. if we change a value in a dropdown its related value must
add google map javascriptadd
google map javascript How can i add
google map using javascript in my web page?
Search for the "
Google Maps Javascript API" it will allow you to embed the
Google Map into your web Page
Retrieve image from mysql database through jsp
Retrieve image
from mysql database through
jsp... to retrieve image
from
mysql database through jsp code. First create a
database...
Note : In the jsp code given below, image will
be retrieved
from database Video Tutorial: How to access MySQL database from JSP?How to access
MySQL database from JSP?
In this tutorial,I will teach you how to access data
from JSP page. We are using
MySQL database and we have a table... to access
MySQL database from JSP?":
So, we have pasted it here
Retrieve date from MYSQL databaseRetrieve date
from MYSQL database
In this tutorial, you will learn how to retrieve date
from database.
Storing and Retrieving dates
from the
database is a common task.
MYSQL
provides different ways of inserting and fetching dates
from MYSQL DatabaseMYSQL Database Can any one brief me about how to use
MYSQL Database to store the create new
database, create tables.
Thanks.
Hi, the
MySQL database server is most popular
database server and if you want to know
Map Java Objects with Database tablesMap Java Objects with
Database tables How to
map Java Objects with
Database tables?
First write Java domain objects ie. beans with setter and getter methods. Then
map java class to table and
database columns to Java
JavaScript google map API example.JavaScript
google map API example. How to Use
Google Maps API in JavaScript?
Google Maps- A
map is a way of representation of your route... routes, a road
map shows you road, street information.
In the same way
google map to make a google map point to user defined locationto make a
google map point to user defined location Hi,
i wish to develop an
google map,that takes the input
from a form(city,area &Country... button, the form should be submitted and then the
google map should display