| Server IP : 122.154.253.140 / Your IP : 216.73.216.49 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 : /BK/wwwroot/mis/teacher/subject_score/ |
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");
?>
<meta charset="utf-8">
<?PHP
$tmp1 = iconv('utf-8','tis-620',$_GET['ValueSend']);
$txtTemp = $_GET['ValueSend'];
$sql = "SELECT TBStudentActivity.AYear, TBStudentActivity.Term, TBStudentActivity.ActivityCode, LT_Activity.ActivityName, TBStudent.IDStudent, TBStudent.PreName+ TBStudent.NameFirst+' '+ TBStudent.NameLast as StuName, TBStudentActivity.ActEval,TBStudentActivity.PClass,TBStudentActivity.PRoom FROM TBStudentActivity INNER JOIN TBStudent ON TBStudentActivity.IDStudent = TBStudent.IDStudent INNER JOIN LT_Activity ON TBStudentActivity.ActivityCode = LT_Activity.ActivityCode where AYear='".$_SESSION["AYear"]."' and Term='".$_SESSION["Term"]."' and LT_Activity.ActivityCode='".$tmp1."' and TBStudent.Status=1 Order by TBStudent.IDStudent";
//echo $sql."<br>"; // (dbo.TScore.PSubjectCode = '".$tmp1."') AND (dbo.TScore.PClass = '".$tmp2."') AND
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false) {
die( print_r( sqlsrv_errors(), true) );
}
//echo $_SESSION["AYear"];
// style='border: 2px solid black'
?>
<table class="table table-striped">
<thead>
<tr>
<th>รายวิชา</th>
<th>ลำดับ</th>
<th>ชื่อ - สกุล</th>
<th>ชั้น</th>
<th>ผลการประเมิน</th>
</tr>
</thead>
<tbody>
<?PHP
$i=1;
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
echo "<tr><td>".iconv('tis-620','utf-8',$row['ActivityName'])."</td><td>".$i."</td><td>".$row["IDStudent"]." - ".iconv('tis-620','utf-8',$row['StuName'])."</td><td>".iconv('tis-620','utf-8',$row['PClass'])."/".iconv('tis-620','utf-8',$row['PRoom'])."</td><td>".iconv('tis-620','utf-8',$row['ActEval'])."</td></tr>";
$i++;
}
echo "</tbody></table>";
sqlsrv_free_stmt( $stmt);
?>
</body>
</html>