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>
