| Server IP : 122.154.253.140 / Your IP : 216.73.216.209 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="select * from TBStudent where IDStudent='".$_GET['IDStudent']."'";
//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) ) {
$PLevel = $row['PLevel'];
}
$sql="select AYear,Term from TBStudentArriveWeek where getdate() >= dateStart and getdate()<= DateEnd and PLevelID=".$PLevel." group by AYear,Term";
//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) ) {
$AYear = rtrim($row['AYear']);
$Term = rtrim($row['Term']);
}
if($AYear=="") {
echo "<font color='red'>ไม่มีข้อมูลปีการศึกษาและภาคเรียนในวันที่ท่านเลือก</font>";
exit();
}
if($PLevel<3)
$ConditionTerm = "(RegTerm='1' or RegTerm='2')";
else
$ConditionTerm = "(RegTerm='".$Term ."')";
$sql="select convert(char(10),DateDT,103) as DateDT,ValueStr,ValueWeek,DateStr from TBStudentArriveDate where RegYear='".$AYear."' and $ConditionTerm 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) );
}
?>
<table class="table table-striped">
<thead>
<tr>
<th scope="col">#</th>
<th scope="col">วันที่</th>
<th scope="col">สาเหตุ</th>
<th scope="col">-</th>
</tr>
</thead>
<tbody>
<?PHP
$i=1;
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
?>
<tr>
<th scope="row"><?PHP echo $i; ?></th>
<td><?PHP echo $row['DateDT']." - (".rtrim($row['ValueWeek']).")"; ?></td>
<td><?PHP echo iconv("tis-620","utf-8",$row['ValueStr']); ?></td>
<td><button type="button" class="btn btn-danger" onclick="DeleteArrive('<?PHP echo $_GET['IDStudent']; ?>','<?PHP echo $_GET['PSubjectCode']; ?>','<?PHP echo $row['DateStr']; ?>','<?PHP echo $row['ValueWeek']; ?>',<?PHP echo $_GET['Index']; ?>)">Delete</button></td>
</tr>
<?PHP
$i++;
}
echo " </tbody></table>";
?>