Viewing file: AddFamily.php (12.77 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
";
echo " กรุณาทำการ Login ก่อน ";
echo "";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "../include/Function.php" );
/** Create Database Object */
$dbObj = new DBConn;
/** Config Table for This Page */
$myTable = "personal_tb";
$Username = $valid_user;
$sql = " SELECT * FROM $myTable WHERE Teacher_code='$Teacher_code' ";
$res = mysql_query($sql);
$rs= mysql_fetch_array($res);
$sql2 = " SELECT * FROM prefix";
$res2 = mysql_query($sql2);
list($d,$m,$y) = split('/',$_REQUEST["Birth_date"]);
$Date = ($y+543)."-".$m."-".$d;
$People_idcard = str_replace("-","",$_REQUEST["People_idcard"]);
//*** Add Condition ***//
if($_POST["hdnCmd"] == "Add")
{
$sql = " SELECT * FROM people_tb WHERE Status='บุตร' AND People_rank = '".$_POST["Rank"]."' ";
$result = mysql_query($sql);
$Num_Rows=mysql_num_rows($result);
if($Num_Rows==0){
$strSQL = "INSERT INTO people_tb (People_Id,prefixId,People_name,People_surname,People_birth,People_idcard,People_rank,Status,People_legal,People_incom,Teacher_code) VALUES (' ','".$_POST["Prefix"]."' ,'".$_POST["People_name"]."' ,'".$_POST["People_surname"]."' ,'".$Date."','".$People_idcard."' ,'".$_POST["Rank"]."','".$_POST["Status"]."' ,'".$_POST["People_legal"]."','".$_POST["People_incom"]."','".$Teacher_code."') ";
$objQuery = mysql_query($strSQL);
echo "";
}
else{
echo "";
}
}
$strSQL = "SELECT * FROM people_tb";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
} # else
?>
ศูนย์พัฒนาบุคลากร - เพิ่มข้อมูลบุคลากร
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> bool(false)
|