$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', // 'rating' =>'3' , // 'types' => $types
$method = $_GET['r']; switch ($method) { case 'selectUser': echo selectUser(); break; case 'selectLastShare': echo selectLastShare(); break; case 'selectMyPrize': echo selectMyPrize(); break; case 'selectCredits': echo selectCredits(); break; case 'selectHotels': echo selectHotels(); break; case 'selectComments': echo selectComments(); break; case 'addComment': echo addComment(); break; case 'addUser': echo addUser(); break; case 'updateShareEvent1': echo updateShareEvent1(); break; case 'updateShareEvent2': echo updateShareEvent2();