shriyash7777/Automatic-Certificate-Generation-System — reverse-engineered prompt

Build me a simple certificate management website for a school or training program. I want an admin dashboard where I can upload student details in CSV or Excel, manage students and courses, pick or edit certificate templates, and then generate certificate PDFs automatically. Each certificate should get a unique ID and its own QR code.

I also want a public verification page where anyone can scan the QR code or enter the certificate ID to confirm whether the certificate is real. Please store everything in a MySQL database and save the generated PDFs so they can be downloaded later. Keep the flow straightforward and usable on a local server, with clear forms and pages for uploading data, generating certificates, and verifying them online.

Use PHP for the backend and basic HTML, CSS, and JavaScript for the interface. If anything is missing, make sensible choices and look up current docs online if you need to. I want this to feel like a complete working first version, not just a demo.