 |
|
เวลาแก้ไขแล้วเป็นดังรูปครับ

code แก้ไขรูปภาพครับ
Code (PHP)
<?
include ("Admin_session.php");
include ("DB.php");
$objQuery = mysql_query($strSQL);
if($_FILES["fileUpload"]["name"] != "")
{
if(move_uploaded_file($_FILES["fileUpload"]["tmp_name"],"MyResize/".$_FILES["fileUpload"]["name"]))
{
//*** Delete Old File ***//
@unlink("MyResize/".$_POST["hdnOldFile"]);
if ($_REQUEST["Edit1"] != "")
$strSQL = "UPDATE resume set Pre_IDPrefix= '$Pre_IDPrefix', Res_Blood= '$Res_Blood',
Res_Sex= '$Res_Sex', Res_Tel= '$Res_Tel', Res_Email= '$Res_Email', Res_Address= '$Res_Address',
Dis_DistrictID= '$Dis_DistrictID', PROVINCE_ID= '$PROVINCE_ID', Res_PostalCode= '$Res_PostalCode',
Bel_BelongID= '$Bel_BelongID', Res_Duty= '$Res_Duty', Res_Position= '$Res_Position', Res_Salary= '$Res_Salary',
Bos_BossID= '$Bos_BossID', Res_Educational= '$Res_Educational', Res_Emergency= '$Res_Emergency',
Res_Father= '$Res_Father', Res_TelFather= '$Res_TelFather', Res_Mather= '$Res_Mather', Res_TelMather= '$Res_TelMather', AMPHUR_ID= '$AMPHUR_ID', FilesName = '".$_FILES["fileUpload"]["name"]."' where IDPersonnel='".$_POST["IDPersonnel"]."'";
//echo $strSQL;
$objQuery = mysql_query($strSQL);
}
}
if($objQuery)
mysql_select_db($database_config, $config);
$query_edit_from = "SELECT * FROM resume Where Username='" . $_SESSION['Username'] . "'";
$edit_from = mysql_query($query_edit_from, $config) or die(mysql_error());
$row_edit_from = mysql_fetch_assoc($edit_from);
$totalRows_edit_from = mysql_num_rows($edit_from);
mysql_select_db($database_config, $config);
$query_Recordset1 = "SELECT * FROM resume";
$Recordset1 = mysql_query($query_Recordset1, $config) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_close ( $config );
?>
Tag : PHP, MySQL
|
|
 |
 |
 |
 |
Date :
2014-02-26 12:59:22 |
By :
pongtave |
View :
702 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
 |