Viewing file: printrep_namesplitprogram.php (3.8 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once "../../class/clsConnection.php";
include_once "../../class/clsDB.php";
include_once "../global.php";
include_once("../class/clsPrefix.php");
$oPf = new Prefix($oC2);
include_once "../class/clsalumnimain.php";
include_once("../class/clsprogramalumni.php");
$oAm = new AlumniMain($oC1);
$oPg_A = new Programalumni($oC1);
?>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
<link href="../source/style.css" rel="stylesheet" type="text/css">
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="left">
<td><br>
<label>
<div align="center"><br>
<form name="ps" method="post" action="<?php echo $PHP_SELF;?>"><table width="700" align="center" border="0" cellpadding="0" cellspacing="1">
<?
$oPg_A->SearchByKey($programId);
$oPg_A->GetRecord();
?>
<tr>
<td align="center" colspan="2"><font size="3" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>"><strong>รายชื่อศิษย์เก่า ปีที่จบการศึกษา <? echo $finishAcadYear; ?><br>หลักสูตร<? echo $oPg_A->programalumniName;?></strong></font></td>
</tr>
<tr>
<td height="22" colspan="2" > </td>
</tr>
<tr>
<td colspan="2" align="center"><table width="550" border="1" cellspacing="0" cellpadding="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_1"]; ?>">
<tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TABLE_2"];?>">
<td width="62" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ลำดับ</strong></font></td>
<td width="370" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ชื่อ-นามสกุล</strong></font></td>
<td width="104" height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_1"];?>"><strong>ปีที่จบการศึกษา</strong></font></td>
</tr>
<?
$i=0;
//$oAm2->RSAlumniMainadmitAcadYearAndprogramIdAndstudentStatusAndstudentName($admitAcadYear,$programalumniId,4,$fName,$lName,$oGn->genId);
$oAm->RSAlumniMainJAlumniBioProgramIdAndFinishAcadYear($programId,$finishAcadYear);
while($oAm->GetRecord())
{
$oPf->SearchByKey($oAm->prefixId);
$oPf->GetRecord();
?>
<tr>
<td height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $i+1; ?></font></td>
<td height="22" align="left"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oPf->prefixName.$oAm->studentName." ".$oAm->studentSurname; ?></font></td>
<td height="22" align="center"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><? echo $oAm->graduateYear;?></font></td>
</tr>
<?
$i++;
}
if($i==0)
{
?>
<tr>
<td colspan="5" align="center" height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">** ไม่ปรากฏรายการในฐานข้อมูล **</font></td>
</tr>
<?
}
?>
<tr align="left">
<td height="22"> </td>
<td height="22" align="right" colspan="4"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">รวม <?php echo $i;?>
รายการ</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" align="center"></td>
</tr>
</table>
</form>
</div>
<font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2" face="MS Sans Serif"><br>
</font>
<br>
</label>
<br><br><br><br>
</td>
</tr>
</table>
|