public function save() { $parameters = array('name' => $this->name, 'password' => $this->password, 'admin' => $this->admin); $query = 'INSERT INTO Forum_User (name, password, admin) VALUES (:name, :password, :admin) RETURNING id'; $row = parent::queryWithParametersLimit1($query, $parameters); $this->id = $row['id']; }
public function save() { $parameters = array('title' => $this->title, 'forum_group_id' => $this->forum_group_id, 'creator' => $this->creator); $query = 'INSERT INTO Topic (title, forum_group_id, creator) VALUES (:title, :forum_group_id, :creator) RETURNING id'; $row = parent::queryWithParametersLimit1($query, $parameters); $this->id = $row['id']; }
public function save() { $parameters = array('author' => $this->author, 'message' => $this->message, 'topic_id' => $this->topic_id); $query = 'INSERT INTO Forum_Message (author, posted, message, topic_id) VALUES (:author, NOW(), :message, :topic_id) RETURNING id'; $row = parent::queryWithParametersLimit1($query, $parameters); $this->id = $row['id']; }
public function checkForDuplicate() { $errors = array(); $parameters = array('user_id' => $this->user_id, 'forum_group_id' => $this->forum_group_id); $query = 'SELECT * FROM Group_Member WHERE user_id = :user_id AND forum_group_id = :forum_group_id LIMIT 1'; $row = parent::queryWithParametersLimit1($query, $parameters); if ($row) { $errors[] = "Käyttäjä on jo ryhmän jäsen"; } return $errors; }
public static function findByID($id) { $row = parent::queryWithParametersLimit1('SELECT * FROM Forum_Group WHERE id = :id LIMIT 1', array('id' => $id)); return new Group(array('id' => $row['id'], 'name' => $row['name'], 'creator' => $row['creator'])); }