public function get_student_courses($order = null)
{
LoadHelper::model('course');
$student_list = array();
//connect to database
$this->db->connect();
//query
$sql = "SELECT s.id,s.first_name,s.last_name,s.email,s.contact_no,c.id as course_id,c.course_name ";
$sql .= " FROM students s JOIN courses c on s.course_id=c.id";
if (isset($order)) {
$sql = $sql . " ORDER BY " . $order;
}
//fetchquery
$result = $this->db->fetchquery($sql);
while ($row = $result->fetch_assoc()) {
$student = new Students();
$student->set_id($row['id']);
$student->set_first_name($row['first_name']);
$student->set_last_name($row['last_name']);
$student->set_email($row['email']);
$student->set_contact_no($row['contact_no']);
$course = new Course();
$course->set_id($row['course_id']);
$course->set_course_name($row['course_name']);
$student->set_course($course);
array_push($student_list, $student);
}
$this->db->close();
return $student_list;
}
public function add()
{
LoadHelper::model("course");
LoadHelper::repository("courserepository");
$course_repository = new CourseRepository();
if (isset($_POST['submit'])) {
$student = $this->map_data();
$this->studentrepository->insert($student);
header("Location: index.php?page=student&action=success");
exit;
}
include_once ROOT_PATH . "view/student/add.php";
}
<?php
LoadHelper::model("course");
LoadHelper::repository("courserepository");
?>
<?php
class CourseController
{
private $courserepository;
public function __construct()
{
$this->courserepository = new courserepository();
}
public function index()
{
if (isset($_POST['sort'])) {
$order = $_POST['sort'];
} else {
$order = null;
}
include_once ROOT_PATH . "view/Course/index.php";
}
public function add()
{
if (isset($_POST['submit'])) {
$Course = $this->map_data();
$this->courserepository->insert($Course);
header("Location: index.php?page=course&action=success");
