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;
}
/**
* @param $id
* @return User
*/
public function retCreatedUser($id = 0)
{
$user = new User();
if (0 < $id) {
$user->setId($id);
} else {
$user->setId(0);
// dump user
}
$userRepository = new UserRepository($user);
$user->setRepository($userRepository);
$data = $user->getRepository()->getUserData();
foreach ($data as $identifier => $value) {
$func = 'set' . ucfirst($identifier);
$user->{$func}($value);
}
return $user;
}
