/** * Add Like * * @param $id, $likes * @return $likes */ public function addLike($id, $likes) { $likes++; $qbr = new QUeryBuilder($this->db); $qbr->update('reviews')->set('likes', '' . $likes . '')->where('id=' . $id . '')->execute(); $qbl = new QUeryBuilder($this->db); $qbl->insert('likes')->setValue('id_review', $id)->setValue('ip_address', '"' . $_SERVER["REMOTE_ADDR"] . '"')->execute(); return $likes; }
/** * 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(); }