posted 12 years ago
insert.html file
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="generator" content="CoffeeCup HTML Editor (www.coffeecup.com)">
<meta name="created" content="Sat, 24 Sep 2011 15:42:13 GMT">
<meta name="description" content="">
<meta name="keywords" content="">
<title></title>
<!--[if IE]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
</head>
<body>
<div id="myDiv"><h2>CREATE ACCOUNT</h2></div>
<form name="myform" >
First name :<input type="text" name="fname" id="fname"><br /><br />
Last name :<input type="text" name="lname" id="lname"><br /><br />
age :<input type="text" name="age" id="age" /><br /><br />
Hometown :<input type="text" name="hometown" id="hometown" /><br /><br />
Job :<input type="text" name="job" id="job" /><br /><br />
<input type="button" value="Insert" onClick='ajaxfunction()' />
</form>
</body>
</html>
<script type="text/javascript" language="javascript">
var err=false;
var fname=document.getElementById('fname').value;
var age=document.getElementById('age').value;
var hometown=document.getElementById('hometown').value;
var lname=document.getElementById('lname').value;
var job=document.getElementById('job').value;
function ajaxfunction()
{
try
{
var ajaxreq=new XMLHttpRequest();
}
catch(e)
{
alert("your browser broked");
}
ajaxreq.onreadystatechange=function()
{
if(ajaxreq.readystate==4)
{
document.getElementById('myDiv').innerHTML=ajaxreq.responseText;
}
}
var query1="?fname=" + fname + "&lname=" + lname + "&age=" + age + "&hometown=" + hometown + "&job=" + job;
alert(query1);
ajaxreq.open("POST","insert.php" + query1,true);
ajaxreq.send(null);
}
</script>
insert.php
<?php
$dbhost = "localhost";
$dbuser = "scott";
$dbpass = "tiger";
$dbname = "test";
$link=mysql_connect($dbhost, $dbuser, $dbpass);
if(!$link)
{
die("could not connect to mysql');
}
mysql_select_db($dbname,$link) or die("could not open" .mysql_error());
$query="INSERT INTO employees VALUES('$_POST[fname]','$_POST[lname]','$_POST[age]','$_POST[hometown]','$_POST[job]')";
mysql_query($query) or die (mysql_error() );
mysql_close($link);
echo "record inserted";
?>
my recorded is not being inserted ,sometimes it insert a blank & sometimes it doesnot inserts only.
also echo "record inserted" doesnot gets printed even if it insert blank
help me
thanks