Viewing file: programTable.php (3.85 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
//include_once "../class/clsprogram.php";
include_once "../global1.php";
include_once "../../class/clsConnection.php";
include_once "../../class/clsDB.php";
include_once("../class/clsProgram.php");
$oC1 = new clsConnection($GLOBALS["HOST_ER"],$GLOBALS["DBNAME_ER"],$GLOBALS["USERNAME_ER"],$GLOBALS["PASSWORD_ER"]);
$oPg = new Program($oC1);
?>
<html>
<head>
<title>ตารางหลักสูตร</title>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../Application%20Data/SSH/source/style.css" rel="stylesheet" type="text/css">
<style>
<!--
A:link {text-decoration: none }
A:visited {text-decoration: none}
A:hover {text-decoration: none; font-weight: underline}
-->
</style>
<!---------------------------------------Begin JavaScript---------------------------------------->
<script language="JavaScript">
function ReturnValue(programId,programName)
{
window.opener.document.ps.programId.value = programId;
window.opener.document.ps.programName.value = programName;
window.close();
}
</script>
</head>
<body bgcolor="#FFFFFF">
<form action="<?php echo $PHP_SELF;?>" method="post" name="ps">
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td colspan="4" align="center"><font face="MS Sans Serif, Microsoft Sans Serif" size="2"><b>ชื่อหลักสูตร : <br></b></font>
<input type="text" name="programName" value="<?php echo $programName;?>" size="30">
<input type="submit" name="search" value="ค้นหา"></td>
</tr>
<tr>
<td colspan="4"> </td>
</tr>
<tr bgcolor="#0066CC">
<td width="12%" align="center"><font face="MS Sans Serif, Microsoft Sans Serif" size="1" color="#FFFFFF"><b>ลำดับที่</b></font></td>
<td width="44%" align="center"><font face="MS Sans Serif, Microsoft Sans Serif" size="1" color="#FFFFFF"><b>ชื่อหลักสูตร</b></font></td>
</tr>
<?php
$oPg->RSProgramName($programName);
$numRow = $oPg->GetRowSelected();
// echo ">>".$numRow;
$page_size = 10;
$total_page = (int)($numRow/$page_size);
if(($numRow%$page_size) != 0)
$total_page++;
if(isset($page_id))
$start = $page_size*($page_id-1);
else {
$page_id = 1;
$start = 0;
}
$i = 0;
$oPg->RSProgramLimit($start, $page_size,$programName);
while ($oPg->GetRecord()){
echo "<tr>";
echo "<td align=\"center\" bgcolor=\"#FFFFFF\"><font size=\"2\" style=\"CURSOR: hand\" onClick='ReturnValue(\"$oPg->programId\",\"$oPg->programName\")'>";
echo $i+$start+1;
echo "</font></td>";
echo "<td align=\"left\" bgcolor=\"#FFFFFF\"><font size=\"2\" style=\"CURSOR: hand\" onClick='ReturnValue(\"$oPg->programId\",\"$oPg->programName\")'>";
echo $oPg->programName;
echo "</font></td>";
//echo "<td align=\"left\" bgcolor=\"#FFFFFF\"><font size=\"2\" style=\"CURSOR: hand\" onClick='ReturnValue(\"$oPf->prefixCode\",\"$oPf->prefixName\",\"$oPf->prefixNameEng\")'>";
//echo $oPf->prefixNameEng;
echo "</font></td>";
// echo $ohi->hireCode. $ohi->hireName;
echo "</tr>";
$i++;
}
if($i == 0) {
?>
<tr>
<td colspan="4" align="center" bgcolor="#FFFFFF"><font size="2" color="#FF0000">** ไม่ปรากฏรายการดังกล่าวในฐานข้อมูล **</font></td>
</tr>
<?php
}
?>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="1" bgcolor="silver">
<tr>
<td><font size="2" face="MS Sans Serif" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">หน้า->
<?php
for ($num=1; $num<=$total_page; $num++) {
if($num == $page_id)
echo $num." ";
else {
?>
<a href="programTable.php?page_id=<?php echo $num;?>&programName=<? echo $programName; ?>"><?php echo '[ '.$num.' ]';?></a>
<?php
}
}
?>
</font></td>
<td align="right"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">รวม <?php echo $numRow;?> รายการ</font></td>
</tr>
</table>
</form>
</body>
</html>
|