I am trying to using jquery post to try to send form data asynchronously to a php file that will upload the data to my database.
<!DOCTYPE html>
<html>
<head>
<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
</head>
<body>
<div id="contact_form">
<form id="contact" name="contact" method="post">
<fieldset>
<label for="name" id="name_label">Name</label>
<input type="text" name="name" id="name" size="30" value="" class="text-input" />
<label for="email" id="email_label">Return Email</label>
<input type="text" name="email" id="email" size="30" value="" class="text-input" />
<label for="phone" id="phone_label">Return Phone</label>
<input type="text" name="phone" id="phone" size="30" value="" class="text-input" />
<br />
<input type="submit" name="submit" class="button" id="submit_btn" value="Submit" />
</fieldset>
</form>
</div>
<div id="result"></div>
<script>
$(document).ready(function(){
/* attach a submit handler to the form */
$("#submit_btn").submit(function(event) {
/* stop form from submitting normally */
event.preventDefault();
$.post("process.php", $("#contact").serialize());
return false;
});
});
</script>
</body>
</html>
I know it is serial encoding the data but my php script isn't picking it up, I am not sure what I am doing wrong. I know it is simple, but I have been working a few days on this and can't seem to figure it out. I understand how to do this without jquery but I really need it in this case. Here is my php:
if(isset($_POST['submit']))
{
$var_name = $_POST['name'];
$var_email = $_POST['email'];
$var_phone = $_POST['phone'];
//This establishes a connection to the database. It also says what to do if the connection fails.
try {
$db_handle = new PDO("mysql:host=$server;dbname=$database", $db_username, $db_password);
$db_handle->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $db_handle->prepare('INSERT INTO contact(name, email, phone) VALUES(:name, :email, :phone)');
$stmt->execute(array(
':name' => $var_name,
':email' => $var_email,
':phone' => $var_phone,
));
} catch(PDOException $e) {
echo 'Error: ' . $e->getMessage();
}
}
