/** * 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; } }
/** * 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(); }