Yup sure did, i have everything right just had to add phone to one more spot in the XML. Thanks for the help.
On Tue, Aug 10, 2010 at 5:24 PM, [email protected] <[email protected]>wrote: > On Aug 10, 1:28 pm, "[email protected]" <[email protected]> > wrote: > > On Aug 10, 12:00 pm, Jacob Roman <[email protected]> wrote: > > > > > I did search for some help on this but nothing is really helping me. I > > > have changed the database, the xml script, and the map code. I do not > > > know what else to change to make it show up. Visit this link to see > > > the map > > > > http://frykrisp.co/distributors/phpsqlsearch_map.html > > > > I get a key error on that map. > > > > Your xml seems fine: > http://frykrisp.co/distributors/phpsqlsearch_genxml.php?lat=36.778261... > > > > But there are no phone numbers in it... > > phone="" (for all the entries) > > > > So the problem is in your xml generation or your database. > > You seem to have fixed it (and the key error) now. > > -- Larry > > > > > > > > > > > > If you put the address CA and set the radius to 200 some markers will > > > show up. > > > > > My HTML code you can see by viewing the source through the browser > > > > > The only other thing i can think of is i did not do MySQL the right > > > way. > > > > > Below is my php code: > > > > > <?php > > > require("phpsqlsearch_dbinfo.php"); > > > > > // Get parameters from URL > > > $center_lat = $_GET["lat"]; > > > $center_lng = $_GET["lng"]; > > > $radius = $_GET["radius"]; > > > > > // Start XML file, create parent node > > > $dom = new DOMDocument("1.0"); > > > $node = $dom->createElement("markers"); > > > $parnode = $dom->appendChild($node); > > > > > // Opens a connection to a mySQL server > > > $connection=mysql_connect ($host, $username, $password); > > > if (!$connection) { > > > die("Not connected : " . mysql_error()); > > > > > } > > > > > // Set the active mySQL database > > > $db_selected = mysql_select_db($database, $connection); > > > if (!$db_selected) { > > > die ("Can\'t use db : " . mysql_error()); > > > > > } > > > > > // Search the rows in the markers table > > > $query = sprintf("SELECT address, name, lat, lng, ( 3959 * > > > acos( cos( radians('%s') ) * cos( radians( lat ) ) * > > > cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * > > > sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < > > > '%s' ORDER BY distance LIMIT 0 , 20", > > > mysql_real_escape_string($center_lat), > > > mysql_real_escape_string($center_lng), > > > mysql_real_escape_string($center_lat), > > > mysql_real_escape_string($radius)); > > > $result = mysql_query($query); > > > > > $result = mysql_query($query); > > > if (!$result) { > > > die("Invalid query: " . mysql_error()); > > > > > } > > > > > header("Content-type: text/xml"); > > > > > // Iterate through the rows, adding XML nodes for each > > > while ($row = @mysql_fetch_assoc($result)){ > > > $node = $dom->createElement("marker"); > > > $newnode = $parnode->appendChild($node); > > > $newnode->setAttribute("name", $row['name']); > > > $newnode->setAttribute("address", $row['address']); > > > $newnode->setAttribute("phone", $row['phone']); > > > $newnode->setAttribute("lat", $row['lat']); > > > $newnode->setAttribute("lng", $row['lng']); > > > $newnode->setAttribute("distance", $row['distance']); > > > > > } > > > > > echo $dom->saveXML(); > > > ?> > > > > > On Aug 2, 12:10 pm, "[email protected]" <[email protected]> > > > wrote: > > > > > > On Aug 2, 8:43 am, Jacob Roman <[email protected]> wrote: > > > > > > > > http://www.frykrisp.uphero.com/distributors/map/phpsqlsearch_map.html > > > > > > > Above is a link to theStorelocatori have created following this > > > > > tutorial. > http://code.google.com/apis/maps/articles/phpsqlsearch.html > > > > > > > I would like to add more information to theinfobubbles that pop up > > > > > when you click on the markers. Such as a telephone number and > possibly > > > > > a link to a website. I have tried adding it to MySQL, but it did > not > > > > > work. How would i go about doing this? > > > > > > You need to add the information to: > > > > 1. the database > > > > 2. the xml script > > > > 3. the map code. > > > > > > (Did you try searching, I think this is a common question. I didn't > > > > look, but I remember it coming up before) > > > > > > -- Larry- Hide quoted text - > > > > - Show quoted text - > > -- > You received this message because you are subscribed to the Google Groups > "Google Maps API" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-maps-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-maps-api?hl=en. > > -- -------------------------------- Jacob Roman Graphic/Web Designer Phone: 313.618.3432 Website: jacobroman.tumblr.com E-mail: [email protected] Think Different -- You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en.
