public static function findByGroupId($group_id) { $rows = parent::queryWithParameters('SELECT * FROM Topic WHERE forum_group_id = :group_id', array('group_id' => $group_id)); $topics = array(); foreach ($rows as $row) { $topics[] = Topic::createNewTopicFromResult($row); } return $topics; }
public function save() { $parameters = array('user_id' => $this->user_id, 'forum_group_id' => $this->forum_group_id); $query = 'INSERT INTO Group_Member (user_id, forum_group_id) VALUES (:user_id, :forum_group_id)'; parent::queryWithParameters($query, $parameters); }
public static function delete($id) { $parameters = array('id' => $id); $query = 'DELETE FROM Forum_Group WHERE id = :id'; parent::queryWithParameters($query, $parameters); }