Viewing file: AllDetail.php (12.44 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php session_start(); if (session_is_registered("valid_user")&&session_is_registered("password")&&session_is_registered("Priority")) { $Username = $valid_user; $Password = $password; include("../../include/FunctionDB.php"); include("../../include/Function.php"); ConnectDB(); $sql = "Select * From user_tb Where Username='$Username'"; $result = mysql_query($sql) or die(" Error".mysql_error()); $rs1 = mysql_fetch_array($result); $Username = $rs1[Username]; $sql1 = "Select * From student_tb Where Student_id='$Student_id'"; $result1 = mysql_query($sql1) or die(" Error".mysql_error()); $rs = mysql_fetch_array($result1); ?> <html> <head> <title>All Student Detail </title> <meta http-equiv="Content-Type" content="text/html; charset=windows-874"> <link href="../../css/style1.css" rel="stylesheet" type="text/css"> <script language="JavaScript" type="text/JavaScript"> <!--
function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } //--> </script> </head>
<body bgcolor="#EDFAFE"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="26"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1"> <tr> <td width="20%" background="../../Image/bare3.jpg" class="table"> <div align="center"><strong><font size="2" face="Tahoma"><a href="../Menu_Std_Acc.php" class="d">กลับหน้าหลัก</a></font></strong></div></td> <td width="20%" background="../../Image/bare3.jpg" class="table"> <div align="center" ><strong><font size="2" face="Tahoma"><a href="../../logout.php" class="d">Logout</a></font></strong></div></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td> </td> </tr> <tr> <td bgcolor="#AFCFEF"> <div align="center"><font size="4" face="Tahoma"><strong>ประวัตินักศึกษา</strong></font></div></td> </tr> <tr> <td> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#EAEAEA" style="border:1px solid gray"> <tr bgcolor="#FFFFFF"> <td width="33%" bgcolor="#FFFEF4"> <div align="center"><strong><font color="#003300" size="2" face="Tahoma">รหัส</font></strong></div></td> <td width="67%" bgcolor="#FFFEF4"><font color="#003300" size="2" face="Tahoma"> <?=$rs["Student_id"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td bgcolor="#FFFEF4"> <div align="center"><strong><font color="#003300" size="2" face="Tahoma">ชื่อ-นามสกุล</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#003300" size="2" face="Tahoma"> <strong> <?=$rs["First_name"]?> <?=$rs["Name"]?> <?=$rs["Lastname"]?> </strong> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td bgcolor="#FFFEF4"> <div align="center"><strong><font color="#003300" size="2" face="Tahoma">หลักสูตร</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#003300" size="2" face="Tahoma"> <?php $Course_code = $rs["Course_code"]; $sql2= "Select * From course_tb Where Course_code='$Course_code'"; $result2 = mysql_query($sql2) or die("Error Select".mysql_query()); $rs2 = mysql_fetch_array($result2); echo"$rs2[Course_name]"; ?> รุ่น </font><font color="#990099" size="2" face="Tahoma"> <?=$rs["Class"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td bgcolor="#FFFEF4"><div align="center"><strong><font color="#003300" size="2" face="Tahoma">วัน/เดือน/ปีเกิด</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#003366" size="2" face="Tahoma"> <?php $year = $rs[DateBirth]; $yearthai = explode("-",$year); $day = intval($yearthai[2]); $month = intval($yearthai[1]); $year = intval($yearthai[0]); $yearthai = $year ; $month = TxtThaiMonth($month); echo"<font color=\"#000000\">วันที่ </font>"."$day"." <font color=\"#000000\"> เดือน </font>"."$month"."<font color=\"#000000\"> ปี พ.ศ. </font>"."$yearthai"; ?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td bgcolor="#FFFEF4"><div align="center"><strong><font color="#000000" size="2" face="Tahoma">เพศ</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Sex"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td bgcolor="#FFFEF4"> <div align="center"><strong><font size="2" face="Tahoma">อายุ</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#003366" size="2" face="Tahoma"> <?php //// Show Age $age = $rs[DateBirth]; $year = explode("-",$age); $year = intval($year[0]); $year = $year - 543; $currentyear = date("Y"); // $currentyear = intval($currentyear[0]); $age = $currentyear - $year ; echo"$age"; ?> </font><font color="#000000" size="2" face="Tahoma">ปี</font></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font size="2" face="Tahoma">อาจารย์ที่ปรึกษา</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#003300" size="2" face="Tahoma"> <strong> อ.</strong> <a href="../../edu_depart/Teacher/Spe_Tech_History.php?Teacher_code=<? echo $rs[Teacher_code]?>" class="d"> <?php $Teacher_code = $rs[Teacher_code]; $sql3= "Select * From personal_tb Where Teacher_code='$Teacher_code'"; $result3 = mysql_query($sql3) or die("Error Select".mysql_query()); $rs3 = mysql_fetch_array($result3); echo"$rs3[Teacher_name] $rs3[Teacher_lastname]"; ?> </a></font></td> </tr> <tr bgcolor="#EDFAFE"> <td height="16" colspan="2"> <div align="center"><font size="3" face="Tahoma"><strong>ข้อมูลปกครอง</strong></font></div></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font size="2" face="Tahoma">ชื่อบิดา</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Father_name"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font size="2" face="Tahoma">ชื่อมารดา</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Mother_name"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font size="2" face="Tahoma">ที่อยู่</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Address2"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font size="2" face="Tahoma">เบอร์โทรติดต่อ</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Telno"]?> </font></td> </tr> <tr bgcolor="#EDFAFE"> <td height="16" colspan="2"> <div align="center"><font size="3" face="Tahoma"><strong>ข้อมูลสุขภาพ</strong></font></div></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font color="#000000" size="2" face="Tahoma">ข้อมูลสุขภาพ</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> น้ำหนัก <?=$rs["Weight"]?> ส่วนสูง <?=$rs["Height"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font size="2" face="Tahoma">โรคประจำตัว</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Disease"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font size="2" face="Tahoma">วิธีการรักษา</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Treat"]?> </font></td> </tr> <tr bgcolor="#EDFAFE"> <td height="16" colspan="2"> <div align="center"><font size="3" face="Tahoma"><strong>ข้อมูลการศึกษา</strong></font></div></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font color="#000000" size="2" face="Tahoma">สถาบันก่อนเข้าศึกษา</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Pre_inst"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font color="#000000" size="2" face="Tahoma">G.P.A ก่อนเข้าการศึกษา</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Pre_gpa"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td height="18" bgcolor="#FFFEF4"> <div align="center"><strong><font color="#000000" size="2" face="Tahoma">วิธีเข้ารับการศึกษา</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Select_Method"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td bgcolor="#FFFEF4"> <div align="center"><strong><font size="2" face="Tahoma">วันที่เข้ารับการศึกษา</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Date_in"]?> </font></td> </tr> <tr bgcolor="#EDFAFE"> <td colspan="2"> <div align="center"><font color="#000000" size="2" face="Tahoma"><strong>ข้อมูลนักศึกษา</strong></font></div></td> </tr> <tr bgcolor="#FFFFFF"> <td rowspan="2" bgcolor="#FFFEF4"><div align="center"><strong><font size="2" face="Tahoma">ที่อยู่ /ที่พัก ปัจจุบัน</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Coll_in"]?> <?=$rs["Coll_out"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <?=$rs["Address_cur"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td rowspan="2" bgcolor="#FFFEF4"><div align="center"><strong><font size="2" face="Tahoma">การเข้าร่วมกิจกรรม/ชมรม</font></strong></div></td> <td bgcolor="#FFFEF4"><font color="#000000" size="2" face="Tahoma"> <strong>ทำหน้าที่ :</strong> <?=$rs["Circle_duty"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td bgcolor="#FFFEF4"><font size="2" face="Tahoma"><strong>ชมรม :</strong></font> <font color="#000000" size="2" face="Tahoma"> <?=$rs["Circle"]?> </font></td> </tr> <tr bgcolor="#FFFFFF"> <td bgcolor="#FFFEF4"> </td> <td bgcolor="#FFFEF4"> </td> </tr> </table></td> </tr> <tr> <td bgcolor="#AFCFEF"> </td> </tr> </table> </body> </html> <?php } else { echo"<body bgcolor=\"#CCCCCC\">"; echo"<meta http-equiv=\"refresh\" content=\"3;URL=../logout.php\" target=\"mainFrame\">\n"; echo"<center>"; echo"<br><br><br><b><font face=\"Tahoma\" size=\"4\" color=\"#FF0000\">Please Login</font> </b><br>"; echo"<br><br><font face=\"Tahoma\" size=\"10\" color=\"#000000\"> ERROR 404 PERMISION DENY</font><br>"; echo"<br><font face=\"Tahoma\" size=\"4\" color=\"#000000\"> คุณไม่มีสิทธ์ใช้งาน</font>"; echo"</center>"; echo"</body>"; } ?>
|