Viewing file: PersnalEduDetail.php (13.59 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php session_start(); if (session_is_registered("valid_user")&&session_is_registered("Priority")&&session_is_registered("password") ) { include("../include/FunctionDB.php"); include("admin_menu.php"); include("../include/Function.php"); ConnectDB(); $sql = " SELECT * FROM persnal_project_tb Where Persnal_code='$Persnal_code' "; $result = mysql_query($sql) or die("Select Has Error").mysql_error(); $rs = mysql_fetch_array($result); ?> <meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<table width="835" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="835" ><br> <fieldset> <legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="Edu_Menu.php">หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="AddProjectedu.php? Project_code=<? echo $rs[ Project_code]?>">เพิ่มข้อมูลโครงการ</a></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="Menu_Course.php"></a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="ProjectEduList.php?Project_code=<? echo $rs[ Project_code]?>">ข้อมูลโครงการ</a></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>">รายละเอียดโครงการ</font></legend> <label> <form id="form1" name="form1" method="post" action="InsertCourse.php"> <table width="93%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#E4E4E4" style="border:0px solid gray"> <!--DWLayoutTable--> <tr bgcolor="#CEE6FF"> <td colspan="3"><div align="center" class="style18"><font color="#FFFFFF" face="Tahoma"><font color="#003366" size="2">แสดงรายละเอียดผู้สมัคร</font></font></div></td> </tr> <tr bordercolor="#E7FAFE"> <td width="141" height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font color="#003300" size="2" face="Tahoma">เลขที่บัตรประชาชน</font></div> </div></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo $rs["citizenId"]?> </font> <font size="2" face="Tahoma"><font face="Tahoma">เลขที่สมัคร </font></font><font color="#003366" size="2" face="Tahoma"><? echo $rs["Code_no"]?></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font color="#003300" size="2" face="Tahoma">สถานะการเงิน</font></div> </div></td> <td bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"> <?php $Persnal_code = $rs["Persnal_code"]; $str = "Select * From persnal_project_tb Where Persnal_code='$Persnal_code' "; $res_p = mysql_query($str) or die("Error".mysql_error()); $res1 = mysql_fetch_array($res_p); if (!(strcmp("$res1[Flag]","2"))) { echo"<img src=\"../picture/close.gif\" width=\"13\" height=\"11\" align=\"absmiddle\" border=\"0\"> <font face=\"Tahoma\" size=\"2\" color=\"#0000FF\">ยังไม่ชำระเงิน</font>"; } else if (!(strcmp("$res1[Flag]","1"))) { echo"<img src=\"../picture/open.gif\" width=\"13\" height=\"11\" align=\"absmiddle\" border=\"0\"><font face=\"Tahoma\" size=\"2\" color=\"#0000FF\">่ ชำระเงินแล้ว</font>"; } else if (!(strcmp("$res1[Flag]","1"))) { echo"<img src=\"../picture/open.gif\" width=\"10\" height=\"10\" align=\"absmiddle\" border=\"0\"> ชำระเงินแล้ว"; } ?> </font><font color="#003366" size="2" face="Tahoma"> จำนวนเงิน <? echo $rs["Amount"]?> บาท ห้องพัก <font color="#003366" size="2" face="Tahoma"><? echo $rs["Room"]?></font></font></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font color="#003300" size="2" face="Tahoma">ชื่อ-นามสกุล</font></div> </div></td> <td width="7" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td width="623" bgcolor="#EEEEEE"><font size="2" face="Tahoma"><a href="PersnalEduDetail.php?Persnal_code=<?=$row["Persnal_code"]?>"title="Click to see Detail" class="d" ><? echo $rs["First_name"]?></a></font><font color="#003366" size="2" face="Tahoma"> <? echo $rs["Name"] ?> <? echo $rs["Last_name"] ?> </font></td> </tr> <tr bordercolor="#FFFFFF"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font size="2" face="Tahoma">ตำแหน่งทางราชการ</font></div> </div></td> <td width="7" nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td width="623" nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo $rs["Work"] ?></font></td> </tr> <tr bordercolor="#FFFFFF"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font size="2" face="Tahoma">สถานที่ปฏิบัติงาน</font></div> </div></td> <td width="7" nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td width="623" nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo $rs["Addwork"] ?></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><font size="2" face="Tahoma">พักคู่กับ</font></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo $rs["Addname"] ?> </font><font size="2" face="Tahoma"> หัองพัก </font><font color="#003366" size="2" face="Tahoma"><? echo $rs["Class"] ?></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font size="2" face="Tahoma">จบหลักสูตร</font></div> </div></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <?php $programId = $rs["programId"]; $sql = "Select * From program Where programId='$programId ' "; $result2= mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result2); echo "$rss[programName] "; ?> </font></font><font color="#003366" size="2" face="Tahoma"> </font><font size="2" face="Tahoma">รุ่น </font><font color="#003366" size="2" face="Tahoma"><? echo nl2br($rs["Code"])?></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font size="2" face="Tahoma">จากวิทยาลัย</font></div> </div></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <?php $collegeCode = $rs["collegeCode"]; $sql = "Select * From college Where collegeCode='$collegeCode' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[collegeName] "; ?> </font></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="left"><span class="style16 style17"><span class="style15 style16"><font size="2" face="Tahoma"><font color="#003300" size="2" face="Tahoma">สถานที่ติดต่อ</font></span></span></div></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="28" colspan="3"><span class="style16"><font size="2" face="Tahoma">ที่อย</font></span><font size="2" face="Tahoma">ู่</font><font color="#003366" size="2" face="Tahoma"> <? echo nl2br($rs["Address"])?></font></td> </tr> <tr> <td width="38%"><span class="style16"><font size="2" face="Tahoma">อำเภอ </font></span><font color="#003366" size="2" face="Tahoma"><? echo nl2br($rs["Amper"])?></font></td> <td width="34%"><span class="style16"><font size="2" face="Tahoma">จังหวัด </font></span><font size="2" face="Tahoma"><font size="2" face="Tahoma"> <?php $ProvinceId = $rs["ProvinceId"]; $sql = "Select * From province Where ProvinceId ='$ProvinceId' "; $result1 = mysql_query($sql) or die("Error".mysql_error()); $rss = mysql_fetch_array($result1); echo "$rss[ProvinceName] "; ?> </font></font></td> <td width="28%"><font size="2" face="Tahoma"><font face="Tahoma">รหัสไปรษณีย์ </font><font color="#003366" size="2" face="Tahoma"><? echo nl2br($rs["Zipcode"])?></font></font></td> </tr> </table></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font color="#000000" size="2" face="Tahoma">โทรศัพท</font><font color="#000000" face="Tahoma">์</font></div> </div></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo $rs["Phone"]?></font> <font color="#003366" size="2" face="Tahoma"> เมล์ <? echo $rs["Email"]?></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font size="2" face="Tahoma">อายุ</font></div> </div></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo $rs["Age"]?> </font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><font size="2" face="Tahoma">ประวัติการศึกษา</font></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo $rs["Education"]?></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><font size="2" face="Tahoma">สาขา</font></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo $rs["Education_1"]?></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><div align="center" class="style15"> <div align="left"><font size="2" face="Tahoma">จบจากสถานศึกษา</font></div> </div></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo $rs["Education_2"]?></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><font size="2" face="Tahoma">หมายเหตุ</font></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo nl2br($rs["Detail"])?></font></td> </tr> <tr bordercolor="#E7FAFE"> <td height="20" nowrap="nowrap" bordercolor="#FFFFFF" bgcolor="#ECF5FF"><font size="2" face="Tahoma">การชำระเงินโดย</font></td> <td nowrap="nowrap" bgcolor="#EEEEEE"><!--DWLayoutEmptyCell--> </td> <td nowrap="nowrap" bgcolor="#EEEEEE"><font color="#003366" size="2" face="Tahoma"><? echo nl2br($rs["Bank"])?></font></td> </tr> <tr bgcolor="#CEE6FF"> <td height="25" colspan="3"><!--DWLayoutEmptyCell--> </td> </tr> </table> </form> </fieldset> <br> <font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> <br /> Y คือห้องพักคู่ N คือห้องพักเดี่ยว <br /> ค่าห้องพัก Tower wing ราคา 4050 บาท <br /> ค่าห้องพัก Ocean wing ราคา 4500 บาท <br> </font></td> </tr> </table> <?php } else { echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n"; echo"Please Login "; } ?>
|