svgmx5 Posted February 16, 2011 Share Posted February 16, 2011 Hey everyone i'm working with google maps and i'm having a small problem... the problem is that i have records on my database that i'm echoing using php and mysql and i want to display those items on the map as well. I have the lat and lon of them . The problem is that i also want the users to search for the items and then those items will be displayed based on what the user searched for however i'm using some code from google maps API sample code gallery and i'm having problems parsin the values from the form to the seperate script that displays them results in XML format This is the script i'm suing http://code.google.com/apis/maps/articles/phpsqlajax_v3.html And below i have the code <?php require("phpsqlajax_dbinfo.php"); // Start XML file, create parent node $doc = domxml_new_doc("1.0"); $node = $doc->create_element("markers"); $parnode = $doc->append_child($node); // Opens a connection to a MySQL server $connection=mysql_connect (localhost, $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()); } // Select all the rows in the markers table $query = "SELECT * FROM markers WHERE 1"; $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)){ // ADD TO XML DOCUMENT NODE $node = $doc->create_element("marker"); $newnode = $parnode->append_child($node); $newnode->set_attribute("name", $row['name']); $newnode->set_attribute("address", $row['address']); $newnode->set_attribute("lat", $row['lat']); $newnode->set_attribute("lng", $row['lng']); $newnode->set_attribute("type", $row['type']); } $xmlfile = $doc->dump_mem(); echo $xmlfile; ?> Obviously i'm using my own rows and info. So my question is how can i get the post variables from the form which are stored in one page to get them to echo in the page above with the script so it can search for the values I've tried using $_SESSION[] but its not wokrking, nothing is being parsed, and yes i did add session_start() at the top of the page Quote Link to comment https://forums.phpfreaks.com/topic/227873-need-help-with-google-maps-api/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.