Viewing file: EditPlaning.php (1.84 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
session_start();
if (session_is_registered("valid_user")&&session_is_registered("password"))
{
$Username = $valid_user;
$Password = $password;
include("../include/FunctionDB.php");
ConnectDB();
$January_temp1 = $January;
$February_temp2 = $February;
$March_temp3 = $March;
$April_temp4 = $April ;
$May_temp5 = $May;
$June_temp6 = $June;
$July_temp7 = $July;
$Augus_temp8 = $Augus;
$September_temp9 = $September;
$October_temp10 = $October;
$November_temp11 = $November;
$December_temp12 = $December ;
$Budget_use = $January_temp1 + $February_temp2 + $March_temp3 + $April_temp4 + $May_temp5 + $June_temp6 + $July_temp7 + $Augus_temp8 + $September_temp9 + $October_temp10 + $November_temp11 + $December_temp12;
$Date_start = $_POST[mYear1]."-".$_POST[mMonth1]."-".$_POST[mDate1];
$Date_finish = $_POST[mYear2]."-".$_POST[mMonth2]."-".$_POST[mDate2];
$sql = " UPDATE project_type_tb SET MoneyS_C='$MoneyS_C',Project_code='$Project_code',Orderlist_2='$Orderlist_2',Orderlist='$Orderlist', Project_plan='$Project_plan',Project_name='$Project_name',Faculty_code=' $Faculty_code',Teacher_code='$Teacher_code',Period='$Period',Period_1='$Period_1',Date_start='$Date_start',Date_finish='$Date_finish',Project_rep='$Project_rep',January='$January',February='$February',March='$March',April='$April',May='$May',June='$June',July='$July',Augus='$Augus',September='$September',October='$October',November= '$November',December='$December',Budget_use='$Budget_use' WHERE ProjectId ='$ProjectId' ";
$result = mysql_query($sql) or die("Update Error $sql".mysql_error());
header("Location:EditPlaningList.php?Budget_Year=$Budget_Year&Faculty_code=$Faculty_code&Project_code=$Project_code");
CloseDB();
?>
<?php
}
else
{
echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n";
echo"Please Login ";
}
?>
|