Create a school website with a number of different functionalities

This is a personal project to try to consolidate a number of techniques I have learned as well as expand upon my range of skills. Base idea taken from Great Stack Youtube channel for ideas and adapted: https://www.youtube.com/playlist?list=PLjwm_8O3suyP5kGKmwS_DM0Hs1j7fshi5 Additional functionality my own

Core functionality

• School splash page
• Login section with user verification
• Database of both students and teachers
• Area for teachers to enter grades for students
• Some type of display features on the main page

Additional functionality

• Features on the main page such as API calls for weather, local news in the area, etc.
• Ability for teachers to create reports for student grades, to move students from one class to another etc
• Ability for teachers to send messages to students
• Host on Heroku or similar

Languages

• Initially I intend to build the front end with HTML, CSS, Bootstrap and JS for functionality
• Backend will mainly be PHP for database interaction; Laravel to create chat functionality (later)
• Node.js will be used to make API calls for the main page/alternatively JS APIs will be used for promises/fetch requests
• Running on XAMPP server with PHPAdmin and MySQL

Learning outcomes

• Using Udemy courses on PHP and Laravel to boost back end knowledge
• Create a functional website with a back end, database, and API integration

Stages of completion:

1. Index home page - done

2. About us page - done

3. Contact page with form - done

4. MySQL database created - done

5. PHP file to read contact requests into database - done

6. Using sessions - done (sessions and cookies)

7. Changing query database writing from mysqli to PDO - done for query posting

8. Return list of items in database as a table on the teacher account - Done

9. Creating account login using database - Done

10. Password hashing - Done

11. Autoloading classes check -

12. Pagination and splitting database results up:

13. student adder and deleter: Done

14. student updater - Done (but needs work on php file to only update numbers that are entered on form and ignore others)

15. Create a new login page for students where they can then log in and post blog posts

18. move students between classes/teachers, will need joins and foreign keys -

19. have user logins bit no teachers; need a table of teachers or teacher logins -

20. Set up email form - Done

21. Enable email function and link to queries -

Other web sources used: https://www.Udemy.com https://technosmarter.com/php/PHP-Login-session-start-destroyed.html https://www.simplilearn.com/tutorials/php-tutorial/php-login-form https://phppot.com/php/php-login-script-with-session/ https://alexwebdevelop.com/user-authentication/ https://www.tutorialspoint.com/php/php_login_example.htm https://www.php.net/manual/en/features.http-auth.php https://atakde.medium.com/how-to-secure-php-sessions-f615a9760d7f