Page 1 of 1

Default username/password? Google Maps query

PostPosted: 02. December 2007 18:44
by jakc
Hi, first post, im completly new to php/apache/mysql so talk to me like im an idiot.
Im trying to get a google map sample running and connect to a mysql database to get the data to plot points.

Have got xampp running, created a database called gmap1
Created a table called wholocations
Populated this table with a dozen records (with lat/lon spatial information)
Got a google maps key.
Created a map, and trying to read from the database and populate the map with points.
Im not getting a "Could not connect" error but im not getting any points.
The map appears fine.
Using firefox and have got the code from this tutorial.

Cant see what im doing wrong. Perhaps I have my username details wrong, but from what I saw on php.net, I think im right. Can anyone spot where im going wrong?

Code: Select all
<html>
<head>
<title>Local Issues Example</title>
<script src="http://maps.google.com/maps?file=api&v=2&key=ABQIAAAABbQOcrHd1l2eJ82xX5iKoxT2yXp_ZAY8_ufC3CFXhHIE1NvwkxQYD0HysvPaUlb89IVQ-GMGKz0rYQ" type="text/javascript"></script>
</head>
<body>
<p><strong>Local Issues Example</strong></p>
<div id="map" style="width: 800px; height: 600px"></div>

<script type="text/javascript">
//<![CDATA[

var map = new GMap2(document.getElementById("map"));
map.addControl(new GLargeMapControl());
map.addControl(new GMapTypeControl());
map.addControl(new GScaleControl());
map.setCenter(new GLatLng(51.106971, -3.15307617), 8, G_NORMAL_MAP);

// Creates a marker whose info window displays the given number
function createMarker(point, number)
{
var marker = new GMarker(point);
// Show this markers index in the info window when it is clicked
var html = number;
GEvent.addListener(marker, "click", function() {marker.openInfoWindowHtml(html);});
return marker;
};

<?php
$link = mysql_connect("localhost", "root", "") or die("Could not connect: " . mysql_error());
mysql_selectdb("gmap1",$link) or die ("Can\'t use dbmapserver : " . mysql_error());

$result = mysql_query("SELECT * FROM wholocations",$link);
if (!$result)
{
echo "no results ";
}
while($row = mysql_fetch_array($result))
{
echo "var point = new GLatLng(" . $row['lat'] . "," . $row['lon'] . ");\n";
echo "var marker = createMarker(point, '" . addslashes($row['description']) . "');\n";
echo "map.addOverlay(marker);\n";
echo "\n";
}

mysql_close($link);
?>

//]]>
</script>

</body>
</html>
:)

PostPosted: 02. December 2007 19:14
by Izzy
Did you name the script with a .php file extension?

Did you put the script in the htdocs directory?

Did You load the script through a your browser?
http://localhost/yourmap.php


===========================================
1. The new DeskTopXampp Launch Control for XAMPP / XAMPPlite
Posted by Ridgewood available from Ridgewood'sDTX web site

2. Build Rich AJAX Applications - Faster
TIBCO General Interface Pro Edition but FREE and Open Source
Fully working with NO donations required to get a user/password
===========================================

PostPosted: 02. December 2007 19:18
by jakc
no on all 3 accounts.
Will try again now.

PostPosted: 02. December 2007 19:25
by jakc
hmm, still not showing me any points, or giving me any error message.

That would suggest to me that the php is not being run at all? Im lost. any more pointers?