001.<?php
002. session_start();
003.
004.$name_my=$_GET[name_my];
005.$name_last=$_GET[name_last];
006.$id_regis_online=$_GET[id_regis_online];
007.$student_id=$_GET[student_id];
008.$th_id=$_REQUEST[th_id];
009.$check=$_REQUEST[check];
010.$id_regis_online=$_REQUEST[id_regis_online];
011.$student_id=$_REQUEST[student_id];
012. $bb=$_REQUEST[bb];
013.
014.
015.<TABLE width=525 height=250>
016. <TR>
017. <TD align=center valign="top"><br>
018. <?
019. include 'connect.php';
020.
021.
022.
023.
024.
025.
026.
027. do {
028.
029. $sql1="select * from sec where student_id=$_GET[student_id]";
030. $query1=mysql_db_query($dbname,$sql1);
031. while ($res1=mysql_fetch_array($query1)){
032. print $year_stu=$res1[year_stu];
033.
034.
035.
036.
037.?>
038.
039.
040.
041.<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#81B9D4" style='border:1px solid #0099CC'>
042. <tr>
043. <td height="25" colspan="6" bgcolor="#FFCC66"> รหัสนักเรียน <?=$student_id?></td>
044. </tr>
045. <tr>
046.
047. <td height="25" align="center" bgcolor="#C9E9F9">รหัสวิชา</td>
048. <td height="25" align="center" bgcolor="#C9E9F9">ชื่อวิชา</td>
049. <td height="25" bgcolor="#C9E9F9">ภาคเรียน </td>
050. <td height="25" align="center" bgcolor="#C9E9F9">ปีการศึกษา</td>
051. <td height="25" align="center" bgcolor="#C9E9F9">หน่วยกิต</td>
052. <td height="25" align="center" bgcolor="#C9E9F9">เกรด</td>
053. </tr>
054. <tr><? $stu=$student_id?>
055.
056. <?
057.
058. include "connect.php";
059. mysql_query("SET NAMES TIS620");
060.
061.
062. $sql="select * from sec where student_id='$stu' order by id_sec ";
063. $res=mysql_db_query($dbname,$sql);
064.
065. while($r=mysql_fetch_array($res))
066. {
067. $id_sec=$r[id_sec];
068. $student_id=$r[student_id];
069. $subject_id=$r[subject_id];
070. $name_subject=$r[name_subject ];
071. $name_stu=$r[name_stu];
072. $sec_no=$r[sec_no];
073. $time_begin =$r[time_begin];
074. $time_end=$r[time_end];
075. $day_sec=$r[day_sec];
076. $room_id =$r[room_id];
077. $grade=$r[grade];
078. $wut=$r[wut];
079. $t_year=$r[t_year];
080. $year_stu=$r[year_stu];
081. $unit =$r[unit];
082. ?>
083.
084.
085. <td width="13%" height="25" align="center" bgcolor="#E0F5F6"><?=$subject_id?></td>
086. <td width="42%" height="25" bgcolor="#E0F5F6"><font color="#FF6600"><?=$name_subject?></font></td>
087. <td width="14%" height="25" align="center" bgcolor="#E0F5F6"><?=$t_year?>
088. </td>
089. <td width="13%" height="25" align="center" bgcolor="#E0F5F6"><?=$year_stu?> </td>
090. <td width="10%" height="25" align="center" bgcolor="#E0F5F6"> <?=$unit?></td>
091. <td width="8%" height="25" align="center" bgcolor="#E0F5F6"> <?=$grade?><? $gpag=$grade;?></td>
092. </tr>
093. <?
094. }
095.?>
096.
097. </table>
098. <p>
099.
100. <table width="100%" border="0" cellspacing="0" cellpadding="0">
101. <tr>
102. <td width="9%" height="20" bgcolor="#99FFFF"> </td>
103. <td width="20%" bgcolor="#99FFFF">เกรดเฉลี่ย</td>
104. <td width="71%" height="20" bgcolor="#99FFFF">
105.
106. <?
107. include "connect.php";
108. mysql_query("SET NAMES TIS620");
109.
110. $result1= mysql_query("SELECT sum(total) FROM sec where student_id='$student_id' order by t_year and year_sec asc");
111.
112. if ($result1)
113. {
114. $query_data1=mysql_fetch_array($result1);
115. $total_s=$query_data1["sum(total)"];
116.
117. }
118.
119. ?>
120.<?
121.include "connect.php";
122.mysql_query("SET NAMES TIS620");
123.
124.$result = mysql_query("SELECT sum(unit) FROM sec where student_id='$student_id' order by t_year and year_sec asc");
125. if ($result)
126. {
127. $query_data=mysql_fetch_array($result);
128. $total_unit=$query_data["sum(unit)"];
129.
130. }
131. ?>
132. <?
133.
134. $total_u=$total_unit*4;
135. print $aaa=($total_s*4)/$total_u;
136.
137.
138. ?> </td>
139. </tr>
140. <tr>
141. <td height="20" bgcolor="#FF9999"> </td>
142. <td height="20" bgcolor="#FF9999">เกรดเฉลี่ยสะสม</td>
143. <td height="20" bgcolor="#FF9999"> <?=$aaa?></td>
144. </tr>
145.</table>
146.<?
147.$term++;
148.}
149.}
150.while ($term < 4);
151.
152.
153.
154.?>
