PHP - Geocode Multiple Addresses From Database Without Lat And Long Coordinates In Google Maps

Hi there,

I am building a custom configuration program, where i want people to choose various items, e.g. 1. Size of a table, colour, how many drawers, other features. I want to store all my options in mysql tables. At the end of the process I want to somehow get mysql to get line co-ordinates from a table and dynamically draw a plan view and elevation view of the table showing the options that the customer has chosen. I was wondering if anyone has ever been able to do this. I'm not sure how to start, or if php is capable of doing this.

any ideas would be great.

Code: [Select]
<?php
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$dropdown = $_POST['dropdown'];
$formcontent=" From: $firstname \n Surname: $lastname \n Email: $email \n Dropdown: $dropdown";
$recipient = "martin@sittingspiritually.co.uk, siobhan@sittingspiritually.co.uk";
$subject = "Newsletter Sign Up";
$mailheader = "From: $email \r\n";
mail($recipient, $subject, $formcontent, $mailheader) or die("Error!");
if ( mail($recipient, $subject, $formcontent, $mailheader) ){
header('Location: http://www.sittingspiritually.co.uk/thankyou.php');
} else {
die ("error");
}
?>

I have recently created a small snippet of php code for posting mail and it's sweet apart from 1 thing.

I have two email addresses in the recipient section. It only sends to the last name in the list.

Is this because i have written recipient? Should it be recipients?

I need this mail to be delivered to both of the email addresses.

I'm sure it's simple for someone with expert knowledge.

Thanks in advance for any help.

Hello Guys,

I need some help here.. I am trying to extract the lat and long from a json query from google.

Here is what I receive back from json

{
  "name": "795PollardBlvdSW,Atlanta,GA",
  "Status": {
    "code": 200,
    "request": "geocode"
  },
  "Placemark": [ {
    "id": "p1",
    "address": "Atlanta, GA, USA",
    "AddressDetails": {
   "Accuracy" : 4,
   "Country" : {
      "AdministrativeArea" : {
         "AdministrativeAreaName" : "GA",
         "SubAdministrativeArea" : {
            "Locality" : {
               "LocalityName" : "Atlanta"
            },
            "SubAdministrativeAreaName" : "Fulton"
         }
      },
      "CountryName" : "USA",
      "CountryNameCode" : "US"
   }
},
    "ExtendedData": {
      "LatLonBox": {
        "north": 33.8231844,
        "south": 33.6747422,
        "east": -84.2599230,
        "west": -84.5160418
      }
    },
    "Point": {
      "coordinates": [ -84.3879824, 33.7489954, 0 ]
    }
  } ]
}


Here is the code I am using


$geocode=file_get_contents('http://maps.google.com/maps/geo?output=json&q=795PollardBlvdSW,Atlanta,GA');

$output= json_decode($geocode);

$lat = $output->results[0]->geometry->location->lat;
$long = $output->results[0]->geometry->location->lng;

echo $lat;
echo $long;


Just not sure how to pull the lat and long out of a json into vars..

Please advise..
Dan

I have no idea what im doing wrong but this just isnt working, theres no error messages but im not getting any of the emails. Here is all the code that i had anything to do with editing, i have removed any personal info from it.

Code: [Select]
<?php
$dbhost = 'localhost';
$dbuser = ' ';
$dbpass = ' ';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

mysql_select_db(" ", $conn);

$result = mysql_query("SELECT ****, ********** FROM **** WHERE name='*****'");

while($row = mysql_fetch_array($result))
{
$message =
"<p><u><b><font size=\"5\" color=\"#800080\">********************</font></b></u></p>
<p><b><font color=\"#800080\" size=\"4\">**************************************************</font></b></p>
<p><b><font color=\"#800080\">*********</font></b> <b><font color=\"#333333\">**********</font></b></p>
<p><b><font color=\"#800080\">********</font></b> <font color=\"#333333\"><b>***********</b></font></p>
<p><font color=\"#800080\"><b>*******</b></font> <font color=\"#333333\"><a href=\"***********************************************</a></font></p>
<p>&nbsp;</p>";
}

$query=mysql_query('SELECT `email`,`name` FROM `users`'); //grab emails and names from database
while($row = mysql_fetch_array($query)) //start a loop to send an email to each individual
{
    //mail function with $row['email'] as the email address
    //I'm using phpmailer as an example here - - >
    include_once('phpMailer/class.phpmailer.php');
    
    $mail             = new PHPMailer(); // defaults to using php "mail()"
    
    $body             = $message; //message inside the email
    
    $mail->From       = "**************"; //email address that the email is being sent from
    $mail->FromName   = "*************"; //more in depth for who the mail is from.
    
    $mail->Subject    = "***********************************"; //The subject for the message
    
    //$mail->AltBody    = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test
    
    
    $mail->AddAddress($row[email], $row['name']);
} 

mysql_close($conn);
?>

Hi, I got this script which I would like to send a message to all email addresses in the database or send to approved members only. Once I got the first part of this script working I can get the rest to work when sending to approved members.

Here is the form which passes the message to the script.

Code: [Select]
<?php 

include_once("data/server.php");

$all = 'unchecked';
$approved = 'unchecked';


if (isset($_POST['Submit1'])) {

$selected_radio = $_POST['Mailto'];

if ($selected_radio == 'all') {
$all = 'checked';

}
else if ($selected_radio == 'approved') {
$approved = 'checked';
}
}

?>

<div id="pageNav">
    <div id="sectionLinks"> <a href="admin.php?cmd=database&username=admin">Database</a> <a href="admin.php?cmd=uploads&username=admin">Uploads</a> <a href="admin.php?cmd=editTemplate&username=admin">Templates </a> <a href="admin.php?cmd=email&username=admin">Email</a> <a href="admin.php?cmd=messaging&username=admin">Messaging</a> <a href="admin.php?cmd=protected&username=admin">Protected Directory</a> <a href="admin.php?cmd=filesanddir&username=admin">Files and Directories</a> <a href="admin.php?cmd=usertracking&username=admin">User Tracking</a> <a href="admin.php?cmd=advanced&username=admin">Advanced</a> <a href="admin.php?cmd=uploads&username=admin">Uploads</a> <a href="admin.php?cmd=subscriptions&username=admin">Subscriptions</a> <a href="admin.php?cmd=applications&username=admin">Applications</a> <a href="admin.php?cmd=searchForms&username=admin">Search Form Builder</a> <a href="admin.php?cmd=categories&username=admin">Categories</a> <a href="admin.php?cmd=phpBB&username=admin">phpBB</a> <a href="admin.php?cmd=mySQL&username=admin">MySQL</a></div>
  </div>
  <div id="content">
   
    <div class="page">


<form action=templates/admin/msgtest.php method=POST>
<table>
<tr>
<td>Your Message:</td>
<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
<tr><td><TEXTAREA NAME="message" COLS=40 ROWS=6></TEXTAREA></td></tr>
</table>
<table>
<tr>
<td><input type = 'Radio' Name ='Mailto' value= 'yes'
<?PHP print $all; ?>
</td>
<td>Send Message to all members</td>
</tr>
<tr>
<td><input type = 'Radio' Name ='Mailto' value= 'yes'
<?PHP print $approved; ?>
</td>
<td>Send Message to Approved members only</td>
</tr>
<tr><td colspan=2><input type=submit name=submit value=Submit></td></tr>
</table>
</form>



</table>
    </div>
   
  </div> 
</div>



And here is the code I have got so far but it doesnt work

Code: [Select]
<?php

include_once("../../data/server.php");
include("../../data/mysql.php");

if (isset($_POST['Submit1'])) {

$selected_radio = $_POST['Mailto'];

if ($selected_radio == 'all') {

$mysqlPassword = (base64_decode($mysqlpword));

$con = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die(mysql_error());
mysql_select_db("$dbname", $con) or die(mysql_error());

 $q2 = "select * from games_newsletter ";
$result = mysql_query("SELECT email FROM profiles");   
 
while ($email = mysql_fetch_assoc($result)) {

$to = $email;
$subject = "Test Message";
$body = "This is a test message";
 $headers = "From: payments@tropicsbay.co.uk\r\n" .
     "X-Mailer: php";
 if (mail($to, $subject, $body, $headers)) {
   
// Redirect back to manage page
header("Location: admin.php?cmd=messaging");


} else {

echo "Approval Message Failed";

}
}
mysql_close($con);
}
}

?>
As always, any help is much appreciated

Paul

I'm having trouble loading this kind of KML with PHP
http://code.google.com/apis/maps/documentation/mapsdata/developers_guide_protocol.html#RetrievingFeatures
example
<atom:entry xmlns='http://www.opengis.net/kml/2.2'
    xmlns:atom='http://www.w3.org/2005/Atom'
    xmlns:batch='http://schemas.google.com/gdata/batch'
    xmlns:gd='http://schemas.google.com/g/2005'>
  <atom:id>
  http://maps.google.com/maps/feeds/features/userID/mapID/full/featureID</atom:id>
  <atom:published>2008-08-14T17:46:06.462Z</atom:published>
  <atom:updated>2008-08-14T18:12:31.589Z</atom:updated>
  <atom:category scheme='http://schemas.google.com/g/2005#kind' 
.....

it seems like the column in atom:entry, etc is causing this.

$response = simplexml_load_string($response);
print_r($response);

the above just gives an empty SimpleXMLElement Object()

Any ideas

Hi guys

Mods please move if this is the wrong place to ask.

I have a google maps api added to my web site but i want to be able to position "pins" on the map to show all the the registered clubs in an area... eg the user searches dublin and all teh clubs pop up...

My question is.. is there anyway to do this without needing the user to supply the long/lat.. ie can it be gotten automatically??

I really just want it to work off the addrees/area they supplied when they registered.


thanks

tt

I am attempting to create a Map on my web page that will have the directions (which will be dynamically pulled from a database) however I have been unable to find a good tutorial on how to achieve this, also there doesn't seem to be any PHP classes available out there (for free anyway) to create this easily.

Any suggestions?

Hi All,

I have code to generate a route in google maps on my site.
The code works great in Firefox but not in IE8.
It works in IE8 if you just have just a  start and finish only but whe you add a waypoint in the route does not show.
Any ideas?

Code: [Select]
<script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=true">
</script>
<script type="text/javascript">





var directionDisplay;
var geocoder;
var directionsService = new google.maps.DirectionsService();
var latlng = new google.maps.LatLng(54.559322587438636, -4.1748046875);


   function load() {
       geocoder = new google.maps.Geocoder();
       directionsDisplay = new google.maps.DirectionsRenderer();
      var myOptions = {
  zoom: 6,
  mapTypeId: google.maps.MapTypeId.ROADMAP,
center: latlng,
  mapTypeControl: true,
  mapTypeControlOptions: {
  style: google.maps.MapTypeControlStyle.HORIZONTAL_BAR,
  position: google.maps.ControlPosition.TOP_RIGHT
  },  
   
navigationControl: true,
navigationControlOptions: {
style: google.maps.NavigationControlStyle.ZOOM_PAN,
position: google.maps.ControlPosition.TOP_LEFT}
  };
    var map = new google.maps.Map(document.getElementById('map'), myOptions);
directionsDisplay.setMap(map);

var directionRendererOptions ={
suppressMarkers: true,
polylineOptions:{
strokeColor: "#FF0000",
strokeOpacity: 1,
strokeWeight: 3
}
};

directionsDisplay.setOptions(directionRendererOptions);


var start = '<?php echo $start; ?>';
var end = '<?php echo $end; ?>';
<?php
if($via != null){
echo "var points = [";
        foreach($via as $point){
        if($point != ""){
echo "{location:";
        echo " '".$point."'";
echo "},";
}
}
echo "];\n";
}
?>

var request = {
origin:start,
waypoints: points,
destination:end,
travelMode: google.maps.DirectionsTravelMode.DRIVING
};
directionsService.route(request, function(response, status) {
if (status == google.maps.DirectionsStatus.OK) {
directionsDisplay.setDirections(response);

}

});

geocoder.geocode( { 'address': start}, function(results, status) {
             var routeStart = new google.maps.Marker({
            map: map,
            position: results[0].geometry.location,
icon: './images/motorcycling.png',
shadow: './images/motorcycling.shadow.png'
        });
     
    });
geocoder.geocode( { 'address': end}, function(results, status) {
             var routeEnd = new google.maps.Marker({
            map: map,
            position: results[0].geometry.location,
icon: './images/motorcyclingend.png',
shadow: './images/motorcycling.shadow.png'
        });
     
    });
<?php
$adverts = mysql_query("SELECT * FROM adverts WHERE ad_area = '$county' AND ad_visible='1' ");
while($ad_row = mysql_fetch_array($adverts)){
$position = $ad_row[ad_postcode];
                
                $type = $ad_row[ad_type];
echo "var position".$ad_row[ad_id]." = '".$position."'\n";
                $ad_id = $ad_row[ad_id];
$pics = mysql_query("SELECT * FROM photos WHERE ad_id = '$ad_id' AND main_pic = '1'");
                $pic_row = mysql_fetch_array($pics);
                $pic_name = $pic_row[photo_name];
                $pic_name = str_replace(' ', '%20', $pic_name);
?>

geocoder.geocode( { 'address': position<?php echo $ad_row[ad_id]; ?>}, function(results, status) {

var marker<?php echo $ad_row[ad_id]; ?> = new google.maps.Marker({
map: map,
position: results[0].geometry.location,
<?php
if ($type == 'accommodation'){
echo "icon: 'images/hotel.png'\n";
}elseif($type == 'fooddrink'){
echo "icon: 'images/bar.png'\n";
}elseif($type == 'essentials'){
echo "icon: 'images/motorcycle.png'\n";
}
?>
});


var content = "<p><\a style='color:black;' href='./advert.php?advert=<?php echo $ad_row[ad_id]; ?>'><?php echo $ad_row[ad_company]; ?><\/a></p><img src='./thumbs/<?php echo $pic_name; ?>' />";
var infowindow<?php echo $ad_row[ad_id]; ?> = new google.maps.InfoWindow({
    content: content
});
google.maps.event.addListener(marker<?php echo $ad_row[ad_id]; ?>, "click", function() {
  infowindow<?php echo $ad_row[ad_id]; ?>.open(map,marker<?php echo $ad_row[ad_id]; ?>);
  });
 
});

Hello!
I am trying to find a way to assign the JSON value Google Map's API Returns when passed an address.  I would search Google, but I am only a few month deep into PHP and really don't know what keywords to use.  I really don't even know what a JSON is? 
Anyway, I found this article that explains how to query Google Maps with an address and have it return a GPS Location.  When I tested it in my browser, the text appears.  I just don't know what to use to take what the browser is displaying and assign in to an Object in a PHP page.
This is the Google Maps Query:
Code: [Select]
http://maps.google.com/maps/geo?q="ADDRESS"&output=csv&oe=utf8
This my function where I want to use this:
Code: [Select]
//Querries Google Map's API with an address and assigns the returned GPS Location
//to this Object
public function build_me($this_address)
{
//Builds the query from the address array to send to the Goole Maps API
$query = $this_address["Line1"].",".$this_address["Line2"].",".
$this_address["City"].",".$this_address["State"].",".$this_address["Zip"];

//Location_Array = http://maps.google.com/maps/geo?q=$query&output=csv&oe=utf8
$this->latitude  = //Location_Array['Something'];
$this->longitude = //Location_Array['Something'];
}
This is the article that I am referring to:
http://martinsikora.com/how-to-get-gps-coordinates-from-an-address

My question is, how would I go about doing this?  Are there any good tutorials on this?
Thanks in advance for anyone pointing me in the right direction!

Hi all

I am trying to get the lat and long properties from the googlemaps geocoding api.

$xml=simplexml_load_file($url);
if ($xml === false) {
    echo "Failed loading XML\n";
    foreach(libxml_get_errors() as $error) {
        echo "\t", $error->message;
    }
}
else{
           $path = $xml->xpath( "/GeocodeResponse/result/geometry/location");
            $lat = $path->lat;
            $lng = $path->lng;
            echo $lat;
            echo $lng;
           $sql1 = "UPDATE tbl_clubs set lat='$lat',lng='$lng' where club_id =$id";
           echo $sql1;
           $result1 = mysqli_query($dbConn,$sql1) or die($mysqli_error($dbConn));
}

This is the XML  I am using

<GeocodeResponse>
<status>OK</status>
<result>
<type>establishment</type>
<type>point_of_interest</type>
<type>stadium</type>
<formatted_address>Aldridge Rd, Perry Barr, Birmingham B42 2ET, UK</formatted_address>
<address_component>
</address_component>
<address_component>
</address_component>
<address_component>
</address_component>
<address_component>
<long_name>West Midlands</long_name>
<short_name>West Midlands</short_name>
<type>administrative_area_level_2</type>
<type>political</type>
</address_component>
<address_component>
<long_name>England</long_name>
<short_name>England</short_name>
<type>administrative_area_level_1</type>
<type>political</type>
</address_component>
<address_component>
<long_name>United Kingdom</long_name>
<short_name>GB</short_name>
<type>country</type>
<type>political</type>
</address_component>
<address_component>
<long_name>B42 2ET</long_name>
<short_name>B42 2ET</short_name>
<type>postal_code</type>
</address_component>
<geometry>
<location>
<lat>52.5196698</lat>
<lng>-1.8986236</lng>
</location>
<location_type>GEOMETRIC_CENTER</location_type>
<viewport>
<southwest>
<lat>52.5183208</lat>
<lng>-1.8999726</lng>
</southwest>
<northeast>
<lat>52.5210188</lat>
<lng>-1.8972746</lng>
</northeast>
</viewport>
</geometry>

 

But I am getting the following response

Notice: Trying to get property of non-object in /home/sites/1a/9/95f15f28a6/public_html/results/getLatLng.php on line 22

I am guessing my path is wrong, any guidance would be great

Need help with this, has anyone does this before?
Here is the tutorial I have been following: https://developers.google.com/maps/articles/phpsqlajax#outputxml

The part I am on from the tutorial is where it says Checking that XML output works it is meant to display the data from the database but i just get a blank page, no data is shown from my database on the page? I just have a php file with the code from the tutorial.

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

Code: [Select]
$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>

Hi there, 

So the below code is working for 1 entry, however there is 2 entries in the database which are different postcodes and I cannot get to show in Google Maps. When I do it without Mysql and just do it direct it works, but really want to do it from MYSQL - both postcodes are valid and tested as well.

 

<?php
$sql4 = "SELECT * FROM MK_migration_details";
$result4 = $conn->query($sql4);
?>


function initialize() {
        geocoder = new google.maps.Geocoder();
        var latlng = new google.maps.LatLng(40.768505,-111.853244);
        var myOptions = {
			mapTypeControl: false,
			fullscreenControlOptions: false,
			zoom: 8,
            center: latlng,
            mapTypeId: google.maps.MapTypeId.ROADMAP
			        }
        
		map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);
   <?php     
		while($row4 = $result4->fetch_assoc()) {
  
			$mig_postcode = $row4["postcode"];	
				
		}		
				echo 'addPostCode("'.$mig_postcode.'")';
				
?>
   
	}
	

I know the issue lies with the PHP / Mysql Loop and the Javascript element 'addpostcode' when I put into the loop does not work, but works for a single address outside the loop.

 

Really appreciate your help guys!

 

Thanks you

Hi,

I currently have a google map which shows a marker where the postcode is for a certain pub (converts postcodes to coords lat/long)
I would like to loop through all my pubs in my database as place a marker for each on one map, I am uncertain of how to loop through and show each marker for each postcode either PHP or JavaScript.

here is my code for a single pub / postcode:

Code: [Select]
<!doctype html>
<?php 
 include "../config.php";
$loggedIn = (isset($_COOKIE['loggedin']) && $_COOKIE['loggedin'] == 'true')?true:false;

$PUBID = intval($_REQUEST['PUBID']);
$PUB = mysql_query("SELECT * FROM pubs WHERE PUBID = '".$PUBID."'");
$pubdetails = mysql_fetch_array($PUB);
?>
<html>
    <head>
        <meta charset="UTF-8" />
        <title><?php echo $pubdetails['rsPubName']; ?>, <?php echo $pubdetails['rsTown']; ?>, <?php echo $pubdetails['rsCounty']; ?></title>
        <style type="text/css" media="screen">@import "jqtouch/jqtouch.min.css";</style>
        <style type="text/css" media="screen">@import "themes/jqt/theme.min.css";</style>
        <script src="jqtouch/jquery.1.3.2.min.js" type="text/javascript" charset="utf-8"></script>
        <script src="jqtouch/jqtouch.min.js" type="application/x-javascript" charset="utf-8"></script>
        <script src="http://maps.google.com/maps?file=api&amp;v=2&amp;sensor=true&amp;key=ABQIAAAAM17e4xGXwO4sBd_QYtRiSRQXB4T7UHWaz4zUQgLx9muJZW0c3hS8jRMJg733CHqOihn7BVfhZTkLiA" type="text/javascript"></script>
<script type="text/javascript">

    function initialize() {
    var latlng = new google.maps.LatLng(-34.397, 150.644);
    var myOptions = {
      zoom: 8,
      center: latlng,
      mapTypeId: google.maps.MapTypeId.G_NORMAL_MAP
    };
    var map = new google.maps.Map(document.getElementById("map_canvas"),
        myOptions);
  }


    </script>

        <script type="text/javascript" charset="utf-8">
            var jQT = new $.jQTouch({
                icon: 'jqtouch.png',
                addGlossToIcon: false,
                startupScreen: 'jqt_startup.png',
                statusBar: 'black',
                preloadImages: [
                    'themes/jqt/img/back_button.png',
                    'themes/jqt/img/back_button_clicked.png',
                    'themes/jqt/img/button_clicked.png',
                    'themes/jqt/img/grayButton.png',
                    'themes/jqt/img/whiteButton.png',
                    'themes/jqt/img/loading.gif'
                    ]
            });
        </script>
    </head>
    <body onLoad="ukPostcodeTest(); return false">
<!-- TOWNS -->
<div id="pub" class="current">
            <div class="toolbar">
                <h1>View Pub</h1>
                <a class="back" href="index.php" rel="external">Home</a>
            </div>
<h2><?php echo $pubdetails['rsPubName']; ?></h2>
            <?php echo $pubdetails['rsAddress']; ?><br />
<?php echo $pubdetails['rsTown']; ?><br />
<?php echo $pubdetails['rsCounty']; ?><br />
<?php echo $pubdetails['rsPostCode']; ?><br />
<?php echo $pubdetails['Region']; ?><br />
<?php echo $pubdetails['rsTel']; ?><br />
<?php echo '<iframe src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fwww.mypubspace.com/pub_info.php?PUBID='.$pubdetails['PUBID'].'&amp;layout=box_count&amp;show_faces=true&amp;width=450&amp;action=like&amp;colorscheme=light&amp;height=65" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:60px; height:65px; float:right;" allowTransparency="true"></iframe>';?>


    <div id="map" style="width: 250px; height: 250px"></div>
 
    <form name="mapform" onsubmit="ukPostcodeTest(); return false" action="#">
<input id="search" type="hidden" value="<?php echo $pubdetails["rsPostCode"]; ?>" />
    </form>
   
    <div id="message"></div>

    <noscript><b>JavaScript must be enabled in order for you to use Google Maps.</b>
      However, it seems JavaScript is either disabled or not supported by your browser.
      To view Google Maps, enable JavaScript by changing your browser options, and then
      try again.
    </noscript>

    <script type="text/javascript">
    //<![CDATA[
   
    if (GBrowserIsCompatible()) {

      var map = new GMap(document.getElementById("map"));
     
map.addControl(new GLargeMapControl());
      map.addControl(new GMapTypeControl());
      map.setCenter(new GLatLng(51.520593197675446,-0.19775390625),16);
     
      // ====== Is the search string a UK Postcode ======
      function ukPostcodeTest() {
        var search = document.getElementById("search").value;
        // take a copy and convert to upper case
        var s = search.toUpperCase();
        // Replace punctuation and whitepsace by a single space
        s = s.replace(/\W+/g, " ");
        // Remove and trailing leading spaces
        s = s.replace(/^ /, "");
        s = s.replace(/ $/, "");
        // Perform the check
        var match = s.match(/^[A-Z]{1,2}[0-9R][0-9A-Z]? [0-9][ABD-HJLNP-UW-Z]{2}$/);
        if (!match) {
          // Its not a UK Postcode, so perform a standard GClientGeocoder call on the original search string
          showAddress(search);
        } else {
          // It is a UK Postcode, so call GDirections on the reformatted search string
          showPostcode(s);
        }
      }


     
     
      // ====== Code for handling search strings that are not UK Postcodes =======
      // ====== Use the GClientGeocoder in the normal way ======
     
      // ====== Create a Client Geocoder ======
      var geo = new GClientGeocoder();

      // ====== Array for decoding the failure codes ======
      var reasons=[];
      reasons[G_GEO_SUCCESS]            = "Success";
      reasons[G_GEO_MISSING_ADDRESS]    = "Missing Address: The address was either missing or had no value.";
      reasons[G_GEO_UNKNOWN_ADDRESS]    = "Unknown Address:  No corresponding geographic location could be found for the specified address.";
      reasons[G_GEO_UNAVAILABLE_ADDRESS]= "Unavailable Address:  The geocode for the given address cannot be returned due to legal or contractual reasons.";
      reasons[G_GEO_BAD_KEY]            = "Bad Key: The API key is either invalid or does not match the domain for which it was given";
      reasons[G_GEO_TOO_MANY_QUERIES]   = "Too Many Queries: The daily geocoding quota for this site has been exceeded.";
      reasons[G_GEO_SERVER_ERROR]       = "Server error: The geocoding request could not be successfully processed.";
     
      // ====== Geocoding ======
      function showAddress(search) {
        // ====== Perform the Geocoding ======       
        geo.getLocations(search, function (result)
          {
            // If that was successful
            if (result.Status.code == G_GEO_SUCCESS) {
              // How many resuts were found
              document.getElementById("message").innerHTML = "Found " +result.Placemark.length +" results";
              // Loop through the results, placing markers
              for (var i=0; i<result.Placemark.length; i++) {
                var p = result.Placemark[i].Point.coordinates;
                var marker = new GMarker(new GLatLng(p[1],p[0]));
                document.getElementById("message").innerHTML += "<br>"+(i+1)+": "+ result.Placemark[i].address + marker.getPoint();
                map.addOverlay(marker);
              }
              // centre the map on the first result
              var p = result.Placemark[0].Point.coordinates;
              map.setCenter(new GLatLng(p[1],p[0]),14);
            }
            // ====== Decode the error status ======
            else {
              var reason="Code "+result.Status.code;
              if (reasons[result.Status.code]) {
                reason = reasons[result.Status.code]
              }
              alert('Could not find "'+search+ '" ' + reason);
            }
          }
        );
      }




      // ====== Create a Client Geocoder ======
      var gdir = new GDirections(null);
     
      // ====== Using GDirections to process a UK postcode ======
      function showPostcode(search) {
        // Call GDirections
        gdir.loadFromWaypoints([search,search],{getPolyline:true});
        // Wait for the reply to come back
        GEvent.addListener(gdir,"load", function() {
          var poly = gdir.getPolyline();
          var point = poly.getVertex(0);
          //document.getElementById("message").innerHTML = "Found a UK Postcode";
          // Process the result
          var marker = new GMarker(point);
          //document.getElementById("message").innerHTML += "<br>" + search + " = " + point.toUrlValue(5);
          map.addOverlay(marker);         
          // centre the map on the result
          map.setCenter(point,16);
        });
      }
    }


   
    // display a warning if the browser was not compatible
    else {
      alert("Sorry, the Google Maps API is not compatible with this browser");
    }

    // This Javascript is based on code provided by the
    // Community Church Javascript Team
    // http://www.bisphamchurch.org.uk/   
    // http://econym.org.uk/gmap/

    //]]>
    </script>


        </div>
    </body>
</html>