Courses management application, with subjects, students, grades and registrations support

Requires PHP 7.x, MySQL 5.4.x

v0.1.1
08/04/2019
(c)Juan Luis Ramírez Tutor
Email: [email protected]
GitHub: https://github.com/jlrtutor
LinkedIn: https://es.linkedin.com/in/juan-luis-ramirez-tutor
Languages supported: english|spanish

Feel free to use this application to manage a small school, institute, academy or similar, where you have to control the student's registration, grades, etc...

Please, report any issue you may have using this application.

Installation

1. Create an empty database

    | name: university
    | user: root
    | password: [empty]

2. Change config database, if required, at file /app/config.php

3. Upload and execute "database.sql" onto your database.

4. The application is prepared to run into a folder called "university-app", so the URL would be: http://localhost/university-app

5. If the application is installed into another folder, change the path on the following file /app/config.php, line 2

   define( 'BASE_URL', '/university-app/');  //WEB directory, external path url

6. Locale (spanish default), choose english (en-EN) or spanish language (es-ES) by changing /app/config, line 10:

   define( 'LANG', 'es-ES');   //es-ES|en-EN

7. Make

   composer install

   to download and install all packages and dependencies.

8. LOGIN. Enter URL base. You must authenticate before you use this application:

    | user: [email protected]
    | password: admin

Technical notes

The framework used in this project was created from scratch, thinking on an easy and fast development.

It implements a system based on a data model, where you define basically all the fields that the model needs and its relationships with other tables or entities. So, the system can validate data automatically, for example:

$this->field('id',         'integer', ['PK'=>true, 'validate'=>false] );
$this->field('student_id', 'integer', ['FK'=>true]); //FK of Student table
$this->field('course_id',  'integer', ['FK'=>true]); //FK of Course table
$this->field('level',      'integer');
$this->field('date_of_creation','date', [ 'validate'=>false,
                                          'required'=>false, 
                                          'default'=>date('Y-m-d') ] );

Here you can see the entity registrations and its fields and relationships with other tables, like Student and Course.

These relationships make it easier to obtain information from foreign tables:

//Load object Registration
$obj_registration = new Registration($id);
//Binding with Students table
echo "The name of the students is: " . $obj_registration->getStudent()->name;
echo "And he courses " . $obj_registration->getCourse()->name;

App structure

/app
    /Http
        /Controllers
        /Models
    /public
        /views
            //...
/vendor