<?include("header.php");
include("menuleft.php") ?>
<?switch($page){
case 'delete': {
$sql = "delete from `admin` where id_admin='$id'";
$dbquery = mysql_db_query($dbname, $sql);
echo "<meta http-equiv='refresh' content='0; url=admin_admin.php'>" ;
break; }
case 'saveedit': {
$sql = "update `admin` set username='$username',password='$password',name='$name',surname='$surname',tel='$tel',`e-mail`='$email' where id_admin='$id'";
$dbquery = mysql_db_query($dbname, $sql);
echo "<meta http-equiv='refresh' content='0; url=admin_admin.php'>" ;
break; }
case 'edit': {
$sql = "select * from admin where id_admin='$id'";
$query = mysql_query( $sql );
$row = mysql_fetch_array( $query );?>
<form action="?page=saveedit&id=<?=$id;?>" method="post" name="form" onSubmit="return check_form();">
<TABLE align="center" width="500" border="0" cellpadding="0" cellspacing="0">
<TR align="center"><TD colspan="2">เพิ่มข้อมูล</TD></TR>
<TR><TD align="left">ชื่อผู้ใช้</TD>
<TD align="left">
<INPUT TYPE="text" NAME="username" value="<?=$row["username"];?>">
</TD></TR>
<TR><TD align="left">รหัสผ่าน</TD>
<TD align="left">
<INPUT TYPE="password" NAME="password" value="<?=$row["password"];?>">
</TD></TR><TR><TD align="left">ชื่อ</TD>
<TD align="left">
<INPUT TYPE="text" NAME="name" value="<?=$row["name"];?>" onKeyPress="check_name()">
</TD></TR><TR><TD align="left">นามสกุล</TD>
<TD align="left">
<INPUT TYPE="text" NAME="surname" value="<?=$row["surname"];?>" onKeyPress="check_name()">
</TD></TR><TR><TD align="left">เบอร์โทรศัพท์</TD>
<TD align="left">
<INPUT TYPE="text" NAME="tel" value="<?=$row["tel"];?>" onKeyPress="check_number()">
</TD></TR><TR><TD align="left">E-mail</TD>
<TD align="left">
<INPUT TYPE="text" NAME="email" value="<?=$row["e-mail"];?>">
</TD></TR>
<TR><TD align="left"></TD>
<TD align="left">
<INPUT TYPE="submit" value="ยืนยัน">
<INPUT TYPE="reset" value="ยกเลิก">
</TD></TR>
</TABLE>
</form>
<?break; }
case 'adddb': {
$sql = "insert into `admin` (username,password,name,surname,tel,`e-mail`)values('$username','$password','$name','$surname','$tel','$email')";
$dbquery = mysql_db_query($dbname, $sql);
echo "<meta http-equiv='refresh' content='0; url=admin_admin.php'>" ;
break; }
case 'new': { ?>
<form action="?page=adddb" method="post" name="form" onSubmit="return check_form();">
<TABLE align="center" width="500" border="0" cellpadding="0" cellspacing="0">
<TR align="center"><TD colspan="2">เพิ่มข้อมูล</TD></TR>
<TR><TD align="left">ชื่อผู้ใช้</TD>
<TD align="left">
<INPUT TYPE="text" NAME="username">
</TD></TR>
<TR><TD align="left">รหัสผ่าน</TD>
<TD align="left">
<INPUT TYPE="password" NAME="password">
</TD></TR><TR><TD align="left">ชื่อ</TD>
<TD align="left">
<INPUT TYPE="text" NAME="name" onKeyPress="check_name()">
</TD></TR><TR><TD align="left">นามสกุล</TD>
<TD align="left">
<INPUT TYPE="text" NAME="surname" onKeyPress="check_name()">
</TD></TR><TR><TD align="left">เบอร์โทรศัพท์</TD>
<TD align="left">
<INPUT TYPE="text" NAME="tel" onKeyPress="check_number()">
</TD></TR><TR><TD align="left">E-mail</TD>
<TD align="left">
<INPUT TYPE="text" NAME="email">
</TD></TR>
<TR><TD align="left"></TD>
<TD align="left">
<INPUT TYPE="submit" value="ยืนยัน">
<INPUT TYPE="reset" value="ยกเลิก">
</TD></TR>
</TABLE>
</form>
<?break; }
default : ?>
<BR>
<CENTER><a href="?page=new">เพิ่มข้อมูล</a>
</CENTER>
<TABLE align="center" width="780" border="1" cellpadding="1" cellspacing="1">
<TR align="center">
<TD>ชื่อผู้ใช้</TD>
<TD>รหัสผ่าน</TD>
<TD>ชื่อ</TD>
<TD>นามสกุล</TD>
<TD>เบอร์โทรศัพท์</TD>
<TD>E-mail</TD>
<TD>แก้ไข</TD>
<TD>ลบ</TD>
</TR>
<? $sql = "select * from admin order by id_admin asc";
$query = mysql_query( $sql );
while($row = mysql_fetch_array( $query )){
?>
<TR align="left">
<TD><?=$row[username];?></TD>
<TD>****</TD>
<TD><?=$row[name];?></TD>
<TD><?=$row[surname];?></TD>
<TD><?=$row[tel];?></TD>
<TD><?=$row["e-mail"];?></TD>
<TD><a href="?page=edit&id=<?=$row[id_admin];?>">แก้ไข</a></TD>
<TD>
<A HREF=# onClick=rusure('?page=delete&id=<?=$row[id_admin];?>');>ลบ</a>
</TD>
</TR>
<?}?>
</TABLE>
<?}?>
<script>
function check_form(){
var Myform=document.form;
var txt="";
if (Myform.username.value==""){ txt=txt+"- ชื่อผู้ใช้ \n";}
if (Myform.password.value==""){ txt=txt+"- รหัสผ่าน \n";}
if (Myform.name.value==""){ txt=txt+"- ชื่อ \n";}
if (Myform.surname.value==""){ txt=txt+"- นามสกุล \n";}
if (Myform.tel.value==""){ txt=txt+"- เบอร์โทรศัพท์ \n";}
if (Myform.email.value==""){ txt=txt+"- อีเมล์ \n";}
else{if (checkEmailValid(Myform.email.value) !="0") { txt=txt+"- อีเมล์ไม่ถูกต้อง\n"; }}
if(txt!=""){alert('กรุณากรอกข้อมูลเหล่านี้\n'+txt);return false;}return true;}
</script>
