/** * create a forum * @param string title * @param string text/description * @return added forum's id */ function createForum($title, $text, $course_id) { $forumsDAO = new ForumsDAO(); $forums_id = $forumsDAO->Create($title, $text); $forumsCoursesDAO = new ForumsCoursesDAO(); $forumsCoursesDAO->Create($forums_id, $course_id); return $forums_id; }
/** * Delete row by course ID * @access public * @param courseID * @return true or false * @author Cindy Qi Li */ function DeleteByCourseID($courseID) { include_once TR_INCLUDE_PATH . 'classes/DAO/ForumsDAO.class.php'; $forumsDAO = new ForumsDAO(); $all_forums = $this->getByCourse($courseID); if (is_array($all_forums)) { foreach ($all_forums as $forums) { $forumsDAO->Delete($forums['forum_id']); } } $sql = "DELETE FROM " . TABLE_PREFIX . "forums_courses \n\t WHERE course_id = " . $courseID . ""; return $this->execute($sql); }