
<?php
   include("../../Include/FunctionDB.php");
   include("../../include/Function.php");
   ConnectDB();
   $sql = "Select * From student_tb Where Student_id='$Student_id'";
   $result = mysql_query($sql) or die("Error".mysql_error());
   $rs = mysql_fetch_array($result);
?>
<html>
<head>
<title>Add Student Problem</title>
<link rel="stylesheet" href="../../css/style1.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
</head>

<body bgcolor="#FFFFFF">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#006699">
  <tr bgcolor="#B8ECB3"> 
    <td colspan="4"> <div align="center"><strong><font color="#003366" size="4" face="Tahoma">แบบบันทึกปัญหาของนักศึกษา</font></strong></div></td>
  </tr>
  <form action="InsertAdvice.php" method="post">
    <tr bgcolor="#EEEEEE"> 
      <td><div align="center"><font color="#003366" size="2" face="Tahoma">รหัสนักศึกษา</font></div></td>
      <td bordercolor="#006699">&nbsp;</td>
      <td colspan="2" bordercolor="#006699"><strong><font color="#993333" size="2" face="Tahoma"><? echo $rs[Student_id]?>&nbsp;</font></strong></td>
    </tr>
    <tr bgcolor="#EEEEEE"> 
      <td width="26%"> <div align="center"><font color="#003366" size="2" face="Tahoma">ชื่อ</font></div></td>
      <td width="2%" bordercolor="#006699">&nbsp;</td>
      <td colspan="2" bordercolor="#006699"><font size="2" face="Tahoma"><? echo $rs[First_name]?> 
        <? echo $rs[Name]?>&nbsp;<? echo $rs[Lastname]?> </font></td>
    </tr>
    <tr bgcolor="#EEEEEE"> 
      <td><div align="center"><font color="#003366" size="2" face="Tahoma">ปัญหา</font></div></td>
      <td bordercolor="#006699">&nbsp;</td>
      <td colspan="2" bordercolor="#006699"><font size="2" face="Tahoma"> 
        <input type="radio" name="Problem" value="1">
        มี 
        <input type="radio" name="Problem" value="0">
        ไม่มี</font></td>
    </tr>
    <tr bgcolor="#EEEEEE"> 
      <td rowspan="5" bgcolor="#EEEEEE"> <div align="center"><font color="#003366" size="2" face="Tahoma">ประเภทปัญหา</font></div></td>
      <td bordercolor="#006699">&nbsp;</td>
      <td bordercolor="#006699" bgcolor="#EEEEEE">&nbsp;</td>
      <td bordercolor="#006699"><div align="center"><font size="2" face="Tahoma">รายละเอียดปัญหา</font></div></td>
    </tr>
    <tr bgcolor="#EEEEEE"> 
      <td bordercolor="#006699">&nbsp;</td>
      <td width="11%" bordercolor="#006699" bgcolor="#EEEEEE"> <font size="2" face="Tahoma"> 
        <input name="Prob1" type="checkbox" id="Prob1" value="การเรียน">
        การเรียน</font></td>
      <td width="61%" bordercolor="#006699"><font size="2" face="Tahoma"> 
        <input name="Prob_detail1" type="text" id="Prob_detail1" size="60">
        </font></td>
    </tr>
    <tr bgcolor="#EEEEEE"> 
      <td height="20" bordercolor="#006699">&nbsp;</td>
      <td bordercolor="#006699" bgcolor="#EEEEEE"> <font size="2" face="Tahoma"> 
        <input name="Prob2" type="checkbox" id="Prob2" value="เศรษฐกิจ">
        เศรษฐกิจ</font></td>
      <td bordercolor="#006699"><input name="Prob_detail2" type="text" id="Prob_detail2" size="60"></td>
    </tr>
    <tr bgcolor="#EEEEEE"> 
      <td height="20" bordercolor="#006699">&nbsp;</td>
      <td bordercolor="#006699" bgcolor="#EEEEEE"> <font size="2" face="Tahoma"> 
        <input name="Prob3" type="checkbox" id="Prob3" value="สุขภาพ">
        สุขภาพ</font></td>
      <td bordercolor="#006699"><input name="Prob_detail3" type="text" id="Prob_detail3" size="60"></td>
    </tr>
    <tr bgcolor="#EEEEEE"> 
      <td height="20" bordercolor="#006699">&nbsp;</td>
      <td bordercolor="#006699" bgcolor="#EEEEEE"> <font size="2" face="Tahoma"> 
        <input name="Prob4" type="checkbox" id="Prob4" value="ส่วนตัว">
        ส่วนตัว</font></td>
      <td bordercolor="#006699"><input name="Prob_detail4" type="text" id="Prob_detail4" size="60"></td>
    </tr>
    <tr bgcolor="#EEEEEE"> 
      <td height="20"><div align="center"><font color="#003366" size="2" face="Tahoma">วิธีการแก้ปัญหา/คำแนะนำ</font></div></td>
      <td bordercolor="#006699">&nbsp;</td>
      <td colspan="2" bordercolor="#006699"> <p> 
          <textarea name="Recom" cols="60" rows="5" id="Recom"></textarea>
          <font size="2" face="Tahoma"> </font></p></td>
    </tr>
    <tr bgcolor="#EEEEEE"> 
      <td><div align="center"><font color="#003366" size="2" face="Tahoma">วันที่มาพบ</font></div></td>
      <td bordercolor="#006699">&nbsp;</td>
      <td colspan="2" bordercolor="#006699"><font size="2" face="Tahoma"> 
        <select name="mDate" id="mDate">
        <? getDay1to31()?>
        </select>
        เดือน 
        <select name="mMonth" id="mMonth">
        <? getThaiMonth()?>
        </select>
        ปี พ.ศ. 
        <input name="mYear" type="text" id="mYear" size="5">
        </font></td>
    </tr>
    <tr bgcolor="#B8ECB3"> 
      <td colspan="4"> 
        <div align="center"> 
          <input name="Student_id" type="hidden" id="Student_id" value="<? echo $rs[Student_id]?>">
          <input type="submit" name="Submit3" value="    เพิ่ม    ">
          &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
          <input type="reset" name="Submit22" value="   เคลียร์   ">
        </div></td>
    </tr>
  </form>
</table>
</body>
</html>