| Server IP : 122.154.253.140 / Your IP : 216.73.216.34 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 "PSubjectCode : ".$_GET['PSubjectCode'];
$sql="delete TBStudentArriveDate where DateStr='".$_GET['DateStr']."' and IDStudent='".$_GET['IDStudent']."' and PSubjectCode='".iconv("utf-8","tis-620",$_GET['PSubjectCode'])."'";
//echo $sql; exit();
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
$sql="select * from TBStudentArriveDate where IDStudent='".$_GET['IDStudent']."' and PSubjectCode='".iconv("utf-8","tis-620",$_GET['PSubjectCode'])."' and ValueWeek='".$_GET['ValueWeek']."' order by DateStr";
//echo $sql; exit();
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
$data = $data ."". rtrim($row['ValueStr']);
}
$sql="update TBStudentArrive set ".$_GET['ValueWeek']."= '".$data."' where IDStudent='".$_GET['IDStudent']."' and PSubjectCode='".iconv("utf-8","tis-620",$_GET['PSubjectCode'])."' ";
//echo $sql;
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
?>