Saving user input from HTML form to Database / PHP

irish_stevo815

I have a HTML form that allows user input and it should Save to database when the button is clicked. It also should pick up the latitude and longitude from where it is located on the map (using Google Maps API V3).

When the Save button is clicked, it does nothing - the form still remains with the text still displaying.

The HTML form is:

<form class="form-horizontal save-form" style="display: none">
<h1>Add me!</h1>
<fieldset>
<div class="control-group">
....
Form Contents Here
...
</div>
</div>
<div class="form-actions">
<input name="Save" type="submit" class="btn btn-primary" value="Save">
</div>
</fieldset>
</form>

The Javascript setting it to save is:

//when user clicks on the "submit" button
form.submit({point: point}, function (event) {
//prevent the default form behavior (which would refresh the page)
event.preventDefault();

//put all form elements in a "data" object
var data = {
name: $("input[name=name]", this).val(),
description: $("textarea[name=description]", this).val(),
category: $("select[name=category]",this).val(),
lat: event.data.point.overlay.getPosition().lat(),
lon: event.data.point.overlay.getPosition().lng()
};
trace(data)

//send the results to the PHP script that adds the point to the database
$.post("adddata.php", data, tidy_maps.saveStopResponse, "json");

//Erase the form and replace with new message
infowindow.setContent('done')
return false;

The PHP is :

<?php
ini_set("display_errors",1);
//database access info
$db = new mysqli("localhost", "stephen", "pass1", "gmaps1");

$statement = $db->stmt_init();

//database insert statement
$statement->prepare("INSERT INTO tidy_maps_test (lat, lon, name, description, category) VALUES (?, ?, ?, ?, ?)");

//grab values from the url and add to database
$statement->bind_param("ddsss", $_POST, $_POST, $_POST, $_POST, $_POST);
$status = $statement->execute();
//create a status message
if ($status)
{
$message = array("message" => $_POST . " has been added!");
}
else
{
$message = array("error" => $db->error);
}
$statement->close();
echo json_encode($message);
?>

I'm not quiet sure what should go in here:

VALUES (?, ?, ?, ?, ?)

I have been following this tutorial: http://gis.yohman.com/up206b/tutorials/9-3/

any other ideas of where im going wrong??

28064212

irish_stevo815 wrote: »

When the Save button is clicked, it does nothing - the form still remains with the text still displaying.
...
The Javascript setting it to save is:

//when user clicks on the "submit" button
form.submit({point: point}, function (event) {
[B]//prevent the default form behavior (which would refresh the page)[/B]
event.preventDefault();

It's not supposed to refresh the page. The form should just get removed and replaced with "done". Does your "tidy_maps.saveStopResponse" callback method get called? It looks like a problem with your Javascript, have you checked your JS console for errors?

irish_stevo815

28064212 wrote: »

It's not supposed to refresh the page. The form should just get removed and replaced with "done". Does your "tidy_maps.saveStopResponse" callback method get called? It looks like a problem with your Javascript, have you checked your JS console for errors?

It doesnt even even bring up the "done" message when save is clicked.

The error that comes up is:

Uncaught ReferenceError: trace is not defined
(anonymous function)
jQuery.event.dispatch
jQuery.event.add.elemData.handle

28064212

irish_stevo815 wrote: »

It doesnt even even bring up the "done" message when save is clicked.

The error that comes up is:

You haven't defined the trace function. See tutorial 2.2

irish_stevo815

Dunno how i missed that...thank you.