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; }