Viewing file: Edit_Fam_His.php (5.62 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" );
require_once( "../include/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
/*
//--- Test value
echo $Teacher_code;
exit;
*/
$myCode = $Teacher_code;
/** Receive values */
//$DateBirth = $_POST[mYear]."-".$_POST[mMonth]."-".$_POST[mDate];
$DateBirth = dmyE2ymdT($_REQUEST["mDate"]);
$Religion = ($_REQUEST["Religion"] == "อื่นๆ")?$_REQUEST["Religion"]."@".$_REQUEST["ReligionOther"]:$_REQUEST["Religion"];
$Citizen_id = str_replace("-","",$_REQUEST["Citizen_id"]);
$Path = "../personal_pic";
//### Upload Image File
if( $_FILES['Img1']['name'] != "") {
if(strrchr($_FILES['Img1']['name'], ".") == ".jpg" || strrchr($_FILES['Img1']['name'], ".") == ".jpeg"){
//ลบไฟล์รูปภาพเดิม
$query1 = "select Img1 from personal_tb WHERE Teacher_code='$Teacher_code'";
$result1 = mysql_query($query1);
$rs = mysql_fetch_array($result1);
if(!empty($rs["Img1"]) && $rs["Img1"]!=$defaultPicFile) unlink($personalPicPath.$rs["Img1"]);
$dbObj->freeresult($result1);
//เพิ่มไฟล์รูปภาพใหม่
//$Img1 = $_FILES['Img1']['name'];
//$Img1 = date('YmdHis').".jpg";
//$Img1 = gmdate("YmdHis").".jpg";
$Img1 = date('YmdHis').strrchr($_FILES['Img1']['name'], ".");
@copy( $_FILES['Img1']['tmp_name'] , $personalPicPath.$Img1);
@unlink( $_FILES['Img1']['tmp_name'] );
}
//--- Table --> 'personal_tb'
$strSQL= " UPDATE personal_tb SET First_name='$First_name',Teacher_name='$Teacher_name',Teacher_lastname='$Teacher_lastname',DateBirth='$DateBirth',Sex='$Sex',Nationality='$Nationality',Nation='$Nation',Religion='$Religion',Citizen_id='$Citizen_id',Father_name='$Father_name',Mother_name='$Mother_name',Status='$Status',Status2='$Status2',Status3='$Status3',Soulmate='$Soulmate',Total_child='$Total_child',Address='$Address',Img1='$Img1',districtId='$districtId' , amphurId='$amphurId' , provinceId='$provinceId' WHERE Teacher_code='$Teacher_code' ";
}
else{
$strSQL="UPDATE personal_tb SET First_name='$First_name',Teacher_name='$Teacher_name',Teacher_lastname='$Teacher_lastname',DateBirth='$DateBirth',Sex='$Sex',Nationality='$Nationality',Nation='$Nation',Religion='$Religion',Citizen_id='$Citizen_id',Father_name='$Father_name',Mother_name='$Mother_name',Status='$Status',Status2='$Status2',Status3='$Status3',Soulmate='$Soulmate',Total_child='$Total_child',Address='$Address',districtId='$districtId' , amphurId='$amphurId' , provinceId='$provinceId' WHERE Teacher_code='$Teacher_code' ";
}
$result = $dbObj->runQuery($strSQL);
$dbObj->freeresult($result);
} # else
?>
ข้อมูลประวัติส่วนตัว - แก้ไขข้อมูลประวัติการทำงาน
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |