function search() { include_once "course_outline.php"; $obj = new course_outline(); $txt = $_REQUEST['search']; if (!$obj->search($txt)) { echo '{"result":0, "message":"Searched Item does not exists"}'; return; } $row = $obj->fetch(); echo '{"result":1,"outlines":['; while ($row) { echo json_encode($row); $row = $obj->fetch(); if ($row) { echo ","; } } echo "]}"; }
</div> </td> </tr> </table> <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'];
$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 "); // ";
<ul class="nav nav-pills"> <li role="presentation" class="active" onclick="update()"><a href="#">Update</a></li> <li role="presentation" class="active" onclick="delete_c()"><a href="#">Delete</a></li> </ul> <table> <tr> <td id="content"> <div id="divStatus" class="status"> status message </div> <div id="divContent" class="viewOutline"> <?php include "course_outline.php"; $obj = new course_outline(); if (isset($_REQUEST['id'])) { $course = $_REQUEST['id']; echo "<input type='hidden' id='cid' name='cid' value={$course}>"; $result = $obj->getCourseById($course); $schedule = $obj->getCourseScheduleById($course); echo '<table id="viewOutline" name="viewOutline">'; echo '<tr> <td><span><span class="headers">Course ID: </span> <span class="inline" id="course_id" name="course_id">' . $result["course_id"] . '</span></span>'; echo '          <span><span class="headers"> course Name:</span> <span class="inline" id="course_name" name="course_name">' . $result["course_name"] . ' </span></span></td></tr>'; echo '<tr><td><span><span class="headers"> Course Objectives:</span> <div id="course_objective" name="course_objective">' . $result["course_objectives"] . '</div> </span></td></tr>'; echo '<tr><td><span><span class="headers"> Course Description:</span> <div id="course_description" name="course_description">' . $result["course_descriptions"] . '</div></span></td></tr>'; echo '<tr><td><span><span class="headers"> Learning Goals: </span><div id="learning_goals" name="learning_goals"> ' . $result["learning_goals"] . '</div> </span></td></tr>'; echo '<tr><td> <span> <span class="headers">Course Schedule:</span> <table id="course_schedule" name="course_schedule" border="1"> <tr id="schedule_header" name="schedule_header"> <td> Weeks</td> <td> Topics</td> <td>Readings</td> <td>Milestones</td></tr>'; while ($row = $obj->fetch()) {