function getReview($flightDesc) { ini_set('display_errors', 'On'); $db = "w4111c.cs.columbia.edu:1521/adb"; $conn = oci_connect("kpg2108", "test123", $db); $stmt = oci_parse($conn, "Select u.fname,f.flight_desc,r.travel_date,r.description from review r join flight f on R.FLIGHT_ID = F.FLIGHT_ID join users u on R.USER_ID = u.user_id where F.FLIGHT_DESC = '" . $flightDesc . "'"); oci_define_by_name($stmt, 'NUM_ROWS', $this->num_rows); oci_execute($stmt); oci_close($conn); $arrayOfReviewDetails = array(); while ($row = oci_fetch_row($stmt)) { $review = new Review(); $review->setFlightName($row[0]); $review->setFlightDescription($row[1]); $review->setTravelDate($row[2]); $review->setReviewDescription($row[3]); array_push($arrayOfReviewDetails, $review); } return $arrayOfReviewDetails; }
} else { if (array_key_exists('flagForEditProfile', $_REQUEST) && $_REQUEST['flagForEditProfile']) { $_SESSION['action'] = "displayUser"; header("Location: ../controller/Controller.php"); } else { if (array_key_exists('flagForSearch', $_REQUEST) && $_REQUEST['flagForSearch']) { $_SESSION['action'] = "searchFlights"; header("Location: ../controller/Controller.php"); } else { if (array_key_exists('flagForWriteReview', $_REQUEST) && $_REQUEST['flagForWriteReview']) { $_SESSION['action'] = "writeReview"; header("Location: ../controller/Controller.php"); } else { if (isset($_POST['Search'])) { $review = new Review(); $review->setFlightDescription($_REQUEST['flightDescription']); $_SESSION['review'] = serialize($review); $_SESSION['action'] = 'displayReview'; header("Location: ../controller/Controller.php"); } ?> <form action="" theme="simple" method="POST" name="readReviewsForm"> <input type="hidden" name ="flagForHome" id="flagForHome"/> <input type="hidden" name ="flagForLogOut" id="flagForLogOut"/> <input type="hidden" name ="flagForSearch" id="flagForSearch"/> <input type="hidden" name ="flagForEditProfile" id="flagForEditProfile"/> <input type="hidden" name="flagForWriteReview" id="flagForWriteReview"/> <table class="tableborder1" align="center"> <tr>