Movie Manager

Course project turned into a standalone container. PHP + MySQL power the movie catalog, with Bootstrap-driven pages for search, favorites, personal libraries, and an admin suite for CRUD and reporting.

App highlights

  • Movie search with title lookup and detail pages showing cast, director, and genres.
  • User auth workflow that gates personal data (library and favorites) via the logged_in flag.
  • Per-user library and favorites toggles that insert/delete from join tables without duplicates.
  • Collection builder so users can group titles into custom sets.
  • Bootstrap UI with sticky navigation for quick jumps between search, library, and favorites.

Admin & reporting

  • CRUD forms for movies, actors, directors, and genres (Insert/Delete/Update).
  • Reports page that surfaces row counts by table and cross-references movies with genres.
  • Admin dashboard to remove users and a change password flow for any account.
  • Uses the bundled movie_project_cs4604.sql seed file to recreate the schema and sample data.

Screenshots

Movie Manager login screen
Movie Manager login screen
Admin reports page
Admin reports page
User management page
User management page
Movie search results
Movie search results