<?php

    session_start
();
    
    
/**  Define Validate Access  */
    
define'_VALID_ACCESS');

    
/**  Check Session User Login  */
    
if( !session_is_registered("valid_user") && !session_is_registered("Priority") ) {
        echo 
"<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
        echo 
"<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
        echo 
"<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
        exit();
    } 
    else {
        
/**  Configuration  */
        
require_once( "../configuration.php" );
        require_once( 
$_Config_absolute_path "/includes/framework.php" );
        require_once( 
"../include/Function.php" );
    
        
/**  Create Database Object  */
        
$dbObj = new DBConn;
        
        
/**  Config Table for This Page  */
        
$myTable "personal_tb";
        
        
$Username $valid_user;

        
$query " SELECT *  FROM $myTable  WHERE Username='$Username' ";
        
$result $dbObj->execQuery($query);
        
$rs $dbObj->fetchArray($result);
        
    } 
# else
 
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="../css/default.css" rel="stylesheet" type="text/css" />
<title>ข้อมูลประวัติส่วนตัว - ข้อมูลประวัติการศึกษา</title>
</head>

<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
    
include("../templates/incHeader.php");
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="203" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>
    <td width="800" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset>
      <table width="780" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="5"></td>
      </tr>
      <tr>
        <td height="30" background="../images/background/bg-head-topic-w780.gif" class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>&raquo;</strong> <strong><a href="Menu_History.php?Teacher_code=<?=$Teacher_code;?>">ข้อมูลประวัติส่วนตัว</a> &raquo;</strong><strong class="NOTE"> ข้อมูลประวัติการศึกษา</strong></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td height="385" align="center" valign="top">
            <table width="92%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#EEEEEE" style="border:0px solid gray">
                      <tr bordercolor="#E7FAFE" bgcolor="#E7FAFE">
                        <td width="160" height="20" align="right" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF">วุฒิการศึกษาสูงสุด</td>
                        <td width="10" nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>
                        <td width="544" nowrap="nowrap" bgcolor="#FFFFFF" class="TEXT-DARK-BLUE10"><?php
                            $Degree_code 
$rs["Degree_code"];
                            
$sql2 " Select * From degree_tb  Where Degree_code ='$Degree_code' ";
                            
$result2 mysql_query($sql2);
                            
$row2 mysql_fetch_array($result2);
                                echo 
"$row2[Degree_name]";
                            
mysql_free_result($result2);
                         
?></td>
                      </tr>
                      <?php if( $rs["Degree_His1"] != "" ) { ?>
                      <tr bordercolor="#E7FAFE" bgcolor="#E7FAFE">
                        <td height="20" align="right" valign="top" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="PADDING-TOP-5">ปริญญาตรี</td>
                        <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>
                        <td nowrap="nowrap" bgcolor="#FFFFFF" class="PADDING-TOP-3"><table width="100%" border="0" cellspacing="1" cellpadding="1" class="TEXT-DARK-BLUE10">
                          <tr>
                            <td><?php echo $rs["Degree_His1"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Degree_His1_Major"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Degree_His1_Institute"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Degree_His1_End_Year"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Type_degree1"] ;?></td>
                          </tr>
                        </table></td>
                      </tr>
                      <?php #if ?>
                      <?php if( $rs["Degree_His2"] != "" ) { ?>
                      <tr bordercolor="#E7FAFE" bgcolor="#E7FAFE">
                        <td height="20" align="right" valign="top" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="PADDING-TOP-5">ปริญญาโท</td>
                        <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>
                        <td nowrap="nowrap" bgcolor="#FFFFFF" class="PADDING-TOP-3"><table width="100%" border="0" cellspacing="1" cellpadding="1" class="TEXT-DARK-BLUE10">
                          <tr>
                            <td><?php echo $rs["Degree_His2"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Degree_His2_Major"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Degree_His2_Institute"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Degree_His2_End_Year"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Type_degree2"] ;?></td>
                          </tr>
                        </table></td>
                      </tr>
                      <?php #if ?>
                      <?php if( $rs["Degree_His3"] != "" ) { ?>
                      <tr bordercolor="#E7FAFE" bgcolor="#E7FAFE">
                        <td height="20" align="right" valign="top" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="PADDING-TOP-5">ปริญญาเอก</td>
                        <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>
                        <td nowrap="nowrap" bgcolor="#FFFFFF" class="PADDING-TOP-3"><table width="100%" border="0" cellspacing="1" cellpadding="1" class="TEXT-DARK-BLUE10">
                          <tr>
                            <td><?php echo $rs["Degree_His3"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Degree_His3_Major"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Degree_His3_Institute"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Degree_His3_End_Year"] ;?></td>
                          </tr>
                          <tr>
                            <td><?php echo $rs["Type_degree3"] ;?></td>
                          </tr>
                        </table></td>
                      </tr>
                      <?php #if ?>
                      <tr bordercolor="#FFFFFF" bgcolor="#ECF5FF">
                        <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>
                        <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>
                        <td nowrap="nowrap" bgcolor="#FFFFFF">&nbsp;</td>
                      </tr>
                      <tr bordercolor="#FFFFFF" bgcolor="#ECF5FF">
                        <td nowrap="nowrap" bgcolor="#FFFFFF" align="center">&nbsp;</td>
                        <td nowrap="nowrap" bgcolor="#FFFFFF" align="center">&nbsp;</td>
                        <td height="30" align="left" nowrap="nowrap" bgcolor="#FFFFFF"><input name="btnEdit" type="button" id="btnEdit" onclick="location.href='Frm_Edit_Edu.php?Teacher_code=<?=$Teacher_code;?>'" class="WIDTH80 CURSOR-HAND" value="แก้ไขข้อมูล" />
&nbsp;
<input name="btnBack" type="button" id="btnBack" onclick="location.href='Menu_History.php'" class="WIDTH150 CURSOR-HAND" value="กลับหน้าหลักประวัติส่วนตัว" /></td>
                      </tr>
                    </table>
       </td>
      </tr>
    </table>
   </fieldset></td>
  </tr>
</table>
<?php include("../templates/incFooter.php"); ?>
</body>
</html>
<?php
    
/**  Free Resource */
    
$dbObj->freeresult($result);
    
    
/**  Close the Database  */
    
$dbObj->disconn();
    
    
/**  Unset Class  */
    
unset($dbObj);
?>