Insert data in database using AJAX
I've been using this files two insert data in the database, but unsuccesfully. Can someone tell me what's wrong?
index.php
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script type="text/javascript" src="jquery-1.6.4.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#submit').click(function() {
var name = $('#name').val();
var surname = $('#surname').val();
var email = $('#email').val();
var pass = $('#pass').val();
$.ajax({
type: "POST",
cache: false,
url: 'save.php',
data: {'name='+name, 'surname='+surname, 'email='+email, 'pass='+pass},
success: function(data) {
alert('data has been stored to database');
}
});
});
});
</script>
</head>
<body>
<form action="index.php" method="POST">
<input type="text"name="fname" id="name" />
<input type="text" name="sname" id="surname" />
<input type="email" name="email" id="email" />
<input type="password" name="pass" id="pass" />
<input type="submit" value="Insert" id="submit" />
</form>
</body>
</html>
save.php
<?php
if (isset($_POST['fname']) && isset($_POST['sname']) && isset($_POST['email']) && isset ($_POST['pass'])) {
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("javascript", $con);
$name=$_POST['fname'];
$surname=$_POST['sname'];
$email=$_POST['email'];
$pass=$_POST['pass'];
$query = "INSERT INTO `user` VALUES ('','$name','$surname','$email','$pass')";
$resource = mysql_query($query)
or die (mysql_error());
}
?>