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; }
$_SESSION['action'] = "readReview"; 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'] : ''; ?>