001.
<?
002.
session_start();
003.
?><?
004.
005.
?>
006.
<html>
007.
<head>
008.
<title>ผลการเรียนรู้</title>
009.
<style type=
"text/css"
>
010.
<!--
011.
.style1 {
012.
font-family:
"sr FahTHAI"
;
013.
font-size: 18px;
014.
}
015.
body,td,th {
016.
font-family: sr FahTHAI;
017.
font-size: 24px;
018.
}
019.
a {
020.
font-family: sr FahTHAI;
021.
font-size: 24px;
022.
}
023.
h1,h2,h3,h4,h5,h6 {
024.
font-family: sr FahTHAI;
025.
}
026.
h1 {
027.
font-size: 24px;
028.
}
029.
.style2 {font-size: 24px}
030.
.style3 {font-family:
"sr FahTHAI"
; font-size: 24px; }
031.
.style4 {color: #000000}
032.
.style5 {font-size: 36px}
033.
-->
034.
</style>
035.
<meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
></head>
036.
<body>
037.
<form name=
"form2"
method=
"post"
action=
"EV_LEARNING_SAVE.php"
>
038.
<?
039.
include
(
"connect_db.php"
);
040.
$strSQL
=
"SELECT * FROM TQF ORDER BY TQF_ID ASC"
;
041.
$objParse
= oci_parse (
$objConnect
,
$strSQL
);
042.
oci_execute (
$objParse
,OCI_DEFAULT);
043.
044.
$Num_Rows
= oci_fetch_all(
$objParse
,
$Result
);
045.
046.
$Per_Page
= 10;
047.
048.
$Page
=
$_GET
[
"Page"
];
049.
if
(!
$_GET
[
"Page"
])
050.
{
051.
$Page
=1;
052.
}
053.
054.
$Prev_Page
=
$Page
-1;
055.
$Next_Page
=
$Page
+1;
056.
057.
$Page_Start
= ((
$Per_Page
*
$Page
)-
$Per_Page
);
058.
if
(
$Num_Rows
<=
$Per_Page
)
059.
{
060.
$Num_Pages
=1;
061.
}
062.
else
if
((
$Num_Rows
%
$Per_Page
)==0)
063.
{
064.
$Num_Pages
=(
$Num_Rows
/
$Per_Page
) ;
065.
}
066.
else
067.
{
068.
$Num_Pages
=(
$Num_Rows
/
$Per_Page
)+1;
069.
$Num_Pages
= (int)
$Num_Pages
;
070.
}
071.
$Page_End
=
$Per_Page
*
$Page
;
072.
IF (
$Page_End
>
$Num_Rows
)
073.
{
074.
$Page_End
=
$Num_Rows
;
075.
}
076.
077.
?>
078.
079.
<table width=
"55%"
border=
"0"
cellpadding=
"0"
cellspacing=
"0"
>
080.
<tr>
081.
<td height=
"40"
colspan=
"2"
align=
"left"
valign=
"middle"
> <span
class
=
"style5"
>ผลการเรียนรู้</span></td>
082.
</tr>
083.
<tr>
084.
<td width=
"32%"
align=
"right"
valign=
"middle"
><span
class
=
"style2"
>ปีการศึกษา :</span></td>
085.
<td width=
"68%"
height=
"40"
align=
"left"
valign=
"middle"
><select name=
"ACADYEAR"
id=
"ACADYEAR"
>
086.
<option value=
" "
>--เลือก--</option>
087.
<?
for
(
$i
=2012;
$i
<=
date
(
"Y"
);
$i
++) {?>
088.
<option value=
"<? echo $i; ?>"
> <?
echo
$i
+543; ?></option>
089.
<? }?>
090.
</select></td>
091.
</tr>
092.
<tr>
093.
<td align=
"right"
valign=
"middle"
><span
class
=
"style2"
>เทอม:</span></td>
094.
<td height=
"40"
align=
"left"
valign=
"middle"
><select name=
"SEMESTER"
id=
"SEMESTER"
>
095.
<option><font size=
"+2"
>--เลือก--</font></option>
096.
<option value=
"1"
><font size=
"+2"
>1</font></option>
097.
<option value=
"2"
><font size=
"+2"
>2</font></option>
098.
</select></td>
099.
</tr>
100.
<tr>
101.
<td align=
"right"
valign=
"middle"
><span
class
=
"style2"
>สาขาวิชา:</span></td>
102.
<td height=
"40"
align=
"left"
valign=
"middle"
><?
103.
include
(
"connect_db.php"
);
104.
$strSQL
=
"SELECT DISTINCT EVALUATE.TQF.PROGRAMID,AVSREG.PROGRAM.PROGRAMNAME FROM EVALUATE.TQF INNER JOIN AVSREG.PROGRAM ON EVALUATE.TQF.PROGRAMID=AVSREG.PROGRAM.PROGRAMID ORDER BY PROGRAMID ASC"
;
105.
$objParse
= oci_parse (
$objConnect
,
$strSQL
);
106.
oci_execute (
$objParse
,OCI_DEFAULT);
107.
?>
108.
<select name=
"PROGRAMID"
id=
"PROGRAMID"
>
109.
<option value=[
"PROGRAMID"
] ><font size=
"+2"
> ---เลือก---</font></option>
110.
<?
111.
while
(
$objResult
= oci_fetch_array(
$objParse
,OCI_BOTH))
112.
{
113.
?>
114.
<font size=
"+2"
><option value=
"<?=$objResult["
PROGRAMID
"];?>"
><?=
$objResult
[
"PROGRAMNAME"
];?></option></font>
115.
<?
116.
}
117.
?>
118.
<?
119.
oci_close(
$objConnect
);
120.
?>
121.
</select></td>
122.
</tr>
123.
<tr>
124.
<td align=
"right"
valign=
"middle"
> </td>
125.
<td height=
"9"
align=
"left"
valign=
"middle"
> </td>
126.
</tr>
127.
</table>
128.
<table width=
"800"
border=
"1"
cellpadding=
"0"
cellspacing=
"0"
>
129.
<tr>
130.
<th width=
"102"
bgcolor=
"#FF99FF"
> <div align=
"center"
class
=
"style3"
>ลำดับ</div></th>
131.
<th width=
"594"
bgcolor=
"#FF99FF"
> <div align=
"center"
class
=
"style1 style2 style4"
>เกณฑ์ TQF</div></th>
132.
<th width=
"96"
align=
"center"
bgcolor=
"#FF99FF"
><span
class
=
"style2"
>เลือก</span></th>
133.
</tr>
134.
<?
135.
for
(
$i
=
$Page_Start
;
$i
<
$Page_End
;
$i
++)
136.
{
137.
?>
138.
<tr>
139.
<td valign=
"middle"
><div align=
"center"
><font size=
"+2"
><?=
$Result
[
"TQF_ID"
][
$i
];?></div></font></td>
140.
<td align=
"left"
><font size=
"+2"
><?=
$Result
[
"DESCRIPTION"
][
$i
];?></font></td>
141.
<td align=
"center"
valign=
"middle"
><input type=
"checkbox"
name=
"TQF_ID[]"
value=
"<?=$objResult["
TQF_ID
"];?>"
>
142.
</td>
143.
</tr>
144.
<?
145.
}
146.
?>
147.
</table>
148.
<br>
149.
<font size=
"+1"
>Total </font>
150.
<?=
$Num_Rows
;?>
151.
Record :
152.
<?=
$Num_Pages
;?>
153.
Page :
154.
<?
155.
if
(
$Prev_Page
)
156.
{
157.
echo
" <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< ย้อนกลับ</a> "
;
158.
}
159.
160.
for
(
$i
=1;
$i
<=
$Num_Pages
;
$i
++){
161.
if
(
$i
!=
$Page
)
162.
{
163.
echo
"[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]"
;
164.
}
165.
else
166.
{
167.
echo
"<b> $i </b>"
;
168.
}
169.
}
170.
if
(
$Page
!=
$Num_Pages
)
171.
{
172.
echo
" <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>ถัดไป>></a> "
;
173.
}
174.
?>
175.
<?
176.
oci_close(
$objConnect
);
177.
?>
178.
<input type=
"submit"
name=
"บันทึก"
value=
"บันทึก"
>
179.
</form>
180.
</body>
181.
</html>