| 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");
$sql = "select PLevel,PTotFOR1,PTotSUM,PTotFOR2,PTotFIN,PTot2For1,PTot2Sum,PTot2For2,PTot2Fin from TSubject where PSubjectCode='".iconv('utf-8','tis-620',$_GET["PSubjectCode"])."'";
//echo $sql;
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
//echo "Term : ".$_SESSION["Term"];
//$_SESSION["Term"]="2";
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
if($row['PLevel']=="1" && rtrim($_SESSION["Term"]=="2")) { // ประถมภาคเรียนที่ 2
$PTotFOR1 = $row["PTot2For1"];
$PTotSUM = $row["PTot2Sum"];
$PTotFOR2 = $row["PTot2For2"];
$PTotFIN = $row["PTot2Fin"];
$PLevel = $row['PLevel'];
} else {
$PTotFOR1 = $row["PTotFOR1"];
$PTotSUM = $row["PTotSUM"];
$PTotFOR2 = $row["PTotFOR2"];
$PTotFIN = $row["PTotFIN"];
$PLevel = $row['PLevel'];
}
}
//echo "PLevel : ".$PLevel;
if($PLevel<=2 && rtrim($_SESSION["Term"])=="1") {
$Title = "คะแนนเต็มภาคเรียนที่ 1";
} else if($PLevel<=2 && rtrim($_SESSION["Term"])=="2") {
$Title = "คะแนนเต็มภาคเรียนที่ 2";
} else {
$Title = "คะแนนเต็ม";
}
$i = $_GET["i"];
?>
<table class="table table-hover">
<thead>
<tr>
<th>รายการคะแนน <?PHP echo $_GET["PSubjectCode"]; ?></th>
<th><?PHP echo $Title; ?></th>
</tr>
</thead>
<tbody>
<tr>
<td>คะแนนเก็บครั้งที่ 1</td>
<td><input type="text" id="PTotFOR1_<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $PTotFOR1; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>คะแนนสอบกลางภาค</td>
<td><input type="text" id="PTotSUM_<?PHP echo $i; ?>"class="form-control" value="<?PHP echo $PTotSUM; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>คะแนนเก็บครั้งที่ 2</td>
<td><input type="text" id="PTotFOR2_<?PHP echo $i; ?>"class="form-control" value="<?PHP echo $PTotFOR2; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td>คะแนนสอบปลายภาค</td>
<td><input type="text" id="PTotFIN_<?PHP echo $i; ?>" class="form-control" value="<?PHP echo $PTotFIN; ?>"/></td>
</tr>
</tbody>
<tbody>
<tr>
<td></td>
<td><button type="button" class="btn btn-danger" id="Close" onclick="Close(<?PHP echo $_GET['i']; ?>)"> ปิด </button> <button type="button" class="btn btn-success" id="Save" onclick="CheckNumber(<?PHP echo $_GET['i']; ?>,'<?PHP echo $_GET['PSubjectCode']; ?>','<?PHP echo $PLevel; ?>');">บันทึก</button></td>
</tr>
</tbody>
</table>