gistfile1.php

<?php

    public function addReview($review) {
        return $this->insertDBObject($review);
    }

    public function saveReview($review) {
        return $this->updateDBObject($review);
    }

    public function deleteReview($review) {
        return $this->deleteDBObject($review);
    }

    public function deleteReviewById($reviewId) {
        $review = new Review();
        $review->setId($reviewId);

        return $this->deleteDBObject($review);
    }

    public function getReview($stmt) {
        return $this->selectDBObject($stmt, "Review");
    }

    public function getReviews($stmt) {
        return $this->selectDBObjects($stmt, "Review");
    }

    public function getReviewById($reviewId) {
        $query = "SELECT * FROM reviews WHERE review_id = ?";
        $stmt = $this->doSelectQuery($query, "i", array($reviewId));
        $review = $this->getReview($stmt);
        $stmt->close();

        return $review;
    }

?>