Viewing file:  EditMan.php (1.68 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
if (session_is_registered("valid_user"))
{
include("../../include/FunctionDB.php");
include("../../source/myFunc.php");
ConnectDB();
//
$Path = "../../Book_pic";
if ( isset($Img1) )
if (copy($Img1,"$Path/$Img1_name"))
{
unlink ($Img1);
$Img1 = "$Path/$Img1_name";
}
//$Date_buy = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate'];
$datebuy = dmyE2ymdT($date);
if($Img1){
$sql = " UPDATE bookmant_tb SET Book_code='$Book_code',No='$No',Year='$Year',No_in='$No_in',conditionId='$conditionId',No_out='$No_out',Teacher_code='$Teacher_code',Faculty_code='$Faculty_code',Store_1='$Store_1',Store_2='$Store_2',Img1='$Img1',Date_buy='$datebuy',Status='$Status',Statistic='$Statistic',Description='$Description' WHERE code ='$code'";
}
else{
$sql = " UPDATE bookmant_tb SET Book_code='$Book_code',No='$No',Year='$Year',No_in='$No_in',No_out='$No_out',Teacher_code='$Teacher_code',Faculty_code='$Faculty_code',Store_1='$Store_1',Store_2='$Store_2',Date_buy='$datebuy',Status='$Status',Statistic='$Statistic',Description='$Description' WHERE code ='$code'";
}
$result = mysql_query($sql) or die("Update Error $sql".mysql_error());
echo "<center>";
echo"<font face=\"Ms san serif\"size=\"4\"><font color=\"0000FF\">$Fname</font> Edit Complete </font></center>";
echo"<meta http-equiv=\"refresh\" content=\"1;URL=EditBookList.php?Year=$Year\">\n";
//header("Location:BookList.php?Book_code=$Book_code");
CloseDB();
?>
<?php
}
else
{
echo"<meta http-equiv=\"refresh\" content=\"3;URL=../../login.php\">\n";
echo"Please Login ";
}
?>
|