Explore our sites

Stack Exchange
tour help careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm trying to store results in an array from mysql using php, then using the results to call a javascript funtion to use the results there. I'm not sure why my map isn't showing up (trying to implement google maps into my page)

My php/html/javascript call

 <?php
.....
<div id="content"
           ......

$address=array();
//will list out where to go
while ($sec = mysql_fetch_array($result2)) {
        $address[$x++] = ($sec[5] . " " . $sec[7]);
}
print_r($latlng);
print_r($address);
mysql_close($link);
?>

<div id="address_container">
<?php
print array_shift($address);
?>
</div>
</div>

My Javascript code:

    <script type="text/javascript">
var geocoder;
  var map;
  function initialize() {
    geocoder = new google.maps.Geocoder();
    var latlng = new google.maps.LatLng(-34.397, 150.644);
    var myOptions = {
      zoom: 8,
      center: latlng,
      mapTypeId: google.maps.MapTypeId.ROADMAP
    }
    map = new google.maps.Map(document.getElementById("map_canvas"), myOp$
  }

function codeAddress() {
var address = document.getElementByID("address_container").innerHTML;
console.log(address);
    geocoder.geocode( { 'address': address}, function(results, status) {
      if (status == google.maps.GeocoderStatus.OK) {
        map.setCenter(results[0].geometry.location);
        var marker = new google.maps.Marker({
            map: map,
            position: results[0].geometry.location
        });
      } else {
        alert("Geocode was not successful for the following reason: " + s$
      }
    });
}
share|improve this question
 
What is the HTML element with ID address? What format are you trying to use to transfer the data from PHP to javascript? I think you need to use/are missing a call to json_encode()... As it is you are passing in a reference to the HTML element itself, which can't be right? Can it? Not big on Google maps but I can't believe that is what it is expecting... –  DaveRandom Sep 5 '11 at 10:57
 
Are you trying to show more than one address here? I can't quite figure out what's going on with that array... –  DaveRandom Sep 5 '11 at 11:06
 
I'm trying to input an array of addresses... example. Array ( [1] => 1251 Front Street Lahaina, HI 96761 [2] => 160 Keonekai Rd Hihei, HI 96753 ) . then input it into javascript to turn these addresses in for putting a marker on the map. but now my map isn't showing up either... –  pythono Sep 5 '11 at 22:00
add comment

3 Answers

up vote 1 down vote

See if this produces the result you are expecting:

PHP:

<?php

  // ......

  $address = array();
  while ($sec = mysql_fetch_array($result2)) $address[++$x]= "$sec[5] $sec[7]";

  // this should print the same data as you were getting before if you un-comment it
  // print_r($address);
  mysql_close($link);

?>
<div id="address_container"><?php print array_shift($address); ?></div>
</div> <!-- I left this here because I don't know what the rest of your HTML looks like... -->
<script type="text/javascript">
document.write(codeAddress());
</script>

Javascript:

function codeAddress() {
  var address = document.getElementByID("address_container").innerHTML;
  geocoder.geocode( { 'address': address}, function(results, status) {
    if (status == google.maps.GeocoderStatus.OK) {
      map.setCenter(results[0].geometry.location);
      var marker = new google.maps.Marker({
        map: map,
        position: results[0].geometry.location
      });
    } else {
      alert("Geocode was not successful for the following reason: " + status);
    }
  });
}
share|improve this answer
 
I tried this and my map still isn't showing up –  pythono Sep 5 '11 at 22:02
 
err it as my fault that my map wasn't showing up. (doh!!). but with the function codeAddress() it's still not putting the marker on the map. therefore making me believe that the function isn't being called??? –  pythono Sep 6 '11 at 5:38
 
@pythono Can you update the question with your current code? –  DaveRandom Sep 6 '11 at 6:49
 
@ DaveRandom updated. –  pythono Sep 8 '11 at 23:36
 
@pythono Are you getting any output from the console.log(address); line? And also, do you get anything if you add the line alert('Callback function called'); as the first line of the callback (before the if (status == google.maps.GeocoderStatus.OK) { line)? –  DaveRandom Sep 9 '11 at 10:52
show 2 more comments
up vote 0 down vote

don't print_r $address, but echo it into a js var

</div>
<script type="text/javascript">
var address = <?php echo json_encode($address); ?> ;
document.write(codeAddress());
</script>

then no need to select it in your function

share|improve this answer
 
While this was my immediate thought, after a bit of reading on the subject it seems that the function expects a string with a human readable address. It looks to me like the OP's code has been lifted from here. –  DaveRandom Sep 5 '11 at 11:30
 
indeed! I +1ed your answer. –  roselan Sep 5 '11 at 11:35
 
Am I suppose to see anything on my website when I insert the "echo json_encode($address);" statement? Or What does that do? Sorry for my nuisance, I'm new to javascript. –  pythono Sep 5 '11 at 18:24
 
it's doesn't show anything on the page, as the data is put inside a JS variable. You can see what's in with console.log(address); in the script session, and displaying the console (chrome) or firebug (firefox) –  roselan Sep 5 '11 at 18:33
 
is my javascript code correct? just use "var address = document.getElementByID("address"); " –  pythono Sep 5 '11 at 22:01
add comment
up vote 0 down vote

This was what example I was going off from... from the google api

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

  function codeAddress() {
    var address = document.getElementById("address").value;
    geocoder.geocode( { 'address': address}, function(results, status) {
      if (status == google.maps.GeocoderStatus.OK) {
        map.setCenter(results[0].geometry.location);
        var marker = new google.maps.Marker({
            map: map,
            position: results[0].geometry.location
        });
      } else {
        alert("Geocode was not successful for the following reason: " + status);
      }
    });
  }

<body onload="initialize()">
 <div id="map_canvas" style="width: 320px; height: 480px;"></div>
  <div>
    <input id="address" type="textbox" value="Sydney, NSW">
    <input type="button" value="Encode" onclick="codeAddress()">
  </div>
</body>

ref: http://code.google.com/apis/maps/documentation/javascript/services.html#GeocodingAddressTypes

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.