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