Exemple #1
0
		<p id="footer" >
					Copyright &copy Webtech Group 9
				</p>

	</div>
	<?php 
include_once "course_outline.php";
if (isset($_REQUEST['course_id']) && isset($_REQUEST['course_name']) && isset($_REQUEST['course_readings']) && isset($_REQUEST['course_evaluations']) && isset($_REQUEST['course_description']) && isset($_REQUEST['learning_goals']) && isset($_REQUEST['course_objective'])) {
    $courseId = $_REQUEST['course_id'];
    $tablename = "schedule" . $courseId;
    $obj = new course_outline();
    $rows = $_REQUEST['tablerows'];
    for ($i = 1; $i < $rows + 1; $i++) {
        $week = $_REQUEST['weeks' . $i];
        $topic = $_REQUEST['topics' . $i];
        $reading = $_REQUEST['readings' . $i];
        $milestone = $_REQUEST['milestones' . $i];
        $obj->addSchedule($tablename, $week, $topic, $reading, $milestone);
    }
    $courseName = $_REQUEST['course_name'];
    $courseReadings = $_REQUEST['course_readings'];
    $courseDescription = $_REQUEST['course_description'];
    $learningGoals = $_REQUEST['learning_goals'];
    $courseObjetives = $_REQUEST['course_objective'];
    $courseEvaluation = $_REQUEST['course_evaluations'];
    $courseDept = $_REQUEST['course_dept'];
    $res = $obj->addCourse($courseName, $courseId, $courseObjetives, $courseReadings, $courseDescription, $courseEvaluation, $learningGoals, $courseDept);
}
?>
</body>
</html>	
        $result = $this->query($script);
        if (!$result) {
            return false;
        }
        return $this->fetch();
    }
    public function deleteCourse($course_id)
    {
        $this->connect();
        $sql = "delete from course_outline where course_id={$course_id}";
        $res = $this->query($sql);
        return $res;
    }
    public function deleteSchedule($id)
    {
        $this->connect();
        $sql = "drop table if exists schedule" . $id;
        $res = $this->query($sql);
        return $res;
    }
    public function search($txt)
    {
        $sql = "select * from course_outline where course_id like '%{$txt}%' or course_name like '%{$txt}%'  or course_dept like '%{$txt}%' ";
        $res = $this->query($sql);
        return $res;
    }
}
//<?php include_once('course_outline');
$obj = new course_outline();
$obj->addSchedule("+tablename+", " +week ", " +topic+", "+ reading + ", "milestone ");
// 	";