
<?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();
$sql1 = "Select * From student_tb Where Student_id='$Student_id'";
$result1 = mysql_query($sql1) or die(" Error".mysql_error());
$rs = mysql_fetch_array($result1);
////////////////
$sql = "Select * From advice_problem_tb  Where Student_id='$Student_id'";
$result = mysql_query($sql) or die(" Error".mysql_error());
$num = mysql_num_rows($result);

?>
<html>
<head>
<title>Edit 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="#EEEEEE" background="../../Image/bindertile.GIF">
<table width="90%" border="0" align="right" cellpadding="0" cellspacing="0">
  <tr> 
    <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
        <tr> 
          <td width="20%" background="../../Image/barad.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/barad.jpg" class="table"> 
            <div align="center"><strong><font size="2" face="Tahoma"><a href="AddStdProb.php?Student_id=<? echo $rs[Student_id]?>" class="d">เพิ่มข้อมูล</a></font></strong></div></td>
          <td width="20%" background="../../Image/barad.jpg" class="table"> 
            <div align="center"><strong><font size="2" face="Tahoma"><a href="StdProbDetail.php?Student_id=<? echo $rs[Student_id]?>" class="d">แสดงทั้งหมด</a></font></strong></div></td>
          <td width="20%" background="../../Image/barad.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>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr bgcolor="#F4F9F2"> 
          <td width="29%"><font size="2" face="Tahoma"><strong> &nbsp;รหัสนักศึกษา</strong></font><font size="3" face="Tahoma"> 
            :</font><font color="#006633" size="2" face="Tahoma"> 
            <?=$rs["Student_id"]?>
            </font></td>
          <td width="71%"><font size="2" face="Tahoma"><strong>ชื่อ-นามสกุล</strong></font><font size="3" face="Tahoma"> 
            : </font><font color="#006633" size="2" face="Tahoma"> 
            <?=$rs["First_name"]?>
            <?=$rs["Name"]?>
            <?=$rs["Last_name"]?>
            </font></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" style="border:1px solid gray">
        <form action="DelProb.php" method="post">
          <tr bgcolor="#E1F7DF" > 
            <td colspan="6"> <div align="center"><font color="#003366" size="4" face="Tahoma"><strong>รายละเอียดปัญหาของนักศึกษา</strong></font></div></td>
          </tr>
          <tr bgcolor="#EEEEEE"> 
            <td width="28" align="center" style="border:1px solid gray"><font size="2" face="Tahoma"><strong>ลบ</strong></font></td>
            <td width="27" align="center" style="border:1px solid gray"><font color="#003366" size="1" face="Tahoma"><strong>No.</strong></font></td>
            <td width="137" align="center" bgcolor="#EEEEEE" style="border:1px solid gray"><font size="2" face="Tahoma"><strong>วันที่มาพบ</strong></font></td>
            <td width="121" align="center" bgcolor="#EEEEEE" style="border:1px solid gray"><font color="#000000" size="2" face="Tahoma"><b>ประเภทปัญหา</b></font></td>
            <td width="298" align="center" bgcolor="#EEEEEE" style="border:1px solid gray"><font size="2" face="Tahoma"><strong>รายละเอียดของปัญหา</strong></font></td>
            <td width="66" align="center" bgcolor="#EEEEEE" style="border:1px solid gray"><font size="2" face="Tahoma"><strong>แก้ไข</strong></font></td>
          </tr>
          <?
$i = 1;
 while($row = mysql_fetch_array($result))
 {

     if($count==0)
     {
?>
          <tr bordercolor="#EEEEEE" bgcolor="#FFFFFF" > 
            <td align=center bgcolor="#F7F7F7" ><input type="checkbox" name="checkbox[]" value="<? echo $row[Prob_code]?>"></td>
            <td align=center bgcolor="#F7F7F7" ><font color="#003366" size="2" face="Tahoma"> 
              <?=$i?>
              </font></td>
            <td align=center bgcolor="#F7F7F7" ><font color="#006633" size="2" face="Tahoma"> 
              <?=$row["Date_meet"]?>
              </font></td>
            <td align=center bgcolor="#F7F7F7" > <div align="left"><font color="#990099" size="2" face="Tahoma"> 
                <a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                </a> </font></div>
              <div align="center"> 
                <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#F7F7F7">
                  <tr> 
                    <td bgcolor="#F7F7F7"><div align="left"><font color="#993333" size="2" face="Tahoma"> 
                        <?=$row["Prob1"]?>
                        </font></div></td>
                  </tr>
                  <tr> 
                    <td bgcolor="#E9E9E9"> <div align="left"><font color="#993333" size="2" face="Tahoma"> 
                        <?=$row["Prob2"]?>
                        </font></div></td>
                  </tr>
                  <tr> 
                    <td bgcolor="#E4E4E4"> <div align="left"><font color="#993333" size="2" face="Tahoma"> 
                        <?=$row["Prob3"]?>
                        </font></div></td>
                  </tr>
                  <tr> 
                    <td bgcolor="#D7D7D7"> <div align="left"><font color="#993333" size="2" face="Tahoma"> 
                        <?=$row["Prob4"]?>
                        </font></div></td>
                  </tr>
                </table>
              </div></td>
            <td bgcolor="#F7F7F7" ><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
              </a></font> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#F7F7F7">
                <tr> 
                  <td bgcolor="#F7F7F7"><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                    <?=$row["Prob_detail1"]?>
                    </a></font></td>
                </tr>
                <tr> 
                  <td bgcolor="#F7F7F7"><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                    <?=$row["Prob_detail2"]?>
                    </a></font></td>
                </tr>
                <tr> 
                  <td bgcolor="#F7F7F7"><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                    <?=$row["Prob_detail3"]?>
                    </a></font></td>
                </tr>
                <tr> 
                  <td bgcolor="#F7F7F7"><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                    <?=$row["Prob_detail4"]?>
                    </a></font></td>
                </tr>
              </table></td>
            <td bgcolor="#F7F7F7" ><div align="center"><font size="2" face="Tahoma"><strong><a href="FrmEditProb.php?Prob_code=<? echo $row[Prob_code]?>&&Student_id=<? echo $rs[Student_id]?>" class="c">แก้ไข</a></strong></font></div></td>
          </tr>
          <?
    $count=1;
     }
else
{
?>
          <tr bordercolor="#EEEEEE" bgcolor="#FFFFFF"> 
            <td align="center" ><input type="checkbox" name="checkbox[]" value="<? echo $row[Prob_code]?>"></td>
            <td align="center" ><font color="#003366" size="2" face="Tahoma"> 
              <?=$i?>
              </font></td>
            <td align="center" bgcolor="#FFFFFF" ><font color="#006633" size="2" face="Tahoma"> 
              <?=$row["Date_meet"]?>
              </font></td>
            <td height="18" align="center" > <div align="left"><font color="#990099" size="2" face="Tahoma"> 
                <a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                </a> </font></div>
              <div align="center"> 
                <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
                  <tr> 
                    <td><div align="left"><font color="#993333" size="2" face="Tahoma"> 
                        <?=$row["Prob1"]?>
                        </font></div></td>
                  </tr>
                  <tr> 
                    <td><div align="left"><font color="#993333" size="2" face="Tahoma"> 
                        <?=$row["Prob2"]?>
                        </font></div></td>
                  </tr>
                  <tr> 
                    <td><div align="left"><font color="#993333" size="2" face="Tahoma"> 
                        <?=$row["Prob3"]?>
                        </font></div></td>
                  </tr>
                  <tr> 
                    <td><div align="left"><font color="#993333" size="2" face="Tahoma"> 
                        <?=$row["Prob4"]?>
                        </font></div></td>
                  </tr>
                </table>
              </div></td>
            <td ><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
              </a></font> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
                <tr> 
                  <td><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                    <?=$row["Prob_detail1"]?>
                    </a></font></td>
                </tr>
                <tr> 
                  <td><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                    <?=$row["Prob_detail2"]?>
                    </a></font></td>
                </tr>
                <tr> 
                  <td><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                    <?=$row["Prob_detail3"]?>
                    </a></font></td>
                </tr>
                <tr> 
                  <td><font color="#990099" size="2" face="Tahoma"><a href="../Student/menu_std.php?Student_id=<?=$row["Student_id"]?>" title="Click to see Detail"  class="d"> 
                    <?=$row["Prob_detail4"]?>
                    </a></font></td>
                </tr>
              </table></td>
            <td ><div align="center"><font size="2" face="Tahoma"><strong><a href="FrmEditProb.php?Prob_code=<? echo $row[Prob_code]?>&&Student_id=<? echo $rs[Student_id]?>" class="c">แก้ไข</a></strong></font></div></td>
          </tr>
          <?
$count=0;
}
$i++;
 }    

?>
          <tr bgcolor="#EEEEEE"> 
            <td colspan="6" align="center"><input name="Student_id" type="hidden" id="Student_id" value="<? echo $rs[Student_id]?>"> 
              <input type="submit" name="Submit" value="   ลบ   "></td>
          <tr bgcolor="#E1F7DF"> 
            <td colspan="6" align="center"> <div align="center"><font color="#003366" size="2" face="Tahoma">ทั้งหมด</font><font color="#FF0000" size="2" face="Tahoma"> 
                <strong><? echo $num ?> </strong></font><font color="#003366" size="2" face="Tahoma">ครั้ง</font></div></td>
        </form>
      </table></td>
  </tr>
</table>
</body>
</html>
<? CloseDB();?>
<?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>";
} 
?>