| Server IP : 104.21.80.248 / Your IP : 172.71.28.155 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/myschool/triamudom/check/knowledge/ |
Upload File : |
<?php
session_start();
$path = "../";
include ($path.'include/config_db.php');
include ($path.'include/class_db.php');
include ($path.'include/class_display.php');
include ($path.'include/function.php');
$CLASS['db'] = new db();
$CLASS['db']->connect();
$CLASS['disp'] = new display();
$db = $CLASS['db'];
$disp = $CLASS['disp'];
$keyword = $_REQUEST['keyword'];
$tb_student_id = $_REQUEST['tb_student_id'];
$type_search = $_REQUEST['type_search'];
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
$fetch_public = $db->fetch_array($db->query("select * from tb_public"));
$fetch_knowledgesetup = $db->fetch_array($db->query("select * from tb_knowledge_setup"));
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
$sql_chkstu = "select * from tb_registers_knowledge where tb_student_id = '".$_SESSION['sessionuser_id']."' ";
$result_chkstu = $db->query($sql_chkstu);
$num_checkstudent = $db->num_rows($result_chkstu);
$array_h='';
while($fetch_disstu = $db->fetch_array($result_chkstu)){;
//echo $array_h .= $fetch_disstu['tb_knowledge_4h'].",";
$array_h .= ($array_h? ',' : '') . $fetch_disstu['tb_knowledge_4h'];
}
/*
if($num_checkstudent== '1'){
?>
<script language="javascript">window.location.href = 'display_regis_all.php?tb_student_id=<?php print $_SESSION['sessionuser_id'];?>'</script>
<?php
}else{*/
//--------------------ส่วนบนใช้สำหรับประกาศตัวแปรและ Config เท่านั้น----------------------------//
$tb_student_code = $_REQUEST['tb_student_code'];
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php print $fetch_public['tb_public_title'];?></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/style.css"rel="stylesheet" type="text/css">
<script type="text/javascript" src="../js/format.js" ></script>
<script type="text/javascript" src="../js/dtree.js" ></script>
<link href="../css/style.css" rel="stylesheet" type="text/css">
<link href="css/deqp_style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {font-size: 24px}
.style3 {font-size: 16}
.style5 {font-size: 18px}
-->
</style><script language="javascript">
function chknull(c){
if(c.tb_student_code.value==''){
alert('กรุณากรอก รหัสนักเรียน');
c.tb_student_code.focus();
return false;
}
</script>
</head>
<body>
<table width="988" height="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="200" align="center" valign="top"><?php include('header.php');?></td>
</tr>
<tr>
<td valign="top"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="209" height="50%" align="center" valign="top"><?php include('com_left.php');?></td>
<td valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="9" height="39"><img src="images/la21/bcontent_03.jpg" width="9" height="39" /></td>
<td height="39" background="images/la21/bcontent_06.jpg"><img src="images/bar_act.jpg" width="411" height="39" border="0"></td>
<td width="13" height="39"><img src="images/la21/bcontent_08.jpg" width="13" height="39" /></td>
</tr>
<tr>
<td height="15" background="images/la21/bcontent_13.jpg"> </td>
<td align="center"></td>
<td height="15" background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center"> </td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center"></br>
<?php
$query_edit = $db->query("select * from tb_students where tb_student_status=1 and tb_student_code='".$tb_student_code."'");
$numrows = $db->num_rows($query_edit);
$fetch_dis_student = $db->fetch_array($query_edit);
if($numrows > 0){
?>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><hr /></td>
</tr>
<tr>
<td align="center"><form id="form1" name="form1" method="post" action="function_regisuserknow.php" onSubmit="return chknull(this);">
<input name="tb_student_id" type="hidden" value="<?php print $fetch_dis_student['tb_student_id'];?>" />
<input name="tb_student_code" type="hidden" value="<?php print $fetch_dis_student['tb_student_code'];?>" />
<?php
$num_checkstudent = $db->num_rows($db->query("select * from tb_registers_knowledge where tb_student_id = '".$fetch_dis_student['tb_student_id']."' "));
?>
<input name="tb_register_knowledge_order" type="hidden" value="<?php print $num_checkstudent+1;?>">
<table width="80%" border="0" align="center" cellpadding="3" cellspacing="2">
<tr>
<td colspan="2" valign="top" nowrap="nowrap" bgcolor="#FFFFFF"><span class="orange_textcheck">ข้อมูลนักเรียนที่ต้องการ : <?php print $tb_student_code;?> </span>
<input name="Submit2" type="button" class="Submit" value="กลับหน้าหลัก" onclick="window.location.href='display_knowledge_adduser.php';" /></td>
</tr>
<tr>
<td width="28%" align="right" valign="top" nowrap="nowrap" bgcolor="#FFFFFF" class="B_textcheck"><strong>ชื่อ - นามสกุล : </strong></td>
<td width="72%" valign="top" nowrap="nowrap" bgcolor="#FFFFFF" class="B_textcheck"><?php print display_nametype($fetch_dis_student['tb_student_tname']);?><?php print $fetch_dis_student['tb_student_name'];?> <?php print $fetch_dis_student['tb_student_sname'];?></td>
</tr>
<tr>
<td align="right" valign="top" nowrap="nowrap" bgcolor="#FFFFFF" class="B_textcheck"><strong>ระดับชั้น : </strong></td>
<td valign="top" bgcolor="#FFFFFF" class="B_textcheck"><?php print $disp->display_roomname($fetch_dis_student['tb_student_degree']);?></td>
</tr>
<?php
$query_disknow = $db->query("select * from tb_registers_knowledge
INNER JOIN tb_knowledges ON tb_registers_knowledge.tb_knowledge_id = tb_knowledges.tb_knowledge_id where tb_student_id='".$fetch_dis_student['tb_student_id']."' ");
$numrows_know = $db->num_rows($query_disknow);
$fetch_disknow = $db->fetch_array($query_disknow);
?>
<?php if($numrows_know!='0'){?>
<tr>
<td align="right" valign="top" nowrap="nowrap" bgcolor="#FFFFFF" class="red_text style5">กิจกรรมที่เลือก : </td>
<td valign="top" nowrap="nowrap" bgcolor="#FFFFFF" class="red_text style5"><?php print $fetch_disknow['tb_knowledge_name'];?> ( <?php print $disp->display_teachername($fetch_disknow['tb_teacher_id']);?> )</td>
</tr>
<?php } ?>
<?php if($numrows_know=='0'){?>
<tr>
<td colspan="2" valign="top" nowrap="nowrap" bgcolor="#FFFFFF"><span class="orange_textcheck">กำหนดกิจกรรมให้นักเรียน</span></td>
</tr>
<tr>
<td align="right" valign="top" nowrap="nowrap" bgcolor="#FFFFFF" class="B_textcheck">เลือกกิจกรรม</td>
<td align="left" valign="top" nowrap="nowrap" bgcolor="#FFFFFF" class="B_textcheck"><div align="left">
<select name="tb_knowledge_id" class="orange_textcheck" id="tb_knowledge_id">
<?php
$query_knowledge=$db->query("select * from tb_knowledges where tb_knowledge_status ='1' and tb_teacher_id = '".$_SESSION['sessiontuser_id']."' order by tb_knowledge_id asc");
while($fetch_knowledge=$db->fetch_array($query_knowledge)){
?>
<option value="<?php echo $fetch_knowledge['tb_knowledge_id'];?>/<?php echo $fetch_knowledge['tb_knowledge_4h'];?>" selected="selected"><?php echo $fetch_knowledge['tb_knowledge_name'];?> - ( <?php echo display_4htype($fetch_knowledge['tb_knowledge_4h']);?> )</option>
<?php } ?>
</select>
</div></td>
</tr>
<tr>
<td align="right" valign="top" nowrap="nowrap" bgcolor="#FFFFFF"> </td>
<td align="left" valign="top" nowrap="nowrap" bgcolor="#FFFFFF" ><input name="Submit" type="submit" class="textboxlogin" value="ยืนยัน" onclick="return confirm('คุณต้องการที่จะเพิ่มข้อมูลนี้หรือไม่ ?');"></td>
</tr>
<?php } ?>
</table>
</form></td>
</tr>
<tr>
<td align="center"><hr /></td>
</tr>
</table>
<?php }else{?>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><hr /></td>
</tr>
<tr>
<td align="center" valign="top" nowrap="nowrap" class="red_text"><p class="orange_textcheck">ไม่พบข้อมูล<br />
<br />
<input name="button2" type="button" class="orange_text" onclick="history.go(-1)" value="ค้นหาข้อมูลนักเรียน" />
</p></td>
</tr>
<tr>
<td align="center"><hr /></td>
</tr>
</table>
<?php } ?></td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td background="images/la21/bcontent_13.jpg"> </td>
<td align="center"> </td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td height="15" background="images/la21/bcontent_13.jpg"> </td>
<td align="center"></td>
<td height="15" background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td width="9" height="15"><img src="images/la21/bcontent_18.jpg" width="9" height="15" /></td>
<td height="15" background="images/la21/bcontent_19.jpg"></td>
<td width="13" height="15"><img src="images/la21/bcontent_20.jpg" width="13" height="15" /></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="37" valign="bottom"><?php include('footer.php');?></td>
</tr>
</table>
</body>
</html>
<?php
// }
?>