Example #1
0
 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;
 }
Example #2
0
 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);
 }
Example #3
0
 public static function delete($id)
 {
     $parameters = array('id' => $id);
     $query = 'DELETE FROM Forum_Group WHERE id = :id';
     parent::queryWithParameters($query, $parameters);
 }