| 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 : /BK/wwwroot/mis/student/ |
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");
include "conf_mssql.php";
//echo "IDStudent: ".$_POST['IDStudent']." , PasswdStudent : ".$_POST['PasswdStudent'];
$sql="select * from TBStudent where IDStudent='".$_POST['IDStudent']."' and IDCitizen='".$_POST['PasswdStudent']."' and status=1";
//echo $sql;
$stmt = sqlsrv_query( $conn, $sql );
$statusLogin=0;
$StuName ="";
$StuClassRoom="";
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {
$statusLogin=1;
$StuName = iconv("tis-620","utf-8",$row['PreName'])."".iconv("tis-620","utf-8",$row['NameFirst'])." ".iconv("tis-620","utf-8",$row['NameLast']);
$StuClassRoom = iconv("tis-620","utf-8",$row['PClass'])."/".iconv("tis-620","utf-8",$row['PRoom']);
}
//echo $statusLogin;
if($statusLogin==0) {
header( "location: index.php?s=0" );
exit(0);
}
$IDStudent = $_POST['IDStudent'];
$sql="select RegYear,RegTerm from TScore inner join TSubject on TSubject.PSubjectCode = TScore.PSubjectCode where IDStudent='".$IDStudent."' group by RegYear,RegTerm order by RegYear desc ,RegTerm desc";
//echo $sql;
$i=0;
$stmt = sqlsrv_query( $conn, $sql );
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {
$RegYear[$i] = $row["RegYear"];
$RegTerm[$i] = $row["RegTerm"];
$i++;
}
?>
<!DOCTYPE HTML>
<!--
Astral by HTML5 UP
html5up.net | @ajlkn
Free for personal and commercial use under the CCA 3.0 license (html5up.net/license)
-->
<html>
<head>
<title>สารสนเทศสำหรับนักเรียน</title>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no" />
<link rel="stylesheet" href="assets/css/main.css" />
<noscript><link rel="stylesheet" href="assets/css/noscript.css" /></noscript>
<link href="https://fonts.googleapis.com/css?family=Chakra+Petch" rel="stylesheet">
<style>
body {
font-family: 'Chakra Petch', sans-serif;
}
</style>
</head>
<body class="is-preload">
<!-- Wrapper-->
<div id="wrapper">
<!-- Nav -->
<nav id="nav">
<a href="#" class="icon fa-home"><span>ประวัติ</span></a>
<a href="#work" class="icon fa-folder"><span>วิชาการ</span></a>
</nav>
<!-- Main -->
<div id="main">
<!-- Me -->
<article id="home" class="panel intro">
<header>
<h1>ข้อมูลทางวิชาการ</h1>
<p><?PHP echo $StuName ." ชั้น ".$StuClassRoom; ?></p>
</header>
<a href="#work" class="jumplink pic">
<span class="arrow icon fa-chevron-right"><span>See my work</span></span>
<img src="images/me.jpg" alt="" />
</a>
</article>
<!-- Work -->
<article id="work" class="panel">
<header>
<h2>ผลการเรียน</h2>
</header>
<table class="table table-striped">
<?PHP
for($j=0;$j<$i;$j++) {
echo "<tr><td></td><td align='center'>ผลการเรียนของนักเรียน ปีการศึกษา ".$RegTerm[$j]."/".$RegYear[$j]."</td><td></td></tr>";
echo "<tr><td align='center'>ลำดับ</td><td align='center'>รายวิชา</td><td align='center'>ผลการเรียน</td></tr>";
$sql="select RegYear,RegTerm,TSubject.PSubjectCode,TSubject.PSubjectName , PGrade,TSubject.PSubjectCredit from TScore inner join TSubject on TSubject.PSubjectCode = TScore.PSubjectCode where IDStudent='".$IDStudent."' and RegYear='".$RegYear[$j]."' and RegTerm='".$RegTerm[$j]."' order by RegYear desc ,RegTerm desc";
$stmt = sqlsrv_query( $conn, $sql );
$n=1;
$sumPower=0;
$sumCredit=0;
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {
$sumPower = $sumPower + ($row["PGrade"]*$row["PSubjectCredit"]);
$sumCredit = $sumCredit + $row["PSubjectCredit"];
echo "<tr><th scope=\"row\" align='center'>".$n."</th>
<td>".iconv("tis-620","utf-8",$row["PSubjectCode"])." : ".iconv("tis-620","utf-8",$row["PSubjectName"])."</td>
<td align='center'>".$row["PGrade"]."</td>
</tr>";
$n++;
}
echo "<tr><td align='center'></td><td align='center'>ผลการเรียนเฉลี่ย</td><td align='center'>".substr(number_format(($sumPower/$sumCredit),3),0,4)."</td></tr>";
echo "<tr><td colspan='3'><hr></td></tr>";
}
?>
<tbody>
</tbody>
</table>
<!-- Footer -->
<div id="footer">
<ul class="copyright">
<li>© webmaster , Kowittamrongchiangmai </li>
</ul>
</div>
</div>
<!-- Scripts -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/browser.min.js"></script>
<script src="assets/js/breakpoints.min.js"></script>
<script src="assets/js/util.js"></script>
<script src="assets/js/main.js"></script>
</body>
</html>