Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/manage/teacher/ drwxr-xr-x |
Viewing file: InsertFormRoom.php (6.19 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") && !session_is_registered("Priority") ) { 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( "../include/Function.php" ); require_once( "../includes/FunctionDB.php" ); /** Create Database Object */ $dbObj = new DBConn; //=== SESSION $Username = $Username; /** Config Table for This Page **/ $myTable1 = "personal_tb"; $myTable2 = "formcaroffice"; $myTable2PK = "carId"; /** Table --> personal_tb */ $query1 = " SELECT * FROM $myTable1 WHERE Teacher_code='$Teacher_code' "; $result1 = $dbObj->execQuery($query1); $rs1 = $dbObj->fetchArray($result1); $Teacher_code = $rs1['Teacher_code']; $query2 = " SELECT max(Rent_code) AS Rent_code FROM room_rent "; $result2 = $dbObj->execQuery($query2); $rs2 = $dbObj->fetchArray($result2); /** Receive values */ $Rent_code = $rs2['Rent_code'] +1 ; $RoomNo = "สธ.0203.081/ ".$Rent_code; $Teacher_code = $rs1['Teacher_code']; $Faculty_code = $rs1['Faculty_code']; $Rent_date = dmyE2ymdE2($_REQUEST['mDate']); $Room_code = trim( $_POST['Room_code'] ); $Date_start = dmyE2ymdE2($_REQUEST['mDate2']); // $Time_start = htmlspecialchars(trim($_POST['Time_start'])); $Date_finish = dmyE2ymdE2($_REQUEST['mDate3']); // $Time_finish = htmlspecialchars(trim($_POST['Time_finish'])); $Topic = trim( $_POST['Topic'] ); $Make = trim( $_POST['Make'] ); $Check_format = trim( $_POST['Check_format'] ); $Detail_format = trim( $_POST['Detail_format'] ); $Check_tool = trim( $_POST['Check_tool'] ); $Detail_tool = trim( $_POST['Detail_tool'] ); $Check_food = trim( $_POST['Check_food'] ); $Detail_food = trim( $_POST['Detail_food'] ); $Status = 'รออนุมัติ'; $Detail = trim( $_POST['Detail'] ); $hr = trim($_POST["hr"]); $mn = trim($_POST["mn"]); $hr1 = trim($_POST["hr1"]); $mn1= trim($_POST["mn1"]); if(strlen($hr)==1) { $hour = "0".$hr; } else { $hour = $hr; } if(strlen($mn)==1) { $min = "0".$mn; } else { $min = $mn; } //------------------------------ if(strlen($hr1)==1) { $hour1= "0".$hr1; } else { $hour1 = $hr1; } if(strlen($mn1)==1) { $min1 = "0".$mn1; } else { $min1 = $mn1; } $Time_start = $hour.".".$min; $Time_finish = $hour1.".".$min1; //----------------------------------------------------------------- $sql = "SELECT * FROM room_rent WHERE Room_code='$Room_code' AND (('$Date_start' BETWEEN Date_start AND Date_finish) OR ('$Date_finish' BETWEEN Date_start AND Date_finish) OR (Date_start BETWEEN '$Date_start' AND '$Date_finish')OR (Date_finish BETWEEN '$Date_start' AND '$Date_finish')) AND (('$Time_start' BETWEEN Time_start AND Time_finish) OR ('$Time_finish' BETWEEN Time_start AND Time_finish) OR (Time_start BETWEEN '$Time_start' AND '$Time_finish') OR (Time_finish BETWEEN '$Time_start' AND '$Time_finish'))"; //echo $sql; $result=mysql_query($sql); $row=mysql_fetch_array($result); if($row) { echo "<body onload=\"window.alert('มีการจองห้องประชุมนี้แล้ว');location.href='RentRoom.php?Teacher_code=$Teacher_code';\">"; exit; } InsertFormRoom( $Rent_code, $RoomNo, $Teacher_code, $Faculty_code, $Rent_date, $Room_code, $Date_start, $Time_start , $Date_finish, $Time_finish, $Topic, $Make, $Check_format, $Detail_format, $Check_tool, $Detail_tool, $Check_food, $Detail_food,$Status,$Detail) ; } # else ?> <!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> <meta http-equiv="Content-Type" content="text/html; charset=windows-874" /> <link href="../css/default.css" rel="stylesheet" type="text/css" /> <script language="javascript" src="../js/utilities.js"></script> <title>ข้อมูลทั่วไปบุคลากร - ข้อมูลการพัฒนาบุคลากร - เพิ่มข้อมูลประวัติการพัฒนาตนเอง</title></head> <body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0"> <?php include("../templates/incHeader.php"); ?> <table width="1003" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="203" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td> <td width="800" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset> <table width="780" border="0" cellspacing="0" cellpadding="0"> <form id="pc" name="pc" method="post" action="<?=$PHP_SELF;?>?page=<?=$page;?>"> <tr> <td height="5"></td> </tr> <tr> <td height="30" background="../images/background/bg-head-topic-w780.gif" class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>» <a href="Menu_Teach.php?Teacher_code=<?=$Teacher_code;?>">ข้อมูลทั่วไปบุคลากร</a> » <a href="TrainingList.php?Teacher_code=<?=$Teacher_code;?>">ข้อมูลการพัฒนาบุคลากร</a> » <span class="NOTE">เพิ่มข้อมูลการขอใช้ห้องประชุม</span></strong></td> </tr> <tr> <td> </td> </tr> <tr> <td height="150" align="center"><span class="TEXT-GREEN10"><strong>ระบบจัดเก็บข้อมูลของท่านเรียบร้อยแล้ว</strong></span><br /> กรุณารอส้กครู่ กำลังเปลี่ยนหน้าอัตโนมัติ<br /> <?php echo "<meta http-equiv=\"refresh\" content=\"1; URL=FormRoomList.php?Teacher_code=$Teacher_code\">"; ?></td></td> </tr> <tr> <td height="234"> </td> </tr></form> </table> </fieldset></td> </tr> </table> <?php include("../templates/incFooter.php"); ?> </body> </html> <?php /** Free Resource */ $dbObj->freeresult($result0); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0056 ]-- |