!c99Shell v. 1.0 pre-release build #16!

Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/mis/ealumni/admin/   drwxr-xr-x
Free 51 GB of 127.8 GB (39.91%)
Home    Back    Forward    UPDIR    Refresh    Search    Buffer    Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    


Viewing file:     editStudentMB.php (80.64 KB)      -rwxr-xr-x
Select action/file-type:
(+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include_once "template.php";
showHeader();
include_once "../link/function.php";
include_once "../class/clsStudentMaster.php";
include_once "../class/clsStudentBio.php";
include_once "../class/clsPrefix.php";
include_once "../class/clsLevel.php";
include_once "../class/clsProgram.php";
include_once "../class/clsSysStudentStatusDes.php";
include_once "../class/clsGeneration.php";
include_once "../class/clsScholar.php";
include_once "../class/clsProvince.php";
include_once "../class/clsEntryType.php";
include_once "../class/clsEntryType2.php";
include_once "../class/clsDistrict.php";
include_once "../class/clsAmphur.php";
include_once "../class/clsSysFinanceStatusDes.php";
include_once "../class/clsPreAdmitPosition.php";
include_once "../class/clsHealthPrivilege.php";
include_once "../class/clsDegree.php";
include_once "../class/clsNation.php";
include_once "../class/clsReligion.php";
include_once "../class/clsMaritalStatus.php";
include_once "../class/clsRecruitmentType.php";
include_once "../class/clsStudentActivity.php";
include_once "../class/clsSysSemesterDes.php";
include_once "../class/clsSysStudentYearDes.php";
include_once "../class/clsStudentAbsent.php";
include_once "../class/clsStudentBehavior.php";
include_once "../class/clsDiscipline.php";
include_once "../class/clsStudentReward.php";

$conn = new Connection();

$oSm = new StudentMaster();
$oSb = new StudentBio();
$oPf = new Prefix();
$oLv = new Level();
$oPg = new Program();
$oSs = new SysStudentStatusDes();
$oGe = new Generation();
$oSc = new Scholar();
$oPv = new Province();
$oEt = new EntryType();
$oEt2 = new EntryType2();
$oDt = new District();
$oAm = new Amphur();
$oSf = new SysFinanceStatusDes();
$oPp = new PreAdmitPosition();
$oHp = new HealthPrivilege();
$oDg = new Degree();
$oNt = new Nation();
$oRg = new Religion();
$oMs = new MaritalStatus();
$oRt = new RecruitmentType();
$oSa = new StudentActivity();
$oSse = new SysSemesterDes();
$oSsy = new SysStudentYearDes();
$oSab = new StudentAbsent();
$oSbe = new StudentBehavior();
$oDs = new Discipline();
$oSr = new StudentReward();

tabChoose();
openWindow();
confirmSubmit();
?>
<style type="text/css">
<!--
    #tabmargin { margin: 2px 2px 2px 2px; }
    .tabnav a, .tabnav a:link, .tabnav a:visited { display: block; height: 22px; font-family: MS Sans Serif; font-size: 14px; line-height: 22px; background-color: #ABCDEF; color: #000000; margin-right: 4px; padding: 2px 3px 0 3px; text-decoration: none; }    
    .tabnav a.tabselected, .tabnav a.tabselected:link, .tabnav a.tabselected:visited { background-color: #FFFFFF; color: #333333; cursor: text; margin-right: 14px; }
    .contentblock { padding: 2px; background-color: #FFFFFF; color: #ABCDEF; font-family: MS Sans Serif; }
    .contentblock p { font-size: 22px; }
    #tab1, #tab2, #tab3, #tab4, #tab5, #tab6 { display: none; }
-->
</style>
<script language="JavaScript1.2">
function checkFormat(txtStart, txtEnd) {
    if(document.pc.acadYearSa.value!="" && document.pc.acadYearSa.value<document.pc.adY.value) {
        alert("ไม่ใช่ข้อมูลการทำกิจกรรมขณะศึกษาในวิทยาลัยนี้ !!");
        document.pc.acadYearSa.focus();
        return false;
    }
    
    if(document.pc.acadYearSa.value!="" && document.pc.acadYearSa.value.length!=4) {
        alert("ปีการศึกษาข้อมูลการทำกิจกรรมไม่ถูกต้อง !!");
        document.pc.acadYearSa.focus();
        return false;
    }
    
    if(document.pc.classYear.value != "") {
        if(document.pc.activityName.value == "") {
            alert("กรุณากรอกชื่อกิจกรรม/โครงการ !!");
            document.pc.activityName.focus();
            return false;
        }
        
        if(document.pc.position.value == "") {
            alert("กรุณากรอกการเข้าร่วมในกิจกรรม !!");
            document.pc.position.focus();
            return false;
        }
    }
    
    if(document.pc.acadYearSab.value!="" && document.pc.acadYearSab.value<document.pc.adY.value) {
        alert("ไม่ใช่ข้อมูลการลา/ขาดขณะศึกษาในวิทยาลัยนี้ !!");
        document.pc.acadYearSab.focus();
        return false;
    }
    
    if(document.pc.acadYearSab.value!="" && document.pc.acadYearSab.value.length!=4) {
        alert("ปีการศึกษาข้อมูลการลา/ขาดไม่ถูกต้อง !!");
        document.pc.acadYearSab.focus();
        return false;
    }
    
    if(document.pc.studentYearSab.value != "") {
        if(document.pc.absentCause.value == "") {
            alert("กรุณาเลือกประเภทการลา/ขาด !!");
            document.pc.absentCause.focus();
            return false;
        }
    }
    
    if(document.pc.acadYearSbe.value!="" && document.pc.acadYearSbe.value<document.pc.adY.value) {
        alert("ไม่ใช่ข้อมูลความประพฤติขณะศึกษาในวิทยาลัยนี้ !!");
        document.pc.acadYearSbe.focus();
        return false;
    }
    
    if(document.pc.acadYearSbe.value!="" && document.pc.acadYearSbe.value.length!=4) {
        alert("ปีการศึกษาข้อมูลความประพฤติไม่ถูกต้อง !!");
        document.pc.acadYearSbe.focus();
        return false;
    }
    
    if(document.pc.description.value != "") {
        if(document.pc.disciplineName.value == "") {
            alert("กรุณาเลือกระดับคะแนน !!");
            document.pc.disciplineName.focus();
            return false;
        }
    }
    
    if(document.pc.reward.value != "") {
        if(document.pc.descriptionReward.value == "") {
            alert("กรุณากรอกรายละเอียด !!");
            document.pc.descriptionReward.focus();
            return false;
        }
    }
    
    if (txtStart && txtEnd) {
        var oblen = txtStart.length;
        for (var i = 0; i < oblen; i++) {
            if (!isvaliddate(txtStart[i], txtEnd[i])) {
                return false;
            }
        }
    }
    return true;
}

function isvaliddate (txtStart, txtEnd) {
    var retval = true;  
    var ArrayStartDay = txtStart.split("/");
    var ArrayStopDay = txtEnd.split("/");
    var StartDay = ArrayStartDay[2] + ArrayStartDay[1] + ArrayStartDay[0];
    var StopDay = ArrayStopDay[2] + ArrayStopDay[1] + ArrayStopDay[0];
    if (StartDay > StopDay) {
        alert("วันที่ไม่ถูกต้อง");
        retval = false;
    }
    return retval;
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<body onload="controlsubmenu('tab5','tabE'); return false;">
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
        <td align="center"><br><fieldset>
            <legend><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3']; ?>"><a href="adminIndex.php?mm=1">นักศึกษา</a> <img src="../picture/ico3.gif" align="absmiddle" border="0"> <a href="searchStudent.php">ข้อมูลนักศึกษา</a> <img src="../picture/ico3.gif" align="absmiddle" border="0"> บันทึก/แก้ไขข้อมูลนักศึกษาปัจจุบัน</font></legend>
            <label><div id="tabmargin"><br><form name="pc" method="post" action="processStudentBio.php" enctype="multipart/form-data"><div>            
            <table class="tabnav" width="700" border="0" cellpadding="0" cellspacing="0" align="center">
                <tbody><tr>
                    <td width="120" height="22" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><a class="tabselected" id="tabE" href="/" onclick="controlsubmenu('tab5','tabE');return false;"><b>แก้ไขข้อมูลแรกเข้า</b></a></font></td>
                    <td width="100" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><a class="n" id="tabA" href="/" onclick="controlsubmenu('tab1','tabA');return false;"><b>ข้อมูลส่วนตัว</b></a></font></td>
                    <td width="120" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><a class="n" id="tabB" href="/" onclick="controlsubmenu('tab2','tabB');return false;"><b>ข้อมูลการทำกิจกรรม</b></a></font></td>
                    <td width="120" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><a class="n" id="tabC" href="/" onclick="controlsubmenu('tab3','tabC');return false;"><b>ข้อมูลการลา/ขาด</b></a></font></td>
                    <td width="120" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><a class="n" id="tabD" href="/" onclick="controlsubmenu('tab4','tabD');return false;"><b>ข้อมูลความประพฤติ</b></a></font></td>
                    <td width="120" align="center"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><a class="n" id="tabF" href="/" onclick="controlsubmenu('tab6','tabF');return false;"><b>ข้อมูลการรับรางวัล</b></a></font></td>
                </tr></tbody>
            </table>
            <input type="hidden" name="studentId" value="<?php echo $studentId;?>">
<?php
            $oSm->SearchByKey($studentId);
            $oSm->GetRecord();
            $oSb->SearchByKey($studentId);
            $oSb->GetRecord();
?>
            <div style="display: block;" class="contentblock" id="tab5">    
            <table width="700" boder="0" cellpadding="1" cellspacing="0" align="center">
                <tr>
                    <td colspan="5">&nbsp;</td>
                </tr>
                <tr>
                    <td width="94" height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>รหัสนักศึกษา</b></font></td>
                    <td width="164"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oSm->studentCode;?></font></td>
                    <td width="165"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>รหัสบัตรประจำตัวประชาชน</b></font></td>
                    <td width="165"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oSm->citizenId;?></font></td>
                    <td width="100" rowspan="7" valign="top">
<?php
                    if($oSb->picturePath == '') {
?>
                    <img src="../pictureStud/photo.jpg" align="absmiddle" border="1" width="100" height="115">
<?php
                    }
                    else {
?>
                    <img src="<?php echo $oSb->picturePath;?>" align="absmiddle" border="1" width="100" height="115">
<?php
                    }
?>
                    </td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<?php
                    $oPf->SearchByKey($oSm->prefixId);
                    $oPf->GetRecord();
?>
                    <td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>ชื่อ-นามสกุล</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oPf->prefixName.$oSm->studentName.' '.$oSm->studentSurname;?></font></td>
<?php
                    $oLv->SearchByKey($oSm->levelId);
                    $oLv->GetRecord();
?>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>ระดับการศึกษา</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oLv->levelName;?></font></td>
                </tr>
                <tr>
<?php
                    $oPg->SearchByKey($oSm->programId);
                    $oPg->GetRecord();
?>
                    <td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>หลักสูตร</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oPg->programName;?></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>ชั้นปีที่</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oSm->studentYear;?></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<?php
                    $oSs->SearchByKey($oSm->studentStatus);
                    $oSs->GetRecord();
?>
                    <td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>สถานะนักศึกษา</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php  echo $oSs->description;?></font></td>
<?php
                    $oGe->SearchByKey($oSm->genNo);
                    $oGe->GetRecord();
?>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>ภาค/ปีการศึกษาที่เข้า</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oSm->admitSemester.'/'.$oSm->admitAcadYear.' (รุ่นที่ '.$oGe->genNo.')';?></font></td>
                </tr>
                <tr>
                    <td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>GPA</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo number_format($oSm->GPA, 2);?></font></td>
<?php
                    $oSc->SearchByKey($oSm->scholarId);
                    $oSc->GetRecord();
?>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>เจ้าของทุน</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oSc->scholarName;?></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
<?php
                    $oPv->SearchByKey($oSc->provinceId);
                    $oPv->GetRecord();
?>
                    <td height="22"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>ทุนจังหวัด</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oPv->provinceName;?></font></td>
<?php
                    $oEt->SearchByKey($oSm->entryTypeId);
                    $oEt->GetRecord();
                    if($oSm->entryTypeId2 == 2) {
                        $oEt2->SearchByKey($oSm->entryTypeId2);
                        $oEt2->GetRecord();
                        
                        $etName2 = ' ('.$oEt2->entryTypeName2.')';
                    }
?>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>ประเภททุน</b></font></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">: <?php echo $oEt->entryTypeName.$etName2;?></font></td>
                </tr>
                <tr>
                    <td height="22" colspan="4"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4']; ?>"><b>คะแนนความประพฤติ</b> : <?php echo $oSm->totalPoint;?></font></td>
                </tr>
            </table><br>
            <table width="700" border="0" cellpadding="1" cellspacing="1" bordercolor="<?php echo $GLOBALS["COLOR_BORDER_TABLE_2"];?>">
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td colspan="6" height="22"><font size="3" color="<?php echo $GLOBALS['COLOR_FONT_1'];?>"><strong>&nbsp;ข้อมูลประวัติส่วนตัว</strong></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td width="212" height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>รหัสประจำตัวนักศึกษา</b></font></td>
                    <td width="10">&nbsp;</td>
                    <td width="318"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oSm->studentCode;?></font>
                    <input type="hidden" name="studentCode" value="<?php echo $oSm->studentCode;?>"></td>
                </tr>
                <tr>
                    <td height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><b>เลขที่บัตรประจำตัวประชาชน</b></font></td>
                    <td>&nbsp;</td>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oSm->citizenId;?></font>
                    <input type="hidden" name="citizenId" value="<?php echo $oSm->citizenId;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ระดับการศึกษา</strong></font></td>
                    <td>&nbsp;</td>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oLv->levelName;?></font>
                    <input type="hidden" name="levelId" value="<?php echo $oSm->levelId;?>"></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>หลักสูตร</strong></font></td>
                    <td>&nbsp;</td>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oPg->programName;?></font>
                    <input type="hidden" name="programId" value="<?php echo $oSm->programId;?>">
                    <input type="hidden" name="genNo" value="<?php echo $oSm->genNo;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ชื่อ-สกุลไทย</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="prefixName" value="<?php echo $oPf->prefixName;?>" size="3" class="input2" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("prefixTable.php",400,400)'>
                    <input type="text" name="studentName" value="<?php echo $oSm->studentName;?>" size="15">
                    <input type="text" name="studentSurname" value="<?php echo $oSm->studentSurname;?>" size="15">
                    <font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">*</font>
                    <input type="hidden" name="prefixId" value="<?php echo $oSm->prefixId;?>">
                    <input type="hidden" name="prefixNameEng"></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ชื่อ-สกุลผู้ปกครอง</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentName" value="<?php echo $oSb->parentName;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td height="22"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ความสัมพันธ์กับนักศึกษา</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentRelation" value="<?php echo $oSb->parentRelation;?>"></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ที่อยู่ผู้ปกครองที่สามารถติดต่อได้</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentAddress" value="<?php echo $oSb->parentAddress;?>" size="30"></td>
                </tr>
<?php
                $oDt->districtName = '';
                $oAm->amphurName = '';
                $oPv->provinceName = '';
                
                $oDt->SearchByKey($oSb->parentDistrictId);
                $oDt->GetRecord();
                $oAm->SearchByKey($oSb->parentAmphurId);
                $oAm->GetRecord();
                $oPv->SearchByKey($oSb->parentProvinceId);
                $oPv->GetRecord();
?>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ตำบล</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentDistrict" value="<?php echo $oDt->districtName;?>" size="20" class="input2" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("parentDistrictTable.php",550,350)'>
                    <input type="hidden" name="parentDistrictId" value="<?php echo $oSb->parentDistrictId;?>"></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>อำเภอ</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentAmphur" value="<?php echo $oAm->amphurName;?>" size="20" class="input1" readonly>
                    <input type="hidden" name="parentAmphurId" value="<?php echo $oSb->parentAmphurId;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>จังหวัด</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentProvince" value="<?php echo $oPv->provinceName;?>" size="20" class="input2" readonly>
                    <input type="hidden" name="parentProvinceId" value="<?php echo $oSb->parentProvinceId;?>"></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>รหัสไปรษณีย์</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentZipcode" value="<?php echo $oSb->parentZipcode;?>" size="5" maxlength="5" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>เบอร์โทรศัพท์บ้าน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentPhoneNo" value="<?php echo $oSb->parentPhoneNo;?>" size="10" maxlength="10" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;"></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>เบอร์โทรศัพท์มือถือ</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentMobile" value="<?php echo $oSb->parentMobile;?>" size="10" maxlength="10" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>อาชีพผู้ปกครอง</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentOcc" value="<?php echo $oSb->parentOcc;?>" size="20"></td>
                </tr>                                                                                                                                                                                                                        
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>รายได้ผู้ปกครอง</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentIncome" value="<?php echo $oSb->parentIncome;?>" size="5" maxlength="6" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">&nbsp;บาท</font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>อีเมล์ผู้ปกครอง</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="parentEmail" value="<?php echo $oSb->parentEmail;?>" size="20"></td>
                </tr>                                                                                                                                                                                                                        
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ปีการศึกษาที่เข้า</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="admitAcadYear" value="<?php echo $oSm->admitAcadYear;?>" class="input1"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ภาคการศึกษาที่เข้า</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="admitSemester" value="<?php echo $oSm->admitSemester;?>" class="input2"></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>วันที่รับเข้า</strong></font></td>
                    <td>&nbsp;</td>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo splitDateDb2($oSm->admitDate);?></font>
                    <input type="hidden" name="admitDate" value="<?php echo $oSm->admitDate;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>วันที่สิ้นสุดการเป็นนักศึกษา</strong></font></td>
                    <td>&nbsp;</td>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo splitDateDb2($oSm->finishDate);?></font>
                    <input type="hidden" name="finishDate" value="<?php echo $oSm->finishDate;?>"></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ชั้นปีนักศึกษา</strong></font></td>
                    <td>&nbsp;</td>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oSm->studentYear;?></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>สถานะของนักศึกษา</strong></font></td>
                    <td>&nbsp;</td>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oSs->description;?></font>
                    <input type="hidden" name="studentStatus" value="<?php echo $oSm->studentStatus;?>"></td>
                </tr>
<?php
                $oSf->SearchByKey($oSm->financeStatus);
                $oSf->GetRecord();
?>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>สถานะทางการเงิน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><?php echo $oSf->description;?></font>
                    <input type="hidden" name="financeStatus" value="<?php echo $oSm->financeStatus;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>เจ้าของทุน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="scholarName" value="<?php echo $oSc->scholarName;?>" size="20" class="input2" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("scholarTable.php",400,400)'>
                    <font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">*</font></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>จังหวัดเจ้าของทุน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="text" name="pvName" value="<?php echo $oPv->provinceName;?>" size="20" class="input1" readonly>
                    <input type="hidden" name="scholarId" value="<?php echo $oSm->scholarId;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>ประเภททุน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="entryTypeId">
                        <option value="<?php echo $oSm->entryTypeId;?>"><?php echo $oEt->entryTypeName;?></option>
<?php
                        $oEt->RSEntryType();
                        while($oEt->GetRecord()) {
?>
                        <option value="<?php echo $oEt->entryTypeId;?>"><?php echo $oEt->entryTypeName;?></option>
<?php
                        }
?>
                    </select>
                    <font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"];?>">*</font></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>สถานะ/ตำแหน่งก่อนเข้าเรียน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="preAdmitPositionId">
<?php
                        $oPp->SearchByKey($oSm->preAdmitPositionId);
                        if($oPp->GetRecord()) {
?>
                        <option value="<?php echo $oSm->preAdmitPositionId;?>"><?php echo $oPp->positionName;?></option>
<?php
                        }
                        else {
?>
                        <option value="">---เลือกสถานะ/ตำแหน่งก่อนเข้าเรียน---</option>
<?php
                        }
                        
                        $oPp->RSPreAdmitPosition();
                        while($oPp->GetRecord()) {
?>
                        <option value="<?php echo $oPp->preAdmitPositionId;?>"><?php echo $oPp->positionName;?></option>
<?php
                        }
?>
                    </select></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS["COLOR_BG_TD_4"];?>">
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>สิทธิการเบิกค่าเล่าเรียน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input type="radio" name="canRefund" value="Y" <?php if($oSb->canRefund == 'Y') echo 'checked';?>><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>">มี
                    <input type="radio" name="canRefund" value="N" <?php if($oSb->canRefund == 'N') echo 'checked';?>>ไม่มี</font></td>
                </tr>

                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_4"];?>"><strong>สิทธิการรักษาพยาบาล</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="healthPrivId">
<?php
                        $oHp->SearchByKey($oSb->healthPrivId);
                        if($oHp->GetRecord()) {
?>
                        <option value="<?php echo $oSb->healthPrivId;?>"><?php echo $oHp->healthPrivName;?></option>
<?php
                        }
                        else {
?>
                        <option value="">---เลือกสิทธิการรักษาพยาบาล---</option>
<?php
                        }
                        
                        $oHp->RSHealthPrivilege();
                        while($oHp->GetRecord()) {
?>
                        <option value="<?php echo $oHp->healthPrivId;?>"><?php echo $oHp->healthPrivName;?></option>
<?php
                        }
?>
                    </select></td>
                </tr>                        
            </table>            
            </div><br>
            <div class="contentblock" id="tab1">                    
            <table width="700" border="0" cellpadding="1" cellspacing="1" bordercolor="<?php echo $GLOBALS['COLOR_BORDER_TABLE_2'];?>" align="center">
                <tr>
                    <td colspan="6" height="22"><font size="3" color="<?php echo $GLOBALS['COLOR_FONT_1'];?>"><strong>&nbsp;ข้อมูลประวัติส่วนตัว</strong></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>ชื่อ-นามสกุล (อังกฤษ)</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><input type="text" name="prefixNameEng" value="<?php echo $oPf->prefixNameEng;?>" size="4" class="input2" readonly>
                    <input type="text" name="studentNameEng" value="<?php echo $oSm->studentNameEng;?>" size="15">
                    <input type="text" name="studentSurnameEng" value="<?php echo $oSm->studentSurnameEng;?>" size="20">
                    <font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>">*</font></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>ชื่อเก่านักศึกษา</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><input type="text" name="oldStudentName" value="<?php echo $oSb->oldStudentName;?>" size="30"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>วุฒิการศึกษาก่อนรับเข้า</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><select name="entryDegree">
<?php
                        $oDg->SearchByKey($oSb->entryDegree);
                        if($oDg->GetRecord()) {
?>
                        <option value="<?php echo $oSb->entryDegree;?>"><?php echo $oDg->degreeName;?></option>
<?php
                        }
                        else {
?>
                        <option value="">---เลือกวุฒิการศึกษาก่อนรับเข้า---</option>
<?php
                        }
                        
                        $oDg->RSDegree();
                        while($oDg->GetRecord()) {
?>
                        <option value="<?php echo $oDg->degreeId;?>"><?php echo $oDg->degreeName;?></option>
<?php
                        }
?>
                    </select></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>อีเมล์</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><input type="text" name="studentEmail" value="<?php echo $oSm->studentEmail;?>" size="30">
                    <font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>">*</font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>รูปภาพนักศึกษา</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><input type="file" name="uploadfile" value="<?php echo $oSb->picturePath;?>">
                    <input type="hidden" name="picturePathOld" value="<?php echo $oSb->picturePath;?>">
                    <font size="2" color="<?php echo $GLOBALS['COLOR_FONT_3'];?>">* (ขนาดรูปภาพควรมีขนาด 100x115 pixels)</font></td>
                </tr>
                <tr>
                    <td width="180"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>เพศ</strong></font></td>
                    <td width="9">&nbsp;</td>
                    <td width="205"><input type="radio" name="studentSex" value="M" <?php if($oSb->studentSex == 'M') echo 'checked';?>><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">ชาย
                    <input type="radio" name="studentSex" value="F" <?php if($oSb->studentSex == 'F') echo 'checked';?>>หญิง</font></td>
                    <td width="146"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>หมู่เลือด</strong></font></td>
                    <td width="5">&nbsp;</td>
                    <td width="136"><input type="text" name="bloodGroup" size="6" maxlength="6" value="<?php echo $oSb->bloodGroup;?>" onKeyPress="if(event.keyCode < 32 || event.keyCode > 90) return false;"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>สัญชาติ</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="nationId">
<?php
                        $oNt->SearchByKey($oSb->nationId);
                        if($oNt->GetRecord()) {
?>
                        <option value="<?php echo $oSb->nationId;?>"><?php echo $oNt->nationName;?></option>
<?php
                        }
                        else {    
?>
                        <option value="">---เลือกสัญชาติ---</option>
<?php
                        }
                        
                        $oNt->RSNation();
                        while($oNt->GetRecord()) {
?>
                        <option value="<?php echo $oNt->nationId;?>"><?php echo $oNt->nationName;?></option>
<?php
                        }
?>
                    </select></td>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>ศาสนา</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="religionId">
<?php
                        $oRg->SearchByKey($oSb->religionId);
                        if($oRg->GetRecord()) {
?>
                        <option value="<?php echo $oSb->religionId;?>"><?php echo $oRg->religionName;?></option>
<?php
                        }
                        else {
?>
                        <option value="">---เลือกศาสนา---</option>
<?php
                        }
                        
                        $oRg->RSReligion();
                        while($oRg->GetRecord()) {
?>
                        <option value="<?php echo $oRg->religionId;?>"><?php echo $oRg->religionName;?></option>
<?php
                        }
?>
                    </select></td>
                </tr>
                <tr>
                    <td><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>"><strong>วันเกิด</strong></font></td>
                    <td>&nbsp;</td>
                    <td>
<?php
                    if($oSb->birthDate == '0000-00-00') {
?>
                    <script>DateInput('birthDate', true, 'DD/MM/YYYY','<?php echo getNowDateFw2();?>');</script>
<?php
                    }
                    else {
?>
                    <script>DateInput('birthDate', true, 'DD/MM/YYYY','<?php echo splitDateDb($oSb->birthDate,"/");?>');</script>
<?php
                    }
?>
                    </td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>จังหวัดที่เกิด</strong></font></td>
                    <td>&nbsp;</td>
<?php
                    $oPv->provinceName = '';
                    
                    $oPv->SearchByKey($oSb->birthProvinceId);
                    $oPv->GetRecord();
?>
                    <td><input name="birthProvince" type="text" size="15" value="<?php echo $oPv->provinceName;?>" class="input1">
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("birthProvinceTable.php",400,200)'>
                    <input type="hidden" name="birthProvinceId" value="<?php echo $oSb->birthProvinceId;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>สถานะการสมรส</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="maritalStatusId">
<?php
                        $oMs->SearchByKey($oSb->maritalStatusId);
                        if($oMs->GetRecord()) {
?>
                        <option value="<?php echo $oSb->maritalStatusId;?>"><?php echo $oMs->maritalStatus;?></option>
<?php
                        }
                        else {
?>
                        <option value="">---เลือกสถานภาพการสมรส---</option>
<?php
                        }
                        
                        $oMs->RSMaritalStatus();
                        while($oMs->GetRecord()) {
?>
                        <option value="<?php echo $oMs->maritalStatusId;?>"><?php echo $oMs->maritalStatus;?></option>
<?php
                        }
?>
                    </select></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>น้ำหนัก</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="weight" type="text" onKeyPress="if(event.keyCode < 46 || event.keyCode > 57) return false;" size="3" maxlength="5" value="<?php echo $oSb->weight;?>">
                    <font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">กิโลกรัม</font></td>
                </tr>
                <tr>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>สถานะการเกณฑ์ทหาร</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="recruitmentTypeId" <?php if($oSb->studentSex=='F') { echo 'disabled';}?>>
<?php
                        $oRt->SearchByKey($oSb->recruitmentTypeId);
                        if($oRt->GetRecord()) {
?>
                        <option value="<?php echo $oSb->recruitmentTypeId;?>"><?php echo $oRt->recruitmentType;?></option>
<?php
                        }
                        else {
?>
                        <option value="">---เลือกสถานะการเกณฑ์ทหาร---</option>
<?php
                        }
                        
                        $oRt->RSRecruitmentType();
                        while($oRt->GetRecord()) {
?>
                        <option value="<?php echo $oRt->recruitmentTypeId;?>"><?php echo $oRt->recruitmentType;?></option>
<?php
                        }
?>
                    </select></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ส่วนสูง</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="height" type="text" value="<?php echo $oSb->height;?>" onKeyPress="if(event.keyCode < 46 || event.keyCode > 57) return false;" size="3" maxlength="6">
                    <font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">เซนติเมตร</font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ผลการสอบวิชาชีพ</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="occExamResult" <?php if($oSb->studentStatus!=4) { echo 'disabled'; }?>>
<?php
                        if($oSb->occExamResult=='') {
?>
                        <option value="">---เลือกผลการสอบวิชาชีพ---</option>
<?php
                        }
                        else {
?>
                        <option value="<?php echo $oSb->occExamResult;?>"><?php echo $oSb->occExamResult." : "; if($oSb->occExamResult=='P'){ echo "ผ่าน"; }else if($oSb->occExamResult=='F'){ echo "ไม่ผ่าน"; }?></option>    
<?php
                        }
?>
                        <option value="P">P : ผ่าน</option>
                        <option value="F">F : ไม่ผ่าน</option>    
                    </select></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ผลการสอบ Exit-Exam</strong></font></td>
                    <td>&nbsp;</td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSm->exitExam." : "; if($oSm->exitExam=='N'){ echo "ไม่ผ่าน"; }else if($oSm->exitExam=='Y' || $oSm->exitExam=='P'){ echo "ผ่าน"; }?></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td colspan="6" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>&nbsp;ที่อยู่นักศึกษาตามภูมิลำเนาเดิม</strong></font></td>
                </tr>
                <tr>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ที่อยู่นักศึกษา (ตามภูมิลำเนา)</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><textarea name="homeAddress" cols="30" rows="3"><?php echo nl2br(htmlspecialchars($oSb->homeAddress));?></textarea></td>
                </tr>
<?php
                $oDt->districtName = '';
                $oAm->amphurName = '';
                $oPv->provinceName = '';
                
                $oDt->SearchByKey($oSb->homeDistrictId);
                $oDt->GetRecord();
                $oAm->SearchByKey($oSb->homeAmphurId);
                $oAm->GetRecord();
                $oPv->SearchByKey($oSb->homeProvinceId);
                $oPv->GetRecord();
?>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>ตำบล</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="homeDistrict" type="text" size="20" value="<?php echo $oDt->districtName;?>" class="input2" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("homeDistrictTable.php",550,350)'>
                    <input name="homeDistrictId" type="hidden" value="<?php echo $oSb->homeDistrictId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>อำเภอ</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="homeAmphur" type="text" size="20" value="<?php echo $oAm->amphurName;?>" class="input2" readonly>
                    <input name="homeAmphurId" type="hidden" value="<?php echo $oSb->homeAmphurId;?>"></td>
                </tr>
                <tr>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>จังหวัด</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="homeProvince" type="text" size="20" value="<?php echo $oPv->provinceName;?>" class="input1" readonly>
                    <input name="homeProvinceId" type="hidden" value="<?php echo $oSb->homeProvinceId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>รหัสไปรษณีย์</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="homeZipcode" type="text" value="<?php echo $oSb->homeZipcode;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="5" maxlength="5"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">โทรศัพท์บ้าน</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="homePhoneNo" type="text" value="<?php echo $oSb->homePhoneNo;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="10" maxlength="10"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td colspan="6" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>&nbsp;ที่อยู่ปัจจุบันนักศึกษา</strong></font>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2">**
                    <input type="checkbox" name="currentAddressChk" value="1">ใช้ที่อยู่ปัจจุบันนักศึกษาตามที่อยู่ภูมิลำเนาเดิมนักศึกษา</font></td>
                </tr>
                <tr>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ที่อยู่นักศึกษา (ปัจจุบัน)</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><textarea name="currentAddress" cols="30" rows="3"><?php echo nl2br(htmlspecialchars($oSb->currentAddress));?></textarea></td>
                </tr>
<?php
                $oDt->districtName = '';
                $oAm->amphurName = '';
                $oPv->provinceName = '';
                
                $oDt->SearchByKey($oSb->currentDistrictId);
                $oDt->GetRecord();
                $oAm->SearchByKey($oSb->currentAmphurId);
                $oAm->GetRecord();
                $oPv->SearchByKey($oSb->currentProvinceId);
                $oPv->GetRecord();
?>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>ตำบล</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="currentDistrict" type="text" size="20" value="<?php echo $oDt->districtName;?>" class="input2" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("currentDistrictTable.php",550,350)'>    
                    <input name="currentDistrictId" type="hidden" value="<?php echo $oSb->currentDistrictId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>อำเภอ</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="currentAmphur" type="text" size="20" value="<?php echo $oAm->amphurName;?>" class="input2" readonly>
                    <input name="currentAmphurId" type="hidden" value="<?php echo $oSb->currentAmphurId;?>"></td>
                </tr>
                <tr>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>จังหวัด</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="currentProvince" type="text" size="20" value="<?php echo $oPv->provinceName;?>" class="input1" readonly>
                    <input name="currentProvinceId" type="hidden" value="<?php echo $oSb->currentProvinceId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>รหัสไปรษณีย์</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="currentZipcode" type="text" value="<?php echo $oSb->currentZipcode;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="5" maxlength="5"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">โทรศัพท์บ้าน</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="currentPhoneNo" type="text" value="<?php echo $oSb->currentPhoneNo;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="10" maxlength="10"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td colspan="6" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>&nbsp;ที่อยู่ที่ทำงาน (ในกรณีที่ทำงานอยู่)</strong></font>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2">**
                    <input type="checkbox" name="officeAddressChk" value="1">ใช้ที่อยู่ที่ทำงานตามที่อยู่ภูมิลำเนาเดิมนักศึกษา</font></td>
                </tr>
                <tr>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">ชื่อบริษัท/ที่ทำงาน</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="officeName" type="text" size="20" value="<?php echo $oSb->officeName;?>"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ที่อยู่ที่ทำงาน (ในกรณีที่ทำงานอยู่)</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><textarea name="officeAddress" cols="30" rows="3"><?php echo nl2br(htmlspecialchars($oSb->officeAddress));?></textarea></td>
                </tr>
<?php
                $oDt->districtName = '';
                $oAm->amphurName = '';
                $oPv->provinceName = '';
                
                $oDt->SearchByKey($oSb->officeDistrictId);
                $oDt->GetRecord();
                $oAm->SearchByKey($oSb->officeAmphurId);
                $oAm->GetRecord();
                $oPv->SearchByKey($oSb->officeProvinceId);
                $oPv->GetRecord();
?>
                <tr>
                    <td height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>ตำบล</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="officeDistrict" type="text" size="20" value="<?php echo $oDt->districtName;?>" class="input1" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("officeDistrictTable.php",550,350)'>
                    <input name="officeDistrictId" type="hidden" value="<?php echo $oSb->officeDistrictId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>อำเภอ</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="officeAmphur" type="text" size="20" value="<?php echo $oAm->amphurName;?>" class="input1" readonly>
                    <input name="officeAmphurId" type="hidden" value="<?php echo $oSb->officeAmphurId;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>จังหวัด</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="officeProvince" type="text" size="20" value="<?php echo $oPv->provinceName;?>" class="input2" readonly>
                    <input name="officeProvinceId" type="hidden" value="<?php echo $oSb->officeProvinceId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>รหัสไปรษณีย์</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="officeZipcode" type="text" value="<?php echo $oSb->officeZipcode;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="5" maxlength="5"></td>
                </tr>
                <tr>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>โทรศัพท์ที่ทำงาน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="officePhoneNo" type="text" value="<?php echo $oSb->officePhoneNo;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="10" maxlength="10"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>สถานะการทำงาน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="workingStatus">
<?php
                        if($oSb->workingStatus == 0) {
?>
                        <option value="0">---เลือกสถานะการทำงาน---</option>
<?php
                        }
                        else {
?>
                        <option value="<?php echo $oSb->workingStatus;?>"><?php if($oSb->workingStatus==1){ echo "กำลังทำงานอยู่"; }else if($oSb->workingStatus==2){ echo "ลาศึกษาต่อ"; }else if($oSb->workingStatus==3){ echo "ลาออก"; }?></option>
<?php
                        }
?>
                        <option value="1">ปกติ</option>
                        <option value="2">ลาศึกษาต่อ</option>
                        <option value="3">ลาออก</option>
                    </select></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ตำแหน่งงาน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="workingPosition" type="text" size="20" value="<?php echo $oSb->workingPosition;?>"></td>
                </tr>
                <tr>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>เงินเดือน</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="workingSalary" type="text" size="8" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" value="<?php echo $oSb->workingSalary;?>"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td colspan="6" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>&nbsp;ข้อมูลบิดา-มารดา</strong></font>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2">**
                    <input type="checkbox" name="fatherAddressChk" value="1">ใช้ที่อยู่บิดาตามที่อยู่ภูมิลำเนาเดิมนักศึกษา
                    <input type="checkbox" name="motherAddressChk" value="1">ใช้ที่อยู่มารดาตามที่อยู่ภูมิลำเนาเดิมนักศึกษา</font></td>
                </tr>
                <tr>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">ชื่อบิดา</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="fatherName" type="text" size="20" value="<?php echo $oSb->fatherName;?>"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ที่อยู่บิดา</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><textarea name="fatherAddress" cols="30" rows="3"><?php echo nl2br(htmlspecialchars($oSb->fatherAddress));?></textarea></td>
                </tr>
<?php
                $oDt->districtName = '';
                $oAm->amphurName = '';
                $oPv->provinceName = '';
                
                $oDt->SearchByKey($oSb->fatherDistrictId);
                $oDt->GetRecord();
                $oAm->SearchByKey($oSb->fatherAmphurId);
                $oAm->GetRecord();
                $oPv->SearchByKey($oSb->fatherProvinceId);
                $oPv->GetRecord();
?>
                <tr>
                    <td height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>ตำบล</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="fatherDistrict" type="text" size="20" value="<?php echo $oDt->districtName;?>" class="input1" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("fatherDistrictTable.php",550,350)'>
                    <input name="fatherDistrictId" type="hidden" value="<?php echo $oSb->fatherDistrictId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>อำเภอ</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="fatherAmphur" type="text" size="20" value="<?php echo $oAm->amphurName;?>" class="input1" readonly>
                    <input name="fatherAmphurId" type="hidden" value="<?php echo $oSb->fatherAmphurId;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>จังหวัด</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="fatherProvince" type="text" size="20" value="<?php echo $oPv->provinceName;?>" class="input2" readonly>
                    <input name="fatherProvinceId" type="hidden" value="<?php echo $oSb->fatherProvinceId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>รหัสไปรษณีย์</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="fatherZipcode" type="text" value="<?php echo $oSb->fatherZipcode;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="5" maxlength="5"></td>
                </tr>
                <tr>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">โทรศัพท์บ้าน</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="fatherPhoneNo" type="text" value="<?php echo $oSb->fatherPhoneNo;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="10" maxlength="10"></td>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">อาชีพ</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="fatherOccupation" type="text" size="20" value="<?php echo $oSb->fatherOccupation;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>สถานภาพบิดา</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="fatherStatus">
<?php
                        if($oSb->fatherStatus == 0) {
?>
                        <option value="0">---เลือกสถานภาพบิดา---</option>
<?php
                        }
                        else {
?>
                        <option value="<?php echo $oSb->fatherStatus;?>"><?php if($oSb->fatherStatus==1){ echo "มีชีวิตอยู่"; }else if($oSb->fatherStatus==2){ echo "หย่าร้าง"; }else if($oSb->fatherStatus==3){ echo "ตาย"; }?></option>
<?php
                        }
?>
                        <option value="1">ยังมีชีวิตอยู่</option>
                        <option value="2">หย่าร้าง</option>
                        <option value="3">ตาย</option>
                    </select></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">ชื่อมารดา</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="motherName" type="text" size="20" value="<?php echo $oSb->motherName;?>"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ที่อยู่มารดา</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><textarea name="motherAddress" cols="30" rows="3"><?php echo nl2br(htmlspecialchars($oSb->motherAddress));?></textarea></td>
                </tr>
<?php
                $oDt->districtName = '';
                $oAm->amphurName = '';
                $oPv->provinceName = '';
                
                $oDt->SearchByKey($oSb->motherDistrictId);
                $oDt->GetRecord();
                $oAm->SearchByKey($oSb->motherAmphurId);
                $oAm->GetRecord();
                $oPv->SearchByKey($oSb->motherProvinceId);
                $oPv->GetRecord();
?>
                <tr>
                    <td height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>ตำบล</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="motherDistrict" type="text" size="20" value="<?php echo $oDt->districtName;?>" class="input1" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("motherDistrictTable.php",550,350)'>
                    <input name="motherDistrictId" type="hidden" value="<?php echo $oSb->motherDistrictId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>อำเภอ</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="motherAmphur" type="text" size="20" value="<?php echo $oAm->amphurName;?>" class="input1" readonly>
                    <input name="motherAmphurId" type="hidden" value="<?php echo $oSb->motherAmphurId;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>จังหวัด</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="motherProvince" type="text" size="20" value="<?php echo $oPv->provinceName;?>" class="input2" readonly>
                    <input name="motherProvinceId" type="hidden" value="<?php echo $oSb->motherProvinceId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>รหัสไปรษณีย์</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="motherZipcode" type="text" value="<?php echo $oSb->motherZipcode;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="5" maxlength="5"></td>
                </tr>
                <tr>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">โทรศัพท์บ้าน</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="motherPhoneNo" type="text" value="<?php echo $oSb->motherPhoneNo;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="10" maxlength="10"></td>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">อาชีพ</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="motherOccupation" type="text" size="20" value="<?php echo $oSb->motherOccupation;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>สถานภาพมารดา</strong></font></td>
                    <td>&nbsp;</td>
                    <td><select name="motherStatus">
<?php
                        if($oSb->motherStatus == 0) {
?>
                        <option value="0">---เลือกสถานภาพมารดา---</option>
<?php
                        }
                        else {
?>
                        <option value="<?php echo $oSb->motherStatus;?>"><?php if($oSb->motherStatus==1){ echo "มีชีวิตอยู่"; }else if($oSb->motherStatus==2){ echo "หย่าร้าง"; }else if($oSb->motherStatus==3){ echo "ตาย"; }?></option>
<?php
                        }
?>
                        <option value="1">ยังมีชีวิตอยู่</option>
                        <option value="2">หย่าร้าง</option>
                        <option value="3">ตาย</option>
                    </select></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td colspan="6" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>&nbsp;ข้อมูลผู้ที่สามารถติดต่อได้</strong></font>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2">**
                    <input type="checkbox" name="contactAddressChk" value="1">ใช้ที่อยู่ผู้ที่สามารถติดต่อได้ตามที่อยู่ภูมิลำเนาเดิมนักศึกษา</font></td>
                </tr>
                <tr>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">ชื่อผู้ที่สามารถติดต่อได้</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="contactPerson" type="text" size="20" value="<?php echo $oSb->contactPerson;?>"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ที่อยู่ผู้ที่สามารถติตต่อได้</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><textarea name="contactAddress" cols="30" rows="3"><?php echo nl2br(htmlspecialchars($oSb->contactAddress));?></textarea></td>
                </tr>
<?php
                $oDt->districtName = '';
                $oAm->amphurName = '';
                $oPv->provinceName = '';
                
                $oDt->SearchByKey($oSb->contactDistrictId);
                $oDt->GetRecord();
                $oAm->SearchByKey($oSb->contactAmphurId);
                $oAm->GetRecord();
                $oPv->SearchByKey($oSb->contactProvinceId);
                $oPv->GetRecord();
?>
                <tr>
                    <td height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>ตำบล</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="contactDistrict" type="text" size="20" value="<?php echo $oDt->districtName;?>" class="input1" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("contactDistrictTable.php",550,350)'>
                    <input name="contactDistrictId" type="hidden" value="<?php echo $oSb->contactDistrictId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>อำเภอ</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="contactAmphur" type="text" size="20" value="<?php echo $oAm->amphurName;?>" class="input1" readonly>
                    <input name="contactAmphurId" type="hidden" value="<?php echo $oSb->contactAmphurId;?>"></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>จังหวัด</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="contactProvince" type="text" size="20" value="<?php echo $oPv->provinceName;?>" class="input2" readonly>
                    <input name="contactProvinceId" type="hidden" value="<?php echo $oSb->contactProvinceId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>รหัสไปรษณีย์</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="contactZipcode" type="text" value="<?php echo $oSb->contactZipcode;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="5" maxlength="5"></td>
                </tr>
                <tr>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">โทรศัพท์บ้าน</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="contactPhoneNo" type="text" value="<?php echo $oSb->contactPhoneNo;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="10" maxlength="10"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td colspan="6" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>&nbsp;ข้อมูลที่อยู่นักศึกษาหลังจากเรียนจบแล้ว</strong></font>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2">**
                    <input type="checkbox" name="graduateAddressChk" value="1">ใช้ที่อยู่นักศึกษาหลังจากจบการศึกษาแล้วตามที่อยู่ภูมิลำเนาเดิมนักศึกษา</font></td>
                </tr>
                <tr>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>ที่อยู่นักศึกษา (หลังจากเรียนจบแล้ว)</strong></font></td>
                    <td>&nbsp;</td>
                    <td colspan="4"><textarea name="graduateAddress" cols="30" rows="3"><?php echo nl2br(htmlspecialchars($oSb->graduateAddress));?></textarea></td>
                </tr>
<?php
                $oDt->districtName = '';
                $oAm->amphurName = '';
                $oPv->provinceName = '';
                
                $oDt->SearchByKey($oSb->graduateDistrictId);
                $oDt->GetRecord();
                $oAm->SearchByKey($oSb->graduateAmphurId);
                $oAm->GetRecord();
                $oPv->SearchByKey($oSb->graduateProvinceId);
                $oPv->GetRecord();
?>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TD_4'];?>">
                    <td height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>ตำบล</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="graduateDistrict" type="text" size="20" value="<?php echo $oDt->districtName;?>" class="input2" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("graduateDistrictTable.php",550,350)'>
                    <input name="graduateDistrictId" type="hidden" value="<?php echo $oSb->graduateDistrictId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><b>อำเภอ</b></font></td>
                    <td>&nbsp;</td>
                    <td><input name="graduateAmphur" type="text" size="20" value="<?php echo $oAm->amphurName;?>" class="input2" readonly>
                    <input name="graduateAmphurId" type="hidden" value="<?php echo $oSb->graduateAmphurId;?>"></td>
                </tr>
                <tr>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>จังหวัด</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="graduateProvince" type="text" size="20" value="<?php echo $oPv->provinceName;?>" class="input1" readonly>
                    <input name="graduateProvinceId" type="hidden" value="<?php echo $oSb->graduateProvinceId;?>"></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><strong>รหัสไปรษณีย์</strong></font></td>
                    <td>&nbsp;</td>
                    <td><input name="graduateZipcode" type="text" value="<?php echo $oSb->graduateZipcode;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="5" maxlength="5"></td>
                </tr>
                <tr>
                    <td><strong><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">โทรศัพท์บ้าน</font></strong></td>
                    <td>&nbsp;</td>
                    <td><input name="graduatePhoneNo" type="text" value="<?php echo $oSb->graduatePhoneNo;?>" onKeyPress="if(event.keyCode < 48 || event.keyCode > 57) return false;" size="10" maxlength="10"></td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                </tr>
            </table></div>
            <div class="contentblock" id="tab2">
            <table width="700" border="1" cellspacing="0" cellpadding="0" bordercolor="<?php echo $GLOBALS['COLOR_BORDER_TABLE_1'];?>" align="center">
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_1'];?>">
                    <td colspan="6" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>ข้อมูลการทำกิจกรรม</strong></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td width="130" height="22" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ปีการศึกษา/<br>ภาคเรียน/ชั้นปี</strong></font></td>
                    <td width="130" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ชื่อกิจกรรม/โครงการ</strong></font></td>
                    <td width="160" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>วันที่เข้าร่วม</strong></font></td>
                    <td width="160" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>วันที่สิ้นสุด</strong></font></td>
                    <td width="90" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>การเข้าร่วม<br>ในกิจกรรม</strong></font></td>
                    <td width="30" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ลบ</strong></font></td>
                </tr>
<?php
                $SA = 0;
                $oSa->RSStudentActivityByStIdAndGEAdY($studentId, $oSm->admitAcadYear);
                while($oSa->GetRecord()) {
                    if(($SA%2) == 0)
                        echo "<tr>";
                    else
                        echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
?>
                    <td height="22" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSa->acadYear.'/'.$oSa->semester.'/'.$oSa->classYear;?></font></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSa->activityName;?></font></td>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo abbreDate2($oSa->dateFrom);?></font></td>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo abbreDate2($oSa->dateTo);?></font></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSa->position;?></font></td>
                    <td align="center"><a href="processStudentBio.php?method=deleteStudAct&studentId=<?php echo $oSa->studentId;?>&sequenceId=<?php echo $oSa->sequenceId;?>" onClick="return confirmSubmit('คุณต้องการลบข้อมูลการทำกิจกรรมแน่นอนใช่หรือไม่ ?')"><img src="../picture/deletenew.gif" align="absmiddle" border="0"></a></td>
                </tr>
<?php
                    $SA++;
                }
                
                if($SA == 0) {
?>
                <tr>
                    <td colspan="6" align="center" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">** ไม่ปรากฎรายการข้อมูลการทำกิจกรรมในฐานข้อมูล **</font></td>
                </tr>
<?php
                }
?>
                <tr>
                    <td><input type="text" name="acadYearSa" value="<?php echo $GLOBALS["ACADYEAR_R"];?>" size="3" maxlength="4" onKeyPress="if (event.keyCode < 48 || event.keyCode > 57) return false;">
                    /
                    <select name="semesterSa">
<?php
                        $oSse->SearchByKey($GLOBALS["SEMESTER_R"]);
                        $oSse->GetRecord();
?>
                        <option value="<?php echo $GLOBALS["SEMESTER_R"];?>"><?php echo $oSse->semesterName;?></option>                                        
<?php
                        $oSse->RSSysSemesterDes();
                        while($oSse->GetRecord()) {
?>
                        <option value="<?php echo $oSse->semester;?>"><?php echo $oSse->semesterName;?></option>                                                                                
<?php
                        }
?>                                        
                    </select>/
                    <select name="classYear">
                        <option value="">-ชั้นปี-</option>
<?php
                        $oSsy->RSSysStudentYearDes();
                        while($oSsy->GetRecord()) {
?>
                        <option value="<?php echo $oSsy->studentYear;?>"><?php echo $oSsy->studentYearName;?></option>
<?php                            
                        }
?>                                
                    </select>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font></td>
                    <td><input type="text" name="activityName" size="15">
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font></td>
                    <td align="center"><script>DateInput('dateFromAct', true, 'DD/MM/YYYY','<?php echo getNowDateFw2();?>');</script></td>
                    <td align="center"><script>DateInput('dateToAct', true, 'DD/MM/YYYY','<?php echo getNowDateFw2();?>');</script></td>
                    <td><input type="text" name="position" size="7">
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font></td>
                    <td align="center">-</td>
                </tr>
                <tr>
                    <td colspan="6" align="right"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">รวม <?php echo $SA;?> รายการ</font></td>
                </tr>
            </table></div>
            <div class="contentblock" id="tab3">
            <table width="700" border="1" cellspacing="0" cellpadding="0" bordercolor="<?php echo $GLOBALS['COLOR_BORDER_TABLE_1'];?>" align="center">
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_1'];?>">
                    <td colspan="6" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>ข้อมูลการลา/ขาด</strong></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td width="45" height="22" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ลำดับที่</strong></font></td>
                    <td width="160" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>วันที่เริ่ม</strong></font></td>
                    <td width="160" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>วันที่สิ้นสุด</strong></font></td>
                    <td width="140" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ปีการศึกษา/ชั้นปี</strong></font></td>
                    <td width="165" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ประเภทการลา/ขาด</strong></font></td>
                    <td width="30" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ลบ</strong></font></td>
                </tr>
<?php
                $SAB = 0;
                $oSab->RSStudentAbsentByStIdAndGEAdY($studentId, $oSm->admitAcadYear);
                while($oSab->GetRecord()) {
                    if(($SAB%2) == 0)
                        echo "<tr>";
                    else
                        echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
?>
                    <td height="22" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $SAB+1;?></font></td>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo abbreDate2($oSab->dateFrom);?></font></td>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo abbreDate2($oSab->dateTo);?></font></td>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSab->acadYear.'/'.$oSab->studentYear;?></font></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">
<?php
                    if($oSab->absentCause == 1)
                        echo 'ลาป่วย';
                    else if($oSab->absentCause == 2)
                        echo 'ลากิจ';
                    else if($oSab->absentCause == 3)
                        echo 'ขาดเรียน';
?>
                    </font></td>
                    <td align="center"><a href="processStudentBio.php?method=deleteStudAbs&studentId=<?php echo $oSab->studentId;?>&sequenceId=<?php echo $oSab->sequenceId;?>" onClick="return confirmSubmit('คุณต้องการลบข้อมูลการลา/ขาดแน่นอนใช่หรือไม่ ?')"><img src="../picture/deletenew.gif" align="absmiddle" border="0"></a></td>
                </tr>
<?php
                    $SAB++;
                }
                
                if($SAB == 0) {
?>
                <tr>
                    <td colspan="6" align="center" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">** ไม่ปรากฎรายการข้อมูลการลา/ขาดในฐานข้อมูล **</font></td>
                </tr>
<?php
                }
?>
                <tr>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $SAB+1;?></font></td>
                    <td align="center"><script>DateInput('dateFromAbs', true, 'DD/MM/YYYY','<?php echo getNowDateFw2();?>');</script></td>
                    <td align="center"><script>DateInput('dateToAbs', true, 'DD/MM/YYYY','<?php echo getNowDateFw2();?>');</script></td>
                    <td align="center"><input type="text" name="acadYearSab" value="<?php echo $GLOBALS["ACADYEAR_R"];?>" size="3" maxlength="4" onKeyPress="if (event.keyCode < 48 || event.keyCode > 57) return false;">
                    /
                    <select name="studentYearSab">
                        <option value="">-ชั้นปี-</option>
<?php
                        $oSsy->RSSysStudentYearDes();
                        while($oSsy->GetRecord()) {
?>
                        <option value="<?php echo $oSsy->studentYear;?>"><?php echo $oSsy->studentYearName;?></option>
<?php
                        }
?>
                    </select>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font></td>
                    <td><select name="absentCause">
                        <option value="">--เลือกประเภทการลา/ขาด--</option>
                        <option value="1">ลาป่วย</option>
                        <option value="2">ลากิจ</option>
                        <option value="3">ขาดเรียน</option>
                    </select>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font></td>
                    <td align="center">-</td>
                </tr>
                <tr>
                    <td colspan="6" align="right"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">รวม <?php echo $SAB;?> รายการ</font></td>
                </tr>
            </table></div>
            <div class="contentblock" id="tab4">
            <table width="700" border="1" cellspacing="0" cellpadding="0" bordercolor="<?php echo $GLOBALS['COLOR_BORDER_TABLE_1'];?>" align="center">
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_1'];?>">
                    <td colspan="7" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>ข้อมูลความประพฤติ</strong></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td width="160" height="22" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>วันที่เกิดเหตุการณ์</strong></font></td>
                    <td width="150" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ปี/ภาคการศึกษา</strong></font></td>
                    <td width="80" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>รายละเอียด</strong></font></td>
                    <td width="90" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ระดับคะแนน</strong></font></td>
                    <td width="40" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>คะแนน<br>ที่ตัด</strong></font></td>
                    <td width="160" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>วันที่อนุมัติ</strong></font></td>
                    <td width="20" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ลบ</strong></font></td>
                </tr>
<?php        
                $SBE = 0;
                $oSbe->RSStudentBehaviorByStIdAndGEAdY($studentId, $oSm->admitAcadYear);
                while($oSbe->GetRecord()) {
                    $oDs->SearchByKey($oSbe->disciplineId);
                    $oDs->GetRecord();
                    
                    if(($SBE%2) == 0)
                        echo "<tr>";
                    else
                        echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
?>
                    <td height="22" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo abbreDate2($oSbe->recordDate);?></font></td>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSbe->acadYear.'/'.$oSbe->semester;?></font></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSbe->description;?></font></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oDs->levelNo.' : '.$oDs->disciplineName;?></font></td>
                    <td align="right"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSbe->cutPoint; ?></font></td>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo abbreDate2($oSbe->approveDate);?></font></td>
                    <td align="center"><a href="processStudentBio.php?method=deleteStudBeh&studentId=<?php echo $oSbe->studentId;?>&sequenceId=<?php echo $oSbe->sequence;?>" onClick="return confirmSubmit('คุณต้องการลบข้อมูลความประพฤติแน่นอนใช่หรือไม่ ?')"><img src="../picture/deletenew.gif" align="absmiddle" border="0"></a></td>
                </tr>
<?php
                    $SBE++;
                }
                
                if($SBE == 0) {
?>
                <tr>
                    <td colspan="7" align="center" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">** ไม่ปรากฎรายการข้อมูลความประพฤติในฐานข้อมูล **</font></td>
                </tr>
<?php
                }
?>
                <tr>
                    <td align="center"><script>DateInput('recordDate', true, 'DD/MM/YYYY','<?php echo getNowDateFw2();?>');</script></td>
                    <td align="center"><input type="text" name="acadYearSbe" value="<?php echo $GLOBALS["ACADYEAR_R"];?>" size="3" maxlength="4" onKeyPress="if (event.keyCode < 48 || event.keyCode > 57) return false;">
                    /
                    <select name="semesterSbe">
<?php
                        $oSse->SearchByKey($GLOBALS["SEMESTER_R"]);
                        $oSse->GetRecord();
?>
                        <option value="<?php echo $GLOBALS["SEMESTER_R"];?>"><?php echo $oSse->semesterName; ?></option>                                        
<?php
                        $oSse->RSSysSemesterDes();
                        while($oSse->GetRecord()) {
?>
                        <option value="<?php echo $oSse->semester;?>"><?php echo $oSse->semesterName;?></option>                                                                                
<?php
                        }
?>                                                                                
                    </select>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font></td>
                    <td><input type="text" name="description" size="6">
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font></td>
                    <td><input type="text" name="disciplineName" class="input1" size="6" readonly>
                    <IMG src="../picture/search.gif" width="15" height="19" border="0" align="absmiddle" id=IMG3 style="CURSOR: hand" onclick='OpenWindow("disciplineTable.php",500,300)'>
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font>
                    <input type="hidden" name="disciplineId"></td>
                    <td><input type="text" name="cutPoint" size="1" class="input1" readonly></td>
                    <td align="center"><script>DateInput('approveDate', true, 'DD/MM/YYYY','<?php echo getNowDateFw2();?>');</script></td>
                    <td align="center">-</td>
                </tr>
                <tr>
                    <td colspan="7" align="right"><font size="2" color="<?php echo $GLOBALS['COLOR_FONT_4'];?>">รวม <?php echo $SBE;?> รายการ</font></td>
                </tr>
            </table></div>
            <div class="contentblock" id="tab6">
            <table width="700" border="1" cellspacing="0" cellpadding="0" bordercolor="<?php echo $GLOBALS['COLOR_BORDER_TABLE_1'];?>" align="center">
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_1'];?>">
                    <td colspan="5" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="3"><strong>ข้อมูลการรับรางวัล</strong></font></td>
                </tr>
                <tr bgcolor="<?php echo $GLOBALS['COLOR_BG_TABLE_2'];?>">
                    <td width="30" height="22" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ที่</strong></font></td>
                    <td width="160" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>วันที่รับรางวัล</strong></font></td>
                    <td width="240" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>รางวัล</strong></font></td>
                    <td width="240" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>รายละเอียด</strong></font></td>
                    <td width="30" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_1'];?>" size="2"><strong>ลบ</strong></font></td>
                </tr>
<?php
                $SR = 0;
                $oSr->RSStudentRewardByStId($studentId);
                while($oSr->GetRecord()) {
                    if(($SR%2) == 0)
                        echo "<tr>";
                    else
                        echo "<tr bgcolor=\"".$GLOBALS["COLOR_BG_TABLE_3"]."\">";
?>
                    <td height="22" align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $SR+1;?></font></td>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo abbreDate2($oSr->receiveDate);?></font></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSr->reward;?></font></td>
                    <td><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $oSr->description;?></font></td>
                    <td align="center"><a href="processStudentBio.php?method=deleteStudRe&studentId=<?php echo $oSr->studentId;?>&sequenceId=<?php echo $oSr->sequence;?>" onClick="return confirmSubmit('คุณต้องการลบข้อมูลการรับรางวัลแน่นอนใช่หรือไม่ ?')"><img src="../picture/deletenew.gif" align="absmiddle" border="0"></a></td>
                </tr>
<?php
                    $SR++;
                }
                
                if($SR == 0) {
?>
                <tr>
                    <td colspan="5" align="center" height="22"><font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">** ไม่ปรากฎรายการข้อมูลการรับรางวัลในฐานข้อมูล **</font></td>
                </tr>
<?php
                }
?>
                <tr>
                    <td align="center"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2"><?php echo $SR+1;?></font></td>
                    <td align="center"><script>DateInput('receiveDate', true, 'DD/MM/YYYY','<?php echo getNowDateFw2();?>');</script></td>
                    <td><input type="text" name="reward" size="30">
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font></td>
                    <td><input type="text" name="descriptionReward" size="30">
                    <font color="<?php echo $GLOBALS['COLOR_FONT_3'];?>" size="2">*</font></td>
                    <td align="center">-</td>
                </tr>
                <tr>
                    <td colspan="5" align="right"><font color="<?php echo $GLOBALS['COLOR_FONT_4'];?>" size="2">รวม <?php echo $SR;?> รายการ</font></td>
                </tr>
            </table></div><br>
            <input type="submit" name="edit" value="บันทึก" onClick="if(checkFormat(new Array(this.form.birthDate.value, this.form.dateFromAct.value, this.form.dateFromAbs.value, this.form.recordDate.value, this.form.receiveDate.value), new Array('<?php echo getNowDateFw2();?>', this.form.dateToAct.value, this.form.dateToAbs.value, this.form.approveDate.value, '<?php echo getNowDateFw2();?>'))) return confirmSubmit('คุณต้องการแก้ไขข้อมูลประวัตินักศึกษาในปัจจุบันหรือไม่ ?'); else return false;">
            <input type="reset" name="clear" value="เคลียร์ข้อมูล">
            <input type="button" name="cancel" value="ยกเลิก" onClick="location.href = 'searchStudent.php'">
            <input type="button" name="back" value="กลับเมนูหลัก" onClick="location.href = 'adminIndex.php?mm=1'">
            <input type="hidden" name="method" value="edit">
            <input type="hidden" name="adY" value="<?php echo $oSm->admitAcadYear;?>">
            </div></form></div></label>
        </fieldset><br></td>
    </tr>
</table>
</body>
<?php
$oSm->Destroy();
$oSb->Destroy();
$oPf->Destroy();
$oLv->Destroy();
$oPg->Destroy();
$oSs->Destroy();
$oGe->Destroy();
$oSc->Destroy();
$oPv->Destroy();
$oEt->Destroy();
$oEt2->Destroy();
$oDt->Destroy();
$oAm->Destroy();
$oSf->Destroy();
$oPp->Destroy();
$oHp->Destroy();
$oDg->Destroy();
$oNt->Destroy();
$oRg->Destroy();
$oMs->Destroy();
$oRt->Destroy();
$oSa->Destroy();
$oSse->Destroy();
$oSsy->Destroy();
$oSab->Destroy();
$oSbe->Destroy();
$oDs->Destroy();
$oSr->Destroy();
$conn->Disconnect();
showFooter();
?>

:: Command execute ::

Enter:
 
Select:
 

:: Shadow's tricks :D ::

Useful Commands
 
Warning. Kernel may be alerted using higher levels
Kernel Info:

:: Preddy's tricks :D ::

Php Safe-Mode Bypass (Read Files)

File:

eg: /etc/passwd
Php Safe-Mode Bypass (List Directories):

Dir:

eg: /etc/

:: Search ::
  - regexp 
:: Upload ::
 
[ ok ]

:: Make Dir ::
 
[ ok ]
:: Make File ::
 
[ ok ]

:: Go Dir ::
 
:: Go File ::
 

--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0263 ]--