| Server IP : 172.67.187.206 / 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 : E:/Inetpub/www/myschool/triamudom/check/webadmin/ |
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');
include ($path.'include/permission_denied.php');
$CLASS['db'] = new db();
$CLASS['db']->connect();
$CLASS['disp'] = new display();
$db = $CLASS['db'];
$disp = $CLASS['disp'];
$tb_student_degree = $_REQUEST['tb_student_degree'];
$tb_student_id = $_REQUEST['tb_student_id'];
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
$fetch_public = $db->fetch_array($db->query("select * from tb_public"));
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
//--------------------ส่วนบนใช้สำหรับประกาศตัวแปรและ Config เท่านั้น----------------------------//
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php print $fetch_public['tb_public_title_admin'];?></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<SCRIPT type="text/javascript" src="js/format.js"></SCRIPT>
<SCRIPT type="text/javascript" src="js/global.js" ></SCRIPT>
<SCRIPT type="text/javascript" src="js/dtree.js" ></SCRIPT>
<script language="JavaScript" type="text/javascript" src="../js/editor.js"></script>
<link href="css/style_admin.css" rel="stylesheet" type="text/css">
</head>
<script language="javascript">
function chknull(c){
if(c.tb_student_code.value==''){
alert('กรุณากรอก รหัสประจำตัว');
c.tb_student_code.focus();
return false;
}
if(c.tb_student_idcard.value==''){
alert('กรุณากรอก รหัสประจำตัวประชาชน');
c.tb_student_idcard.focus();
return false;
}
if(c.tb_student_blood.value==''){
alert('กรุณากรอก กรุ๊ปเลือด');
c.tb_student_blood.focus();
return false;
}
if(c.tb_student_tname.value==''){
alert('กรุณาเลือก คำนำหน้าชื่อ');
c.tb_student_tname.focus();
return false;
}
if(c.tb_student_name.value==''){
alert('กรุณากรอก ชื่อนักเรียน ');
c.tb_student_name.focus();
return false;
}
if(c.tb_student_sname.value==''){
alert('กรุณากรอก นามสกุล ');
c.tb_student_sname.focus();
return false;
}
if(c.tb_student_phone.value==''){
alert('กรุณากรอก เบอร์โทรผู้ปกครอง');
c.tb_student_phone.focus();
return false;
}
if(c.tb_student_degree.value==''){
alert('กรุณาเลือก ระดับชั้น');
c.tb_student_degree.focus();
return false;
}
}
function checkNumber(elm){
if(!elm.value.match(/^[\d\.]*$/)){
// if(!elm.value.match(/^[\d\-\+]*$/)){
alert('กรอกตัวเลขเท่านั้น');
elm.value='';
}
}
</script>
<body>
<form action="function_student.php" method="post" name="form1" id="form1" onSubmit="return chknull(this);">
<input name="tb_student_id" type="hidden" value="<?php print $tb_student_id;?>" />
<?php
$query_edit = $db->query("select * from tb_students where tb_student_id = '".$tb_student_id."'");
$fetch_edit = $db->fetch_array($query_edit);
$tb_student_tname = $fetch_edit['tb_student_tname'];
$tb_student_degree = $fetch_edit['tb_student_degree'];
$tb_student_blood = $fetch_edit['tb_student_blood'];
?>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="0" bgcolor="#999999">
<tr class="headTable_mpt">
<td height="30" colspan="4" align="left" nowrap="nowrap" class="headTable_sun">แก้ไขข้อมูลนักเรียน</td>
</tr>
<tr>
<td align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>รหัสประจำตัว : </strong></td>
<td colspan="3" nowrap="nowrap" bgcolor="#FFFFFF"><input name="tb_student_code" type="text" class="red_text" id="tb_student_code" size="15" maxlength="5" value="<?php print $fetch_edit['tb_student_code'];?>" onkeyup='checkNumber(this)'>
<span class="alertred">*</span></td>
</tr>
<tr>
<td align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>เลขบัตรประชาชน : </strong></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><input name="tb_student_idcard" type="text" class="rowone" id="tb_student_idcard" size="20" maxlength="13" onkeyup='checkNumber(this)' value="<?php print $fetch_edit['tb_student_idcard'];?>">
<span class="alertred">*</span></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><strong>กรุ๊บเลือด : </strong></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><select name="tb_student_blood" class="rowone" id="tb_student_blood" >
<option value="">= กรุ๊ปเลือด =</option>
<option value="A" <?php if($tb_student_blood=='A'){echo "selected";}?>>A</option>
<option value="B" <?php if($tb_student_blood=='B'){echo "selected";}?>>B</option>
<option value="O" <?php if($tb_student_blood=='O'){echo "selected";}?>>O</option>
<option value="AB" <?php if($tb_student_blood=='AB'){echo "selected";}?>>AB</option>
</select> </td>
</tr>
<tr>
<td align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>คำนำหน้าชื่อ : </strong></td>
<td colspan="3" nowrap="nowrap" bgcolor="#FFFFFF"><select name="tb_student_tname" class="rowone" id="tb_student_tname">
<option value="">= เลือก =</option>
<option value="1" <?php if($tb_student_tname=='1'){echo "selected";}?>>เด็กชาย</option>
<option value="2" <?php if($tb_student_tname=='2'){echo "selected";}?>>เด็กหญิง</option>
<option value="3" <?php if($tb_student_tname=='3'){echo "selected";}?>>นาย</option>
<option value="4" <?php if($tb_student_tname=='4'){echo "selected";}?>>น.ส.</option>
</select>
<span class="alertred">*</span></td>
</tr>
<tr>
<td width="37%" align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>ชื่อนักเรียน : </strong></td>
<td width="63%" nowrap="nowrap" bgcolor="#FFFFFF"><input name="tb_student_name" type="text" class="rowone" id="tb_student_name" size="30" maxlength="100" value="<?php print $fetch_edit['tb_student_name'];?>">
<span class="alertred">*</span> </td>
<td align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>นามสกุล : </strong></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><input name="tb_student_sname" type="text" class="rowone" id="tb_student_sname" size="30" maxlength="100" value="<?php print $fetch_edit['tb_student_sname'];?>">
<span class="alertred">*</span></td>
</tr>
<tr>
<td align="right" valign="top" nowrap="nowrap" bgcolor="#FFFFFF"><strong>ที่อยู่ : </strong></td>
<td colspan="3" valign="top" nowrap="nowrap" bgcolor="#FFFFFF"><textarea name="tb_student_address" cols="60" rows="4" class="textbox" id="tb_student_address"><?php print $fetch_edit['tb_student_address'];?></textarea></td>
</tr>
<tr>
<td align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>วันเดือนปี เกิด : </strong></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><input name="tb_student_birthday" type="text" class="rowone" id="tb_student_birthday" size="20" value="<?php print $fetch_edit['tb_student_birthday'];?>">
วัน/เดือน/ปี พ.ศ. </td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><strong>เบอร์โทรนักเรียน : </strong></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><input name="tb_student_myphone" type="text" class="rowone" id="tb_student_myphone" size="30" maxlength="50" value="<?php print $fetch_edit['tb_student_myphone'];?>" onkeyup='checkNumber(this)' /></td>
</tr>
<tr>
<td align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>เบอร์โทรผู้ปกครอง : </strong></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><input name="tb_student_phone" type="text" class="rowone" id="tb_student_phone" size="30" maxlength="50" value="<?php print $fetch_edit['tb_student_phone'];?>" onkeyup='checkNumber(this)'>
<span class="alertred">*</span></td>
<td align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>ระดับชั้น : </strong></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><strong>
<select name="tb_student_degree" class="rowone" id="tb_student_degree">
<option value="">= เลือกระดับชั้น =</option>
<?php $query_room=$db->query("select * from tb_rooms where tb_room_status ='1' order by tb_room_id asc");
while($fetch_room=$db->fetch_array($query_room)){
?>
<option value="<?php echo $fetch_room['tb_room_id'];?>" <?php if($fetch_edit['tb_student_degree']==$fetch_room['tb_room_id']){echo "selected";}?>><?php echo $fetch_room['tb_room_name'];?></option>
<?php } ?>
</select>
</strong><span class="alertred">*</span></td>
</tr>
<tr>
<td align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>รูปภาพ : </strong></td>
<td colspan="3" nowrap="nowrap" bgcolor="#FFFFFF"><input name="tb_student_picture" type="file" class="rowtwo" id="tb_student_picture" />
<a href="../file_student/<?php print $fetch_edit['tb_student_picture'];?>" target="_blank"><input name="tb_student_picture_me" type="hidden" value="<?php print $fetch_edit['tb_student_picture'];?>" /><img src="images/admins.gif" width="20" height="20" border="0" /></a></td>
</tr>
<tr>
<td height="30" colspan="4" align="center" nowrap="nowrap" bgcolor="#FFFFFF" class="headTable_sun"><input name="Submit" type="submit" class="Submit" value="บันทึกข้อมูล" />
<input name="Submit2" type="button" class="Submit" value="ปิดหน้านี้" onclick="window.close();"></td>
</tr>
<tr>
<td height="30" colspan="4" align="center" nowrap="nowrap" bgcolor="#FFFFFF" class="headTable_sun"><label></label></td>
</tr>
</table>
</form>
</body>
</html>