| Server IP : www.kowitt.ac.th / Your IP : 216.73.216.118 Web Server : Microsoft-IIS/7.5 System : Windows NT SERVER02 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.6.31 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/inetpub/wwwroot/mis/teacher/subject_score_v2/ |
Upload File : |
<?PHP
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header ("Last-Modified: " . date("D, d M Y H:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header ("Pragma: no-cache");
include("conf.php");
//echo $_GET["i"];
$PSubjectCode = iconv('utf-8','tis-620',$_GET["PSubjectCode"]);
$sql="delete from LT_GradeSystem where PSubjectCode='".$PSubjectCode."'";
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC);
$sql="insert into LT_GradeSystem (AYearStartUse,GradeNo,GradeType,GradeName,MinScore,MaxScore,PSubjectCode) values ('2547','1','8','4','".$_GET["G40_Min"]."','".$_GET["G40_Max"]."','".$PSubjectCode."') insert into LT_GradeSystem (AYearStartUse,GradeNo,GradeType,GradeName,MinScore,MaxScore,PSubjectCode) values ('2547','2','8','3.5','".$_GET["G35_Min"]."','".$_GET["G35_Max"]."','".$PSubjectCode."') insert into LT_GradeSystem (AYearStartUse,GradeNo,GradeType,GradeName,MinScore,MaxScore,PSubjectCode) values ('2547','3','8','3','".$_GET["G30_Min"]."','".$_GET["G30_Max"]."','".$PSubjectCode."') insert into LT_GradeSystem (AYearStartUse,GradeNo,GradeType,GradeName,MinScore,MaxScore,PSubjectCode) values ('2547','4','8','2.5','".$_GET["G25_Min"]."','".$_GET["G25_Max"]."','".$PSubjectCode."') insert into LT_GradeSystem (AYearStartUse,GradeNo,GradeType,GradeName,MinScore,MaxScore,PSubjectCode) values ('2547','5','8','2','".$_GET["G20_Min"]."','".$_GET["G20_Max"]."','".$PSubjectCode."') insert into LT_GradeSystem (AYearStartUse,GradeNo,GradeType,GradeName,MinScore,MaxScore,PSubjectCode) values ('2547','6','8','1.5','".$_GET["G15_Min"]."','".$_GET["G15_Max"]."','".$PSubjectCode."') insert into LT_GradeSystem (AYearStartUse,GradeNo,GradeType,GradeName,MinScore,MaxScore,PSubjectCode) values ('2547','7','8','1','".$_GET["G10_Min"]."','".$_GET["G10_Max"]."','".$PSubjectCode."') insert into LT_GradeSystem (AYearStartUse,GradeNo,GradeType,GradeName,MinScore,MaxScore,PSubjectCode) values ('2547','8','8','0','".$_GET["G00_Min"]."','".$_GET["G00_Max"]."','".$PSubjectCode."')";
//echo $sql;
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC);
echo "บันทึกเสร็จสมบูรณ์...";
?>