public function getAllMessagesWithNick() { $sql = "\n SELECT u.nick, m.message, m.date\n FROM Message m\n INNER JOIN User u ON u.id = m.id_user\n ORDER BY m.date DESC, u.nick\n "; $data = $this->db->execute($sql)->getData(); foreach ($data as $key => $row) { $data[$key]['message'] = nl2br($data[$key]['message']); } return $data; }
public function getMessages() { $sql = "select u.nick, m.message from Message m inner join User u on u.id = m.id_user where id_user=:id_user"; $result = $this->db->execute($sql, array('id_user' => $this->user->getId()))->getData(); foreach ($result as $key => $row) { $result[$key]['message'] = nl2br($result[$key]['message']); } return $result; }
public function deleteProduct($id) { $sql = "delete from Product where id=:id"; $this->db->execute($sql, array('id' => $id)); }