public function home() { $address = Address::findByIdentityId(1); $schools = School::all(0, 50); $teachers = Teacher::findBySchoolId(1); $studentContacts = StudentContact::findByStudentId(1); $classes = Sclass::findByTeacherId(1); $student = Student::findById(1); require_once 'views/identity/home.php'; }
public function listClasses() { $start = 0; if (isset($_POST['rStart'])) { $start = $_POST['rStart']; } $number = 0; if (isset($_POST['rNumber'])) { $number = $_POST['rNumber']; } else { $number = Sclass::rowCount(); } $schoolList = School::all($start, $number); $classesAtSchool = ''; $schoolName = ''; if (isset($_POST['schoolID'])) { $classesAtSchool = Sclass::getAllClassesAtSchool($_POST['schoolID'], $start, $number); $schoolName = School::findById($_POST['schoolID']); $schoolName = $schoolName->getValues(); $schoolName = $schoolName['name']; } require_once 'views/class/listClasses.php'; }
public function loadClassList() { $list = []; $db = Db::getInstance(); $request = $db->prepare('SELECT * FROM student_to_class WHERE Student_id = :id '); $request->bindParam(":id", $this->studentId, PDO::PARAM_INT); $request->execute(); foreach ($request->fetchAll() as $class) { $item = Sclass::findById($class['Class_id']); $list[] = $item->getValues(); } $this->classList = $list; }