Hi, 1) I have a space to input address and geocode/zoom to map. 2) Then a marker is added in that point, and a window shows the address 3) Then that point and anywhere on the map can be click for a input window to appear for extra information to be included in a database 4) This information is saved in database and the window closes after a promt of succes.
I have done 1, 2 & 3 correct, but 4 is tricky just after geocode. Please help. ---------You can see the add here: http://www.wikislot.com/mapa/agregar.php ---------And the database information here: http://www.wikislot.com/mapa/cambios.php --------The Add Database Row code file is: <?php require("phpsqlinfo_dbinfo.php"); // Gets data from URL parameters $name = $_GET['name']; $address = $_GET['address']; $city = $_GET['city']; $provincia = $_GET['provincia']; $zip = $_GET['zip']; $phone = $_GET['phone']; $email = $_GET['email']; $web = $_GET['web']; $lat = $_GET['lat']; $lng = $_GET['lng']; $type = $_GET['type']; $comentario = $_GET['comentario']; // 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()); } // Insert new row with user data $query = sprintf("INSERT INTO markers " . " (id, name, address, city, provincia, comentario, zip, phone, email, web, lat, lng, type ) " . " VALUES (NULL, '%s', '%s', '%s','%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');", mysql_real_escape_string($name), mysql_real_escape_string($address), mysql_real_escape_string($city), mysql_real_escape_string($provincia), mysql_real_escape_string($comentario), mysql_real_escape_string($zip), mysql_real_escape_string($phone), mysql_real_escape_string($email), mysql_real_escape_string($web), mysql_real_escape_string($lat), mysql_real_escape_string($lng), mysql_real_escape_string($type)); $result = mysql_query($query); if (!$result) { die('Invalid query: ' . mysql_error()); } ?> --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
