Hi friends,
ajax.php
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script type="text/javascript" src="js/jquery.min.js"></script>
</head>
<script type="text/javascript">
function ajaxrequest()
{
var name1=$("#name").val();
var age1=$("#age").val();
var datastring='name='+name1+'&age='+age1;
$.ajax({
type: "POST",
url: "sample.php",
data:datastring,
cache:false,
beforeSend: function()
{
$("#signup_status").html("please wait");
},
success:function(response)
{
alert(response);
$("#signup_status").html(response)
}
});
}
</script>
<body>
<div>
name:<input type="text" name="name" id="name" />
age:<input type="text" name="age" id="age" />
<input type="button" name="submit" value="submit" onclick="ajaxrequest()"/>
<div id="signup_status"></div>
</div>
--------------------------------------------------------------------------
sample.php
<?php
$hostname="localhost";
$username="root";
$password="root";
$database="practise";
$conn= mysql_connect($hostname,$username,$password) or die('could not connect');
$db=mysql_select_db($database) or die('database could not connect');
$name=$_POST['name'];
$age=$_POST['age'];
$qry="INSERT INTO test (name,age)VALUES ('$name','$age')";
$result=mysql_query($qry) or die('query does not work');
if($result!="")
{
echo "records inserted" ;
}
else
{
echo "records not inserted" ;
}
?>
--------------------------------------------------------------------------------
tables:-
Field
Type
name
varchar(25) NOT NULL
age
int(10) NOT NULL
