include"../../../dsn/conn.php"; ?>
session_start();
$userId=$_SESSION["userId"];
$loginid=$_SESSION["loginid"];
//echo $userId; exit;
//if(isset($userId))
if(!isset($userId))
{
?>
}
function get_Gender()
{
global $conn,$userId;
$query = "select GR_GENDER,GR_SPOUSE_NAME from gr_applicant_detail where GR_APPLICANT_ID=$userId";
$rs1 = OCIParse($conn, $query);
OCIExecute($rs1);
OCIFetchInto($rs1, $row1, OCI_ASSOC);
if(strlen($row1["GR_GENDER"])>0){
if($row1["GR_GENDER"]=='Male') $gender="Mr.";
if($row1["GR_GENDER"]=='Female') $gender="Miss.";
if(strlen($row1["GR_SPOUSE_NAME"])>0) $gender="Mrs.";
}
OCIFreeStatement($rs1);
return $gender;
}
?>
|
include("../include/top.php"); ?>
|
|
include("../include/userleft.php"); ?>
|
|
| include("../include/bottom.php"); ?> |
|
if(count($_POST)){
foreach ($HTTP_POST_VARS as $key => $value) {
$$key = $value;
}
if ($a =='Submit'){
insert_data($conn);
}
}
function insert_data($conn)
{
global $login_Name,$pwd,$uemail;
$query = "insert into GR_LOGIN_INFORMATION values(1,'$login_Name','$pwd','$uemail')";
echo $query;
$stmt = OCIParse($conn, $query);
if (!OCIExecute($stmt)) {
echo "record saved successfully";
// echo $conn . "Record";
}
/* if (!$stmt) {
$oerr = OCIError($stmt);
echo "Fetch Code 1:".$oerr["message"];
exit;
}
use:
$stmt = OCIParse($conn, $query);
if (!$stmt) {
$oerr = OCIError($conn);
echo "Fetch Code 1:".$oerr["message"];
exit;
}*/
}
?>