<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>User Process Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<script language="JavaScript">
var time = null
function move()
{
window.location = 'admin.php'
}

</script>
<?php

//variables of the user entry-----------------------------
$empno=$_POST['txteno'];
$fname=$_POST['txtfirst'];
$lname=$_POST['txtlast'];
$gender=$_POST['txtgen'];
$age = $_POST['textage'];
$email=$_POST['txtemail'];
$phone=$_POST['txtphone'];
$mobile=$_POST['txtmobile'];
$street=$_POST['txtstreet'];
$city=$_POST['txtcity'];
$pin=$_POST['txtpin'];
$state=$_POST['txtstate'];
$uid=$_POST['txtuid'];
$password=$_POST['txtpwd'];
$cpassword=$_POST['txtcpwd'];
//------------------------------------------------------

//estblishing connection
//echo "this is age" . $age;
$conn = oci_connect('hypermarket', '1234', 'oracle');
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}
$table='userinfo';
$query = "INSERT INTO $table (EMPNO, FIRST_NAME, LAST_NAME, GENDER, AGE, EMAIL, PHONE, MOBILE, STREET, CITY, PIN, STATE, USERID, PASSWORD, CONFIRM_PASSWORD)
VALUES ('$empno','$fname','$lname','$gender','$age','$ema il',
'$phone','$mobile','$street','$city', '$pin', '$state','$uid','$password','$cpassword')";

echo $query;
$stid = oci_parse($conn, $query);


if (!$stid) {
$e = oci_error($conn);
print htmlentities($e['message']);
exit;
}
else
echo "data entered";
@OCI_Bind_By_Name($stid, ':empno', $empno);
@OCI_Bind_By_Name($stid, ':first_name', $fname);
@OCI_Bind_By_Name($stid, ':last_name', $lname);
@OCI_Bind_By_Name($stid, ':gender', $gender);
@OCI_Bind_By_Name($stid, ':age', $age);
@OCI_Bind_By_Name($stid, ':email', $email);
@OCI_Bind_By_Name($stid, 'hone', $phone);
@OCI_Bind_By_Name($stid, ':mobile', $mobile);
@OCI_Bind_By_Name($stid, ':street', $street);
@OCI_Bind_By_Name($stid, ':city', $city);
@OCI_Bind_By_Name($stid, 'in', $pin);
@OCI_Bind_By_Name($stid, ':state', $state);
@OCI_Bind_By_Name($stid, ':userid', $uid);
@OCI_Bind_By_Name($stid, 'assword', $password);
@OCI_Bind_By_Name($stid, ':confirm_password', $cpassword);


$r = oci_execute($stid, OCI_DEFAULT);
if (!$r) {
$e = oci_error($stid);
echo htmlentities($e['message']);
exit;
}


echo "data entered";
?>
<body onLoad="timer=setTimeout('move()',2000)">

</body>
</html>
everything is fine, but the data is not getting into the database, can any tell me why!!!

thanks