| Server IP : 61.19.30.66 / Your IP : 216.73.216.15 Web Server : Apache/2.2.22 (Ubuntu) System : Linux klw 3.11.0-15-generic #25~precise1-Ubuntu SMP Thu Jan 30 17:39:31 UTC 2014 x86_64 User : www-data ( 33) PHP Version : 5.3.10-1ubuntu3.48 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/net/data/regis/add/ |
Upload File : |
<? include_once "connDB.php"; ?>
<?
if($submit=="OK"){
if($id1==""){
$sql="INSERT INTO klw set Auto_ID='".$Auto_ID."',Gender='".$Gender."',Title_Name='".$Title_Name."',FirstName='".$FirstName."',LastName='".$LastName."',Email='".$Email."',Tel='".$Tel."',Remark='".$Remark."'";
}else{
$sql="UPDATE klw set Name='".$Name."',surname='".$surname."' WHERE UserID='".$id1."'" ;
}
mysql_query($sql);
}
if ($submit=="DEL"){
$sql="delete from klw where UserID ='".$id1."'";
mysql_query($sql);
}
?>
<script language="JavaScript">
function chkdel(){
if(confirm(' กรุณายืนยันการลบอีกครั้ง !!! ')){
return true;
}else{
return false;
}
}
function Check_txt(){
if(document.getElementById('Gender').value==""){
alert("กรุณาระบุ Gender ด้วยครับ");
document.getElementById('Gender').focus();
return false;
}
if(document.getElementById('Title_Name').value==""){
alert("กรุณาระบุ Title_Name ด้วยครับ");
document.getElementById('Title_Name').focus();
return false;
}
if(document.getElementById('FirstName').value==""){
alert("กรุณาระบุ FirstName ด้วยครับ");
document.getElementById('FirstName').focus();
return false;
}
if(document.getElementById('LastName').value==""){
alert("กรุณาระบุ LastName ด้วยครับ");
document.getElementById('LastName').focus();
return false;
}
if(document.getElementById('Email').value==""){
alert("กรุณาระบุ Email ด้วยครับ");
document.getElementById('Email').focus();
return false;
}else{
var Email=document.getElementById('Email').value;
if (!isEmail(Email)){
alert('E-mail ไม่ถูกต้อง กรุณาตรวจสอบและลองใหม่อีกครั้งค่ะ...');
document.getElementById('Email').focus();
return false;
}
}
}
function isEmail(str) {
var supported = 0;
if (window.RegExp) {
var tempStr = 'a';
var tempReg = new RegExp(tempStr);
if (tempReg.test(tempStr)) supported = 1;
}
if (!supported)
return (str.indexOf('.') > 2) && (str.indexOf('@') > 0);
var r1 = new RegExp('(@.*@)|(\\.\\.)|(@\\.)|(^\\.)');
var r2 = new RegExp('^.+\\@(\\[?)[a-zA-Z0-9\\-\\.]+\\.([a-zA-Z]{2,3}|[0-9]{1,3})(\\]?)$');
return (!r1.test(str) && r2.test(str));
}
</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<title>ระบบข้อมูลนักเรียน</title>
<link href="style/style.css" rel="stylesheet" type="text/css" />
</head>
<script type='text/javascript' language='javascript' src='date_time/prototype-1.js'></script>
<script type='text/javascript' language='javascript' src='date_time/prototype-date-extensions.js'></script>
<script type='text/javascript' language='javascript' src='date_time/behaviour.js'></script>
<script type='text/javascript' language='javascript' src='date_time/datepicker.js'></script>
<script type='text/javascript' language='javascript' src='date_time/behaviors.js'></script>
<link rel='stylesheet' href='date_time/datepicker.css'>
<body>
<center>
<div id="container">
<div id="header">
<div id="header_left"></div>
<div id="header_main">ระบบจัดการข้อมูล นักเรียน</div>
<div id="header_right"></div>
</div>
<div id="content"><br><br>
<? if($submit=="" or $show=="OK"){?>
<center><form name="form1" method="post" action="student.php?show=OK&strSearch=Y">
<table width="98%" >
<tr>
<td width="50%"><div align="right">ค้นหา :<select name="Search2">
<option value="Username" <? if($Search2=="Username"){ ?>selected<? }?>>เลขประจำตัว</option>
<option value="Name" <? if($Search2=="Name"){ ?>selected<? }?>>ชื่อ</option>
<option value="cllass" <? if($Search2=="cllass"){ ?>selected<? }?>>ระดับชั้น</option>
</select></div>
</td>
<td width="64%"><input name="Search" type="text" size="20" value="<? echo $Search?>"onFocus="this.value = '';">
<input type="submit" name="submit" value="Search">
</td>
</tr>
</table>
</form></center>
<?
if(!isset($start)){
$start = 0;
$page=1;
}
$limit = '20';
if($strSearch=="Y"){
$Qtotal = mysql_query("select * from klw Where ".$Search2." like '%".$Search."%' ");
}else{
$Qtotal = mysql_query("select * from klw klw where xLevel=3 and cllass=1 and room=1");
}
$total = mysql_num_rows($Qtotal);
if($strSearch=="Y"){
$Query = mysql_query("select * from klw Where ".$Search2." like '%".$Search."%' order by room+1 asc LIMIT $start,$limit");
}else{
$Query= mysql_query("select * from klw where xLevel=3 and cllass=1 and room=1 LIMIT $start,$limit");
}
$totalp = mysql_num_rows($Query);
$xx=$totalp+$start;
$yy=$start+1;
echo "ข้อมูลที่ ".$yy." ถึงข้อมูลที่ ".$xx;
printf(" | จากทั้งหมด %d รายการ ",$total);
printf(" | หน้าที่ %d <br />",$page);
?><br><br>
<table width="98%">
<tr bgcolor="#999999" height='40' >
<td align='center'><strong>เลขประจำตัว</strong></td>
<td align='center'><strong>ชื่อ</strong></td>
<td align='center'><strong>นามสกุล</strong></td>
<td align='center'><strong>ระดับชั้น </strong></td>
<td align='center'><strong>ห้อง</strong></td>
<td width="8%"><a href="student.php?submit=Add&show="><center><img src="style/images/add.png" border="0"></center></a></td>
</tr>
<?
while($arr = mysql_fetch_array($Query)){
$autoid = $arr['UserID'];
$i++;
if($i%2==0){
$bg = "#CCCCCC";
}else{
$bg = "#FFFFFF";
}
?>
<tr bgcolor="<? echo $bg?>" onmouseover="this.style.backgroundColor='#CCFFCC'" onmouseout="this.style.backgroundColor=''" valign="top">
<td align='center'><? echo $arr['Username'] ?></td>
<td align='center'><? echo $arr['Name'] ?></td>
<td align='center'><? echo $arr['surname'] ?></td>
<td align='center'><? echo $arr['cllass'] ?></td>
<td align='center'><? echo $arr['room'] ?></td>
<td align="center">
<a href="student.php?submit=DEL&show=OK&id1=<? echo $autoid;?>" OnClick="return chkdel();"><img src="style/images/-.png" border="0"></a>
<a href="student.php?submit=Edit&id1=<? echo $autoid;?>"><img src="style/images/Tools.png" border="0"></a></td>
</tr>
<? }?>
</table>
<? }?>
<? if($submit=="Add"){?>
<form action="student.php?submit=OK&show=OK&id1=" method="post"onSubmit="return Check_txt()" enctype='multipart/form-data'>
<table width="98%">
<tr>
<td width='30%' align='right'>รหัสประจำตัวนักเรียน : </td>
<td width='70%'><input name='Username' id='Username' type='text' size='50'></td>
</tr>
<tr>
<td width='30%' align='right'>Gender : </td>
<td width='70%'><select name='Gender' id='Gender'>
<option value='ชาย'>ชาย</option>
<option value='หญิง'>หญิง</option>
</select>
* </td>
</tr>
<tr>
<td width='30%' align='right'>Title_Name : </td>
<td width='70%'><select name='Title_Name' id='Title_Name'>
<option value='นาย'>นาย</option>
<option value='นาง'>นาง</option>
<option value='นางสาว'>นางสาว</option>
</select>
* </td>
</tr>
<tr>
<td width='30%' align='right'>FirstName : </td>
<td width='70%'><input name='FirstName' id='FirstName' type='text' size='50'> * </td>
</tr>
<tr>
<td width='30%' align='right'>LastName : </td>
<td width='70%'><input name='LastName' id='LastName' type='text' size='50'> * </td>
</tr>
<tr>
<td width='30%' align='right'>Email : </td>
<td width='70%'><input name='Email' id='Email' type='text' size='50'> * </td>
</tr>
<tr>
<td width='30%' align='right'>Tel : </td>
<td width='70%'><input name='Tel' id='Tel' type='text' size='50'></td>
</tr>
<tr>
<td width='30%' align='right'>Remark : </td>
<td width='70%'><input name='Remark' id='Remark' type='text' size='50'></td>
</tr>
<tr height='50'>
<td></td>
<td align='left' valign='middle'><input type='submit' name='Submit' value=' บันทึก '> <input type='reset' name='Submit2' value='ล้างข้อมูล'> <input type='button' name='Submit222' value=' ยกเลิก ' onclick="document.location.href='student.php?show=OK'"></td>
</tr>
</table>
</form>
<? }?>
<? if($submit=="Edit"){
$sql="select * from klw where UserID ='".$id1."' ";
$tem = mysql_query($sql);
$row3=mysql_fetch_array($tem);
?>
<form action="student.php?submit=OK&show=OK&id1=<? echo $id1?>" method="post"onSubmit="return Check_txt();" enctype='multipart/form-data'>
<input type='hidden' name='UserID' value="<?=$row3['UserID']?>">
<table width="98%">
<tr>
<td width='30%' align='right'>เลขประจำตัวนักเรียน : </td>
<td width='70%'><input name='Username' id='Username' type='text' size='50' value='<?=$row3["Username"]?>' disabled></td>
</tr>
<tr>
<td width='30%' align='right'>Gender : </td>
<td width='70%'><select name='Gender' id='Gender'>
<option value='ชาย' <? if($row3['Gender']=='ชาย') echo 'selected';?>>ชาย</option>
<option value='หญิง' <? if($row3['Gender']=='หญิง') echo 'selected';?>>หญิง</option>
</select>
* </td>
</tr>
<tr>
<td width='30%' align='right'>Title_Name : </td>
<td width='70%'><select name='Title_Name' id='Title_Name'>
<option value='นาย' <? if($row3['Title_Name']=='นาย') echo 'selected';?>>นาย</option>
<option value='นาง' <? if($row3['Title_Name']=='นาง') echo 'selected';?>>นาง</option>
<option value='นางสาว' <? if($row3['Title_Name']=='นางสาว') echo 'selected';?>>นางสาว</option>
</select>
* </td>
</tr>
<tr>
<td width='30%' align='right'>FirstName : </td>
<td width='70%'><input name='Name' id='Name' type='text' size='50' value='<?=$row3["Name"]?>'> * </td>
</tr>
<tr>
<td width='30%' align='right'>LastName : </td>
<td width='70%'><input name='surname' id='surname' type='text' size='50' value='<?=$row3["surname"]?>'> * </td>
</tr>
<tr>
<td width='30%' align='right'>Email : </td>
<td width='70%'><input name='Email' id='Email' type='text' size='50' value='<?=$row3["Email"]?>'> * </td>
</tr>
<tr>
<td width='30%' align='right'>Tel : </td>
<td width='70%'><input name='Tel' id='Tel' type='text' size='50' value='<?=$row3["Tel"]?>'></td>
</tr>
<tr>
<td width='30%' align='right'>Remark : </td>
<td width='70%'><input name='Remark' id='Remark' type='text' size='50' value='<?=$row3["Remark"]?>'></td>
</tr>
<tr height="50">
<td></td>
<td><input type="submit" name="Submit" value=" บันทึก "> <input type="button" name="Submit222" value=" ยกเลิก " onclick="document.location.href='student.php?show=OK'"></td>
</tr>
</table>
</form>
<? }?>
</div>
<div id="footer">
<? if($submit=="" or $show=="OK"){
$page = ceil($total/$limit);
for($i=1;$i<=$page;$i++){
if($_GET['page']==$i){
echo "[<a href='?start=".$limit*($i-1)."&page=$i&strSearch=$strSearch&Search=$Search&Search2=$Search2'><B>$i</B></A>]";
}else{
echo "[<a href='?start=".$limit*($i-1)."&page=$i&strSearch=$strSearch&Search=$Search&Search2=$Search2'>$i</A>]";
}}} ?>
</div>
</div>
</center>
</body>