Viewing file: Edit_fam_his.php (2.37 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php include("../include/FunctionDB.php"); ConnectDB(); $DateBirth = $_POST[mYear]."-".$_POST[mMonth]."-".$_POST[mDate]; $Path = "../personal_pic"; if ( isset($Img1) ) if (copy($Img1,"$Path/$Img1_name")) { unlink ($Img1); $Img1 = "$Path/$Img1_name"; } else echo"Can't Copy"; if($Img1){ $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' 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' WHERE Teacher_code='$Teacher_code'"; } $result = mysql_query($strSQL) or die("Update Error $strSQL".mysql_error()); echo"<center><font face=\"Tahoma\"size=\"6\" color=\"#FF0000\">Update Complete</font></center>"; echo"<meta http-equiv=\"refresh\" content=\"1;URL=Show_Fam_History.php?Teacher_code=$Teacher_code\">"; // header("Location:Show_Fam_History.php"); CloseDB(); ?>
|