61 lines
1.8 KiB
PHP
61 lines
1.8 KiB
PHP
|
<?php
|
||
|
|
require_once('../../utils/config.php');
|
||
|
|
require_once('../../utils/db.php');
|
||
|
|
require_once('../../utils/strings.php');
|
||
|
|
|
||
|
|
$connection = connect();
|
||
|
|
|
||
|
|
$returnValue = array();
|
||
|
|
$querystr = "SELECT * FROM li_students";
|
||
|
|
|
||
|
|
|
||
|
|
$result = mysqli_query($connection, $querystr);
|
||
|
|
if($result->num_rows !== 0) {
|
||
|
|
while ($row = mysqli_fetch_object($result)) {
|
||
|
|
$student = (object) [
|
||
|
|
'sid' => $row->sid,
|
||
|
|
'firstname' => $row->firstname,
|
||
|
|
'lastname' => $row->lastname,
|
||
|
|
'birthday' => $row->birthday,
|
||
|
|
'gender' => $row->gender,
|
||
|
|
'street' => $row->street,
|
||
|
|
'house' => $row->house,
|
||
|
|
'house_suffix' => $row->house_suffix,
|
||
|
|
'zip' => $row->zip,
|
||
|
|
'city' => $row->city,
|
||
|
|
'phone' => $row->phone,
|
||
|
|
'email' => $row->email,
|
||
|
|
'enrollments' => array()
|
||
|
|
];
|
||
|
|
|
||
|
|
$querystr2 = "SELECT * FROM li_enroll, li_courses
|
||
|
|
WHERE li_enroll.cid = li_courses.cid
|
||
|
|
AND li_enroll.sid = {$student->sid}";
|
||
|
|
|
||
|
|
$result2 = mysqli_query($connection, $querystr2);
|
||
|
|
if($result2->num_rows !== 0) {
|
||
|
|
while ($row = mysqli_fetch_object($result2)) {
|
||
|
|
$begin = new DateTime($row->begin);
|
||
|
|
$end = new DateTime($row->end);
|
||
|
|
|
||
|
|
$enrollment = (object) [
|
||
|
|
'cid' => $row->cid,
|
||
|
|
'name' => $row->name . ' ' . $row->description,
|
||
|
|
'diffname' => $row->diffname,
|
||
|
|
'begin' => $begin->format('Y-m-d'),
|
||
|
|
'end' => $end->format('Y-m-d')
|
||
|
|
];
|
||
|
|
|
||
|
|
array_push($student->enrollments, $enrollment);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
array_push($returnValue, $student);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
mysqli_free_result($result);
|
||
|
|
|
||
|
|
header("Access-Control-Allow-Origin: *");
|
||
|
|
echo json_encode($returnValue);
|
||
|
|
?>
|