$hotelArray = array();
if (!empty($_POST['Query'])) {
$Hsql = $_POST['Query'];
$Tsql = $_POST['TQuery'];
$Newsql = $_POST['Query'];
$Newsql .= " order by";
$Newsql .= getOrderStr($_POST['a']);
$Newsql .= getOrderStr($_POST['b']);
$Newsql .= getOrderStr($_POST['c']);
$Newsql .= getOrderStr($_POST['d']);
$Newsql .= getOrderStr($_POST['e']);
$Newsql = rtrim($Newsql, ",");
$hotelArray = selectHotels2($Newsql, $Tsql);
} else {
$Hsql = genHotelQuery();
$Tsql = genRoomTypeQuery('###', '***');
//echo $Hsql;
$hotelArray = selectHotels($Hsql);
}
//echo "Here: $Hsql<hr>";
//echo "Here: $Tsql";
//echo "$startDate,$endDate";
// $types = array(
// array('A' ,'180','60'),
// array('B' ,'280','60'),
// array('C' ,'380','60')
// );
// $hotel = array(
// 'name' =>'Bohua Hotel' ,
// 'addr' =>'Prince George Park' ,
// 'ph' => '123-45678',
function selectHotels($Hsql)
{
//echo "$Hsql<hr>";
$hotelArray = array();
putenv('ORACLE_HOME=/oraclient');
// connect
$conn = oci_connect('a0091794', 'crse1410', 'sid3');
//echo "select name from Customer where email='$email' and password='******'";
$select = oci_parse($conn, $Hsql);
oci_execute($select, OCI_DEFAULT);
while ($row = oci_fetch_array($select)) {
//name, address, rating, facility, phone_no
//room_type, room_price, room_quantity
$name = $row[NAME];
$addr = $row[ADDRESS];
$rate = $row[RATING];
$facility = $row[FACILITY];
$ph = $row[PHONE_NO];
$Tsql = genRoomTypeQuery($name, $addr);
//echo "$Tsql<hr>";
$Tselect = oci_parse($conn, $Tsql);
// echo $Tsql;
// echo '<hr>';
oci_execute($Tselect, OCI_DEFAULT);
$roomArray = array();
while ($Trow = oci_fetch_array($Tselect)) {
$rType = $Trow[ROOM_TYPE];
$rPrice = $Trow[ROOM_PRICE];
$rQuantity = $Trow[ROOM_QUANTITY];
$rTemp = array($rType, $rPrice, $rQuantity);
array_push($roomArray, $rTemp);
}
if (count($roomArray) !== 0) {
$hotel = array('name' => $name, 'addr' => $addr, 'ph' => $ph, 'rating' => $rate, 'facility' => $facility, 'types' => $roomArray);
array_push($hotelArray, $hotel);
}
}
// commit
oci_commit($conn);
// disconnect
oci_close($conn);
return $hotelArray;
}
