raphaelJ189/OpenSource_Assignment_CS2_Group06 — reverse-engineered prompt

Build me a simple Student Record Management System for a primary or secondary school in Tanzania. I want it to be a straightforward PHP and MySQL web app where an admin or teacher can sign in, register new students, view all student records, search by registration number, and edit or delete student details. There should also be an admin area for creating and updating teacher accounts, plus a basic dashboard that shows useful summary info at a glance.

Please keep the interface clean and easy to use with plain HTML, CSS, and a little JavaScript where needed. Make sure login and database access are handled safely, and set it up so the database tables can be created automatically the first time the app runs, including a default admin account if one does not exist yet. I also want it ready to run locally and easy to deploy with Docker on Render using environment variables for the database settings. Look up current docs online if you need to.