Viewing file:  AddRoomTy.php (3.75 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Check Session User Login */
if (! session_is_registered("valid_user") ) {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once("../includes/FunctionDB.php");
/** Create Database Object */
$dbObj = new DBConn;
$msg = " ";
$reload = "";
if ( !empty($Room_type_name ) )
{
$Room_type_name = ereg_replace ("\"",""" ,"$Room_type_name");
$sql = "SELECT * FROM room_type_tb WHERE roomtyId ='$roomtyId' ";
$result1 = $dbObj->execQuery($sql);
$rss = $dbObj->fetchArray($result1);
$num_rows = mysql_num_rows($result1);
if($num_rows){
$query1 = " UPDATE room_type_tb SET Room_type_name ='$Room_type_name' WHERE roomtyId ='$roomtyId' ";
$result1 = $dbObj->runQuery($query1);
$dbObj->freeresult($result1);
}
else{
InsertRoomType($Room_type_name );
}
$dbObj->disconn();
unset($dbObj);
$msg = "<font color=\"#FF0000\"><strong> เพิ่มข้อมูลประเภทห้อง '<font color=\#0000FF\"> $Room_type_name </font>' COMPLETE</Strong></font> ";
$reload = "<script language=\"JavaScript\">\n";
$reload = $reload."parent.frames.nav.location.reload();\n";
$reload = $reload."</script>";
echo "<script>window.opener.document.all.myForm; window.opener.location.reload(); window.close();</script>";
//echo "<meta http-equiv=\"refresh\"content=\"2;URL=AddSource.php\">\n";
}
else {
$msg = "<font color=\"#FF0000\"><strong>ยังไม่ได้กรอกข้อมูลประเภทห้อง </Strong></font> ";
}
$query = " SELECT * FROM room_type_tb WHERE roomtyId ='$roomtyId' ";
$result = $dbObj->execQuery($query);
$rs = $dbObj->fetchArray($result);
} #else
?>
<html>
<head>
<title><?=$_Config_sitename;?></title>
<meta http-equiv="Content-Type"content="text/html; charset=windows-874" />
<link href="../css/style1.css" rel="stylesheet" type="text/css">
<head>
<body bgcolor="#FFFFFF">
<span style="text-align:center">
<? $reload; ?>
<b><? $msg; ?></b>
<br />
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><fieldset><table width="500" border="0" cellspacing="1" cellpadding="0" align="center">
<form method="post" action="<? echo $PHP_SELF; ?>">
<tr align="center" bgcolor="#F0F0F0">
<td colspan="3" class="Tahoma">บันทึกข้อมูลประเภทห้อง</td>
</tr>
<tr>
<td width="132" align=right bgcolor="#dddddd">รายการ</td>
<td width="23" bgcolor="#dddddd"> </td>
<td width="455" bgcolor="#dddddd"><input name="Room_type_name" type="text" id="Room_type_name" title="Name" value="<?=$rs['Room_type_name'];?>" size="50" /></td>
</tr>
<tr bgcolor="#006699">
<td colspan="3" align="right" bgcolor="#F0F0F0"><div align="center"><font face="Tahoma"><input type="submit" name="Submit" value=" เพิ่มข้อมูล "></font>
<input type="button" name="close" value="ปิดหน้าต่าง" onClick="window.close()" />
<input name="roomtyId" type="hidden" id="roomtyId" value="<?=$rs['roomtyId'];?>">
</div></td>
</tr>
</form>
</table></fieldset></td>
</tr>
</table>
</span>
</body>
</html>
|