<p id="footer" > Copyright © 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 "); // ";