<?php
require '../vendor/autoload.php';

Flight::register('db', 'PDO', array('mysql:host=localhost:3306;dbname=studenti','root',''));

Flight::route('/', function(){
    echo 'hello world!';
});

// return all students info from database
Flight::route('GET /students', function(){
    $students = Flight::db()->query('SELECT * FROM students', PDO::FETCH_ASSOC)->fetchAll();
    Flight::json($students);
});

// add student to database
Flight::route('POST /student', function(){
    $request = Flight::request()->data->getData();
    $insert = "INSERT INTO students (name, surname, birth_date, address, phone_number) VALUES(:name, :surname, :birth_date, :address, :phone_number)";
    $stmt= Flight::db()->prepare($insert);
    $stmt->execute($request);
});

// return all courses info from database
Flight::route('GET /courses', function(){
    $courses = Flight::db()->query('SELECT * FROM courses', PDO::FETCH_ASSOC)->fetchAll();
    Flight::json($courses);
});

// add course to database
Flight::route('POST /course', function(){
    $request = Flight::request()->data->getData();
    $insert = "INSERT INTO courses (name, lecture_hours, practice_hours, ects) VALUES(:name, :lecture_hours, :practice_hours, :ects)";
    $stmt= Flight::db()->prepare($insert);
    $stmt->execute($request);
});

// return all courses from database for selected student
Flight::route('GET /student_courses/@student_id', function($id){
    $courses = Flight::db()->query('SELECT course FROM student-course WHERE id=:id', PDO::FETCH_ASSOC)->fetchAll();
    Flight::json($courses);
});

// add student course to database


//  remove student course from database
Flight::route('DELETE /student_course/@id', function($id){
    $delete = "DELETE FROM student_course WHERE id = :id";
    $stmt= Flight::db()->prepare($delete);
    $stmt->execute([":id" => $id]);
});

Flight::start();
?>