/** Define Validate Access */ define( '_VALID_ACCESS', 1 ); /** Configuration */ require_once( "./configuration.php" ); require_once( $_Config_absolute_path . "/includes/framework.php" ); require_once( "./include/Function.php" ); require_once( "./include/FunctionDB.php" ); require_once( "./calendar/check.php" ); require_once( "./calendar/cal_func.php" ); /** Create Database Object */ $dbObj = new DBConn; //=== SESSION $Username = $valid_user; /** Config Table for This Page */ $myTable1 = "personal_tb"; $myTable2 = "room_rent"; /** Table --> tech_plan_tb */ //$query1 = " SELECT * FROM $myTable2 LEFT JOIN room_tb ON room_rent.Room_code=room_tb.Room_code WHERE $now_stamp BETWEEN Date_start= '$now_stamp' "; $query1 = " SELECT * FROM room_rent LEFT JOIN room_tb ON room_rent.Room_code=room_tb.Room_code WHERE '$now_stamp' BETWEEN Date_start and Date_finish "; $result1 = $dbObj->execQuery($query1); $rs1 = $dbObj->fetchArray($result1); $numrows = $dbObj->_numrows; ?>
freeresult($result1); /** Close the Database */ $dbObj->disconn(); /** Unset Class */ unset($dbObj); ?>