Exemplo n.º 1
0
 /**
  * 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;
     }
 }
Exemplo n.º 2
0
 /**
  *  Add Review
  * 
  * @param $data array
  */
 public function addReview($data = array())
 {
     $qb = new QUeryBuilder($this->db);
     $qb->insert('reviews')->setValue('autor', '?')->setValue('text', '?')->setValue('ip_address', '?')->setValue('date', '?')->setParameter(0, $data['autor'])->setParameter(1, $data['text'])->setParameter(2, $data['ip_address'])->setParameter(3, $data['date'])->execute();
 }