AbiruzzamanMolla/Advance-Blog-PHP-Starter-Project — reverse-engineered prompt

Build me a simple but complete blog CMS website that runs locally in PHP with a MySQL database.

I want a public blog where visitors can browse posts, open a single post page, search, filter by category, view author pages, and see recent content. It should also have comments, a contact page, and basic pagination so longer lists are easy to browse. For users, add registration, login, logout, profile pages, profile editing, and change password. Show useful profile details like join date and last login, and let users have their own section.

I also want an admin area with a dashboard to manage posts, categories, comments, users, messages, and notifications for things like pending posts or comments. Keep the design clean and responsive with a Bootstrap style look.

Please wire up the database from the included SQL file, make the main flows actually work end to end, and fix any obvious security or login issues you notice while setting it up. If you need to, look up current PHP and MySQL docs online while building it.