function getBookings($userId)
{
ini_set('display_errors', 'On');
$db = "w4111c.cs.columbia.edu:1521/adb";
$conn = oci_connect("kpg2108", "test123", $db);
$stmt = oci_parse($conn, "Select T.ticket_id, F.FLIGHT_DESC,C.CLASS_NAME,T.BOOKING_DATE,F.DEPARTURE_DATE,AA.A_NAME,A.A_NAME,FC.COST , T.TICKET_MILES from ticket t join flight_class fc on T.FLIGHT_CLASS_ID=FC.FLIGHT_CLASS_ID JOIN FLIGHT F ON FC.FLIGHT_ID = F.FLIGHT_ID\r\n\t\tJOIN CLASS C ON FC.CLASS_ID = C.CLASS_ID JOIN ROUTE R ON F.ROUTE_ID = R.ROUTE_ID JOIN AIRPORT A ON R.DESTINATION_AIRPORT_ID = A.AIRPORT_ID\r\n\t\tJOIN AIRPORT AA ON R.SOURCE_AIRPORT_ID = AA.AIRPORT_ID WHERE T.USER_ID = " . $userId);
oci_execute($stmt);
oci_close($conn);
$arrayOfBookingDetails = array();
$count = 1;
while ($row = oci_fetch_row($stmt)) {
$boookingDetails = new BookingDetails();
$boookingDetails->setTicketId($row[0]);
$boookingDetails->setFlightName($row[1]);
$boookingDetails->setClassName($row[2]);
$boookingDetails->setBookingDate($row[3]);
$boookingDetails->setDepartureDate($row[4]);
$boookingDetails->setSource($row[5]);
$boookingDetails->setDestination($row[6]);
$boookingDetails->setFare($row[7]);
$boookingDetails->setTicketMiles($row[8]);
array_push($arrayOfBookingDetails, $boookingDetails);
$count = $count + 1;
}
foreach ($arrayOfBookingDetails as $value) {
echo $value->getFare();
}
//$arrayOfBookings=
return $arrayOfBookingDetails;
}
