<?php
include("validateInput.php");
session_start();
?>
<?php
$IC = $POST['txtICNumber'];
$emp_name = $POST['txtName'];
$emp_address = $POST['txtAddress'];
$date_join = $POST['txtDjoin'];
$job_title = $POST['txtJobTitle'];
$dept = $POST['txtDept'];
$sex = $_POST['rdoSex'];
$add = $POST['Insert'];
$ic_find = $POST['ICSearch'];
$ename_find = $_POST['EmpSearch'];
if(isset ($add) ){
$correct_IC = chkICNo($IC);
if(!$correct_IC)
print("Format of IC number is incorrect. Please check again</br>");
$correct_empName = chkEmpName($emp_name);
if(!$correct_empName)
print("Format of Employee name is incorrect. Please check again</br>");
if(!$emp_address)
print("Employee Address cannot be empty. Please check again</br>");
$correct_dateJoin = chkDateJoin($date_join);
if(!$correct_dateJoin)
print("Format of date is incorrect. Please check again</br>");
$correct_jobTitle = chkJobTitle($job_title);
if(!$correct_jobTitle)
print("Format of Job Title is incorrect. Please check again</br>");
$correct_Dept = chkDept($dept);
if(!$dept)
print("Format of Department is incorrect. Please check again</br>");
if(!$sex)
print("You must specify male or female.</br>");
if($correct_IC && $correct_empName && $emp_address && $correct_dateJoin && $correct_jobTitle && $correct_Dept && $sex){
$dberror="";
$rvalue=insertRec($IC,$emp_name,$emp_address,$date_join,$job_title,$dept,$sex,$dberror);
if(!$rvalue)
print "Error: $dberror</br>";
else
print "Thank for your input";
}
}
function insertRec($IC,$emp_name,$emp_address,$date_join,$job_title,$dept,$sex,&$dberror){
$IC = addslashes($IC);
$emp_name = addslashes($emp_name);
$emp_address = addslashes($emp_address);
$date_join = addslashes($date_join);
$job_title = addslashes($job_title);
$dept = addslashes($dept);
$sex = addslashes($sex);
$db = mysql_connect("localhost","root","root");
if(!$db){
print("Could not connect to database. Please try again later.");
exit;
}
mysql_select_db("lms");
$query = "INSERT into emp values ('".$IC."', '".$emp_name."', '".$emp_address."', '".$job_title."', '".$date_join."', '".$dept."', '".
$sex."')";
$result = mysql_query($query);
if($result){
echo mysql_affected_rows()." records inserted into database.";
mysql_close($db);
return true;
}
else{
$dberror =mysql_error();
return false;
}
}
if(isset($ic_find)){
$ic_search=$_POST['txtICSearch'];
$correct_IC = chkICNo($ic_search);
if(!$correct_IC)
print("Format of IC number is incorrect. Please check again</br>");
else{
$_SESSION["ic_search"];
header("Location: prtUserTableByIC.php");
//include("prtUserTableByIC.php");
}
}
if(isset($ename_find)){
$ename_search=$_POST['txtNameSearch'];
print("$ename_search");
$correct_name = chkEmpName($ename_search);
if(!$correct_name)
print("Format of Employee Name number is incorrect. Please check again</br>");
else{
$_SESSION["ename_search"];
//include("prtUserTableByName.php");
header("Location: prtUserTableByName.php");
}
}
Still dun work....I print out the value of ic_search in prtUserTableByIC.php and it is empty. When I change to the include("prtUserTableByIC.php"); statement it gives me the correct value.
?>