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()) {
