/**
* Get All Review
*
*
*/
public function getAllReviews()
{
$qb = new QUeryBuilder($this->db);
$sql = "SELECT * FROM reviews";
$stmt = $qb->select('*')->from('reviews')->execute();
$reviews = $stmt->fetchAll();
return $reviews;
}
/**
* Valid Like
*
* @param $id
* @return true or false
*/
public function validLike($id)
{
$qb = new QUeryBuilder($this->db);
$stmt = $qb->select('*')->from('likes')->where('id_review=' . $id . ' AND ip_address="' . $_SERVER["REMOTE_ADDR"] . '"')->execute();
if ($stmt->fetchAll()) {
return false;
} else {
return true;
}
}
