| Server IP : 61.19.30.66 / Your IP : 216.73.216.59 Web Server : Apache/2.2.22 (Ubuntu) System : Linux klw 3.11.0-15-generic #25~precise1-Ubuntu SMP Thu Jan 30 17:39:31 UTC 2014 x86_64 User : www-data ( 33) PHP Version : 5.3.10-1ubuntu3.48 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/gpa/ |
Upload File : |
<?
require_once "head.php";
require_once "config/connectdb.php";
?>
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=tis-620">
<title>ฝ่ายบริหารงานวิชาการ</title>
</head>
<body>
<form action="Save.php?id=<?=$_GET["id"];?>" name="frmEdit" method="post">
<?
$strSQL = "SELECT * FROM klw WHERE Username = '".$_GET["id"]."' ";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if(!$objResult)
{
echo "Not found id=".$_GET["id"];
}
else
{
?>
<table width="100%" border="0" bgcolor="#CCCCCC">
<tr>
<th bgcolor="#A6ACAC" width="160"> <div align="center">รหัสนักเรียน</div></th>
<th bgcolor="#A6ACAC" width="198"> <div align="center"></div></th>
<th bgcolor="#A6ACAC" width="97"> <div align="center"></div></th>
<th bgcolor="#A6ACAC" width="70"> <div align="center"></div></th>
<th bgcolor="#A6ACAC" width="70"> <div align="center"> </div></th>
<th bgcolor="#A6ACAC" width="70"> <div align="center"> </div></th>
</tr>
<tr>
<td><?=$objResult["Username"];?></td>
<td align="right" ><?=$objResult["Name"];?></td>
<td><div align="center">ม.<?=$objResult["cllass"];?></div></td>
<td><div align="center">ห้อง<?=$objResult["room"];?></div></td>
<td><div align="center">เลขที่<?=$objResult["ordinal"];?></div></td>
<td align="right" >วันเกิด <?=$objResult["birdday"];?> เลขประชาชน <?=$objResult["Password"];?></td>
</tr>
<tr>
<td>บิดา</td>
<td align="right" ></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td align="right" >อาชีพ</td>
</tr>
<tr>
<td>มารดา</td>
<td align="right" ></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td align="right" >อาชีพ</td>
</tr>
<tr>
<td>ที่อยู่</td>
<td align="right" ></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td align="right" >โทรศัพท์</td>
</tr>
<tr>
<td>GPA</td>
<td align="right" ><font size="+2" color="red"><?=$objResult["gpa"];?></font></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>
<td align="right" ></td>
</tr>
</table>
<?
}
mysql_close
?>
</form>
<table border="0" style="width: 800px">
<body>
<table class="table table-striped" width="100%" border="0" cellspacing="2" cellpadding="2" bordercolor="#666666" bgcolor="#999999">
<thead>
<tr>
<td bgcolor="#FFFFFF"width="30%"><div align="center"><font size="2">รหัสวิชา</font></div></td>
<td bgcolor="#FFFFFF"width="17%"><div align="center"><font size="2">ปีการศึกษา/เทอม</font></div></td>
<td bgcolor="#FFFFFF"width="17%"><div align="center"><font size="2">คะแนนรวม</font></div></td>
<td bgcolor="#FFFFFF"width="12%"><div align="center"><font size="2">เกรด</font></div></td>
<td bgcolor="#FFFFFF"width="12%"><div align="center"><font size="2">เกรดแก้ตัว</font></div></td>
<td bgcolor="#FFFFFF"width="25%"><div align="center"><font size="2">ครูผู้สอน</font></div></td>
</tr>
<?
$sql_show = "SELECT * FROM klw LEFT JOIN transcripts ON
(klw.Username=transcripts.IDstudent) JOIN mainsubject ON (transcripts.code=mainsubject.Codesub)
WHERE Username = '".$_GET["id"]."' ORDER BY xyy ASC,xterm ASC,SubjCode ASC";
$result_show = mysql_query($sql_show) or die(mysql_error());
while($row_show = mysql_fetch_array($result_show))
{
if($bg == "#EEEEEE") { //ส่วนของการ สลับสี
$bg = "#FFFFFF";
} else {
$bg = "#EEEEEE";
}
$total=$row_show["total"];
$code=$row_show["code"];
$Titles=$row_show["Titles"];
$total=$row_show["total"];
$grad=$row_show["grad"];
$rgrad=$row_show["rgrad"];
$Credits=$row_show["Credits"];
$crsql="SELECT sum(Credits)FROM klw LEFT JOIN transcripts ON
(klw.Username=transcripts.IDstudent) JOIN mainsubject ON (transcripts.code=mainsubject.Codesub)
WHERE Username = '".$_GET["id"]."'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$sumCredits=$dcrd[0];
$crsql="SELECT sum(Credits)FROM klw LEFT JOIN transcripts ON
(klw.Username=transcripts.IDstudent) JOIN mainsubject ON (transcripts.code=mainsubject.Codesub)
WHERE Username = '".$_GET["id"]."'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$sumCreditsgpa=$dcrd[0];
$crsql="SELECT sum(Credits)FROM klw LEFT JOIN transcripts ON
(klw.Username=transcripts.IDstudent) JOIN mainsubject ON (transcripts.code=mainsubject.Codesub)
WHERE Username = '".$_GET["id"]."' and Types=1";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$sumCreditstypes1=$dcrd[0];
$crsql="SELECT sum(Credits)FROM klw LEFT JOIN transcripts ON
(klw.Username=transcripts.IDstudent) JOIN mainsubject ON (transcripts.code=mainsubject.Codesub)
WHERE Username = '".$_GET["id"]."' and Types=2";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$sumCreditstypes2=$dcrd[0];
$sumgrade=$grad*$Credits;
$sumgrad2+=$sumgrade;
$gpa=$sumgrad2/$sumCreditsgpa;
?>
<tr bgcolor="<?=$bg?>">
<td><font size="2"><?=$row_show['code']?> <?=$row_show['Titles']?></font></td>
<td><font size="2"><?=$row_show['xyy']?>//<?=$row_show['xterm']?></font></td>
<td><font size="4" color="red"><? echo "$total"; ?></font></td>
<td><font size="4" color="blue"><? echo "$grad"; ?></font></td>
<td><font size="2"><?=$row_show['rgrad']?></font></td>
<td><font size="2"><?=$row_show['teach']?></font></td>
</tr>
<?
}
?>
<tr>
<td><font size="2"></font></td>
<td><font size="2"></font>รวม <? echo "$sumCredits"; ?></td>
<td><font size="4" color="red">พฐ.<? echo "$sumCreditstypes1";?> พต.<? echo "$sumCreditstypes2";?></font></td>
<td><font size="4" color="blue">GPA<?echo number_format($gpa,2)?></font></td>
<td><font size="2"></font></td>
<td><font size="2"></font></td>
</tr>
</table>
</body>
</html>