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;
}
header("Location: ../controller/Controller.php");
}
}
}
}
}
$show_form = true;
if (isset($_POST['Write'])) {
$validator = new FormValidator();
$validator->addValidation("journeyDate", "req", "Please select a journey date");
$validator->addValidation("reviewDescription", "req", "Please enter a review description");
if ($validator->ValidateForm()) {
$review = new Review();
$review->setFlightId($_REQUEST['flightId']);
$review->setTravelDate($_REQUEST['journeyDate']);
$review->setReviewDescription($_REQUEST['reviewDescription']);
$_SESSION['review'] = serialize($review);
$_SESSION['action'] = "insertReview";
header("Location: ../controller/Controller.php");
} else {
echo "<B>Validation Errors:</B>";
$error_hash = $validator->GetErrors();
foreach ($error_hash as $inpname => $inp_err) {
echo "<p>{$inpname} : {$inp_err}</p>\n";
}
}
}
$disp_journeyDate = isset($_POST['journeyDate']) ? $_POST['journeyDate'] : '';
$disp_reviewDescription = isset($_POST['reviewDescription']) ? $_POST['reviewDescription'] : '';
?>
