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));
}
