The values are taken from adding employee.php and on submit the values will be posted to addemp.php.Below is the code for addemp.php
Code: Select all
[b][u]addemp.php[/u][/b]
<?php include("connect.php"); ?> //connecting to the database
<?php
$FN = $_REQUEST["fname"];
$MN = $_REQUEST["mname"];
$LN = $_REQUEST["lname"];
$SC = $_REQUEST["smucode"];
$DN = $_REQUEST["deptname"];
$SN = $_REQUEST["supno"];
$JS = $_REQUEST["jobstat"];
$D = $_REQUEST["desig"];
$G = $_REQUEST["grade"];
$DOJ = isset($_REQUEST["date5"]) ? $_REQUEST["date5"] : "";
$DOB = isset($_REQUEST["date6"]) ? $_REQUEST["date6"] : "";
$DOR = isset($_REQUEST["date7"]) ? $_REQUEST["date7"] : "";
$LPD = $_REQUEST["lastpromdate"];
$TA = $_REQUEST["tempadd"];
$PA = $_REQUEST["permadd"];
$PN = $_REQUEST["phno"];
$EO = $_REQUEST["emailoff"];
$EQ = $_REQUEST["eduqual"];
$ER = $_REQUEST["exprev"];
$EN = $maxemp;
$tsql = "INSERT INTO tb_employees (emp_no,
emp_fname,
emp_mname,
emp_lname,
smu_code,
super_no,
emp_dob,
emp_doj,
emp_dor,
emp_job_status,
desig,
grade,
temp_addr,
perm_addr,
emp_phno,
email_off,
edu_qual,
exp_rev_no)
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$params=array($EN,$FN,$MN,$LN,$SC,$DOB,$DOJ,$DOR,$SN,$JS,$D,$G,$TA,$PA,$PN,$EO,$EQ,$ER);
$stmt = sqlsrv_query( $conn, $tsql,$params);
//$stmt = sqlsrv_query( $conn, $tsql,$params);emp_doj,emp_dob,emp_dor,,$DOJ,$DOB,$DOR
if( $stmt === false )
{
echo "Error in executing query.</br>";
die( print_r( sqlsrv_errors(), true));
}
else
{
echo "The query was successfully executed.";
}
sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?>