| 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/checktime/ |
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'];
$search_keyword = $_REQUEST['search_keyword'];
$type_search = $_REQUEST['type_search'];
$tb_student_code = $_REQUEST['tb_student_code'];
$tb_student_id = $_REQUEST['tb_student_id'];
$day = date('d');
$month = date('m');
$year = date('y');
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
$fetch_public = $db->fetch_array($db->query("select * from tb_public"));
//----------------------------ค่าพื้นฐานระบบเว็บไซต์-----------------------------//
//--------------------ส่วนบนใช้สำหรับประกาศตัวแปรและ Config เท่านั้น----------------------------//
?>
<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}
.style6 {color: #0000FF}
-->
</style>
<script language="javascript">
function chknulldata(c){
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_birthday_d.value==''){
alert('กรุณาเลือก วันเกิด ');
c.tb_student_birthday_d.focus();
return false;
}
if(c.tb_student_birthday_m.value==''){
alert('กรุณาเลือก เดือนเกิด ');
c.tb_student_birthday_m.focus();
return false;
}
if(c.tb_student_birthday_y.value==''){
alert('กรุณาเลือก ปีเกิด');
c.tb_student_birthday_y.focus();
return false;
}
if(c.tb_student_myphone.value==''){
alert('กรุณากรอก เบอร์โทรนักเรียน');
c.tb_student_myphone.focus();
return false;
}
if(c.tb_student_phone.value==''){
alert('กรุณากรอก เบอร์โทรผู้ปกครอง');
c.tb_student_phone.focus();
return false;
}
}
function checkNumber(elm){
if(!elm.value.match(/^[\d\.]*$/)){
// if(!elm.value.match(/^[\d\-\+]*$/)){
alert('กรอกตัวเลขเท่านั้น');
elm.value='';
}
}
</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 align="center" valign="top"><table width="98%" 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"><a href="index.php"><img src="images/bar_check.jpg" width="411" height="39" border="0"></a></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">
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="0" bgcolor="#999999">
<form action="function_student_up.php" method="post" name="form1" id="form1" onSubmit="return chknulldata(this);">
<input name="tb_student_code" type="hidden" value="<?php print $tb_student_code;?>">
<?php
$tb_student_id_search = $disp->display_studentid($tb_student_code);
$query_edit_up = $db->query("select * from tb_students where tb_student_id = '".$tb_student_id_search."'");
$fetch_edit_up = $db->fetch_array($query_edit_up);
$array_1 = explode("-",$fetch_edit_up['tb_student_birthday']);
$tb_student_birthday_y = $array_1[0];
$tb_student_birthday_m = $array_1[1];
$tb_student_birthday_d = $array_1[2];
$tb_student_tname = $fetch_edit_up['tb_student_tname'];
$tb_student_blood = $fetch_edit_up['tb_student_blood'];
?>
<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"><input name="tb_student_id" type="hidden" value="<?php print $tb_student_id_search;?>">
<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 $tb_student_code;?>" disabled="disabled">
<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" id="tb_student_idcard" class="rowone" size="20" maxlength="13" value="<?php if($fetch_edit_up['tb_student_idcard']=="0"){print "";}else{print $fetch_edit_up['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_up['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_up['tb_student_sname'];?>">
<span class="alertred">*</span></td>
</tr>
<tr>
<td align="right" nowrap="nowrap" bgcolor="#FFFFFF"><strong>วันเดือนปี เกิด : </strong></td>
<td nowrap="nowrap" bgcolor="#FFFFFF"><select name="tb_student_birthday_d" class="rowone" id="tb_student_birthday_d">
<option value="">วัน</option>
<?php
for($d=1;$d<=31;$d++){
?>
<option value="<?=$d;?>"<? if($d==$tb_student_birthday_d){ echo "selected";} ?>><?=$d;?></option>
<?php
} // for
?>
</select>
-
<select name="tb_student_birthday_m" class="rowone" id="tb_student_birthday_m">
<option value="">เดือน</option>
<option value="01" <?php if($tb_student_birthday_m=='01'){echo "selected";}?>>มกราคม</option>
<option value="02" <?php if($tb_student_birthday_m=='02'){echo "selected";}?>>กุมภาพันธ์</option>
<option value="03" <?php if($tb_student_birthday_m=='03'){echo "selected";}?>>มีนาคม</option>
<option value="04" <?php if($tb_student_birthday_m=='04'){echo "selected";}?>>เมษายน</option>
<option value="05" <?php if($tb_student_birthday_m=='05'){echo "selected";}?>>พฤษภาคม</option>
<option value="06" <?php if($tb_student_birthday_m=='06'){echo "selected";}?>>มิถุนายน</option>
<option value="07" <?php if($tb_student_birthday_m=='07'){echo "selected";}?>>กรกฎาคม</option>
<option value="08" <?php if($tb_student_birthday_m=='08'){echo "selected";}?>>สิงหาคม</option>
<option value="09" <?php if($tb_student_birthday_m=='09'){echo "selected";}?>>กันยายน</option>
<option value="10" <?php if($tb_student_birthday_m=='10'){echo "selected";}?>>ตุลาคม</option>
<option value="11" <?php if($tb_student_birthday_m=='11'){echo "selected";}?>>พฤศจิกายน</option>
<option value="12" <?php if($tb_student_birthday_m=='12'){echo "selected";}?>>ธันวาคม</option>
</select>
-
<select name="tb_student_birthday_y" class="rowone" id="tb_student_birthday_y">
<option value="">ปี</option>
<?php for($i=0; $i<=20; $i++) {?>
<option value="<?PHP echo date("Y")-$i;?>" <?php if($tb_student_birthday_y==(date("Y")-$i)){echo "selected";}?>><?PHP echo date("Y")-$i+543?></option>
<?php }?>
</select>
<span class="alertred">*</span> </td>
<td align="right" 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_up['tb_student_myphone'];?>" 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_phone" type="text" class="rowone" id="tb_student_phone" size="30" maxlength="50" value="<?php print $fetch_edit_up['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" disabled="disabled">
<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_up['tb_student_degree']==$fetch_room['tb_room_id']){echo "selected";}?>><?php echo $fetch_room['tb_room_name'];?></option>
<?php } ?>
</select>
</strong></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="บันทึกข้อมูล" onClick="return confirm('ยืนยันการบันทึกข้อมูล ?');">
</td>
</tr>
<tr>
<td height="30" colspan="4" align="center" nowrap="nowrap" bgcolor="#FFFFFF" class="headTable_sun"></td>
</tr></form>
</table>
</td>
<td background="images/la21/bcontent_15.jpg"> </td>
</tr>
<tr>
<td height="15" background="images/la21/bcontent_13.jpg"> </td>
<td align="center" class="red_text"> </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>