Movie Mash

A PHP & MySQL movie review web application with Docker support.
Users can search, filter, and view movie reviews, and join and post polls in clubs.

Features

• Search for movies by title and release year
• Sort by release date, title, or average rating
• Pagination for large result sets
• Shows average ratings from reviews
• Session-based user authentication
• Create reviews for movies, and polls about different movie topics
• Follow your friends to see their recent reviews

Search Page: Can search for movies, clubs, and users.

Example of a club containing polls and reviews.

Organization

This repository holds:

• www: Front-end PHP server code
• mysql-init: Scripts to load demo schema and data into MySQL
• docker-compose.yml: Docker Compose setup for PHP and MySQL

Note

Demo database credentials are set in both docker-compose.yml and db.php.

Setup

Important

This app requires Docker Compose. If you prefer manual setup, you must have PHP and MySQL installed, and should change the value of $servername in db.php to "127.0.0.1".

To run a demo of this project:

1. Clone the repository

2. Build and run the containers

docker-compose up --build

3. Open your browser and navigate to the landing page at http://localhost:8080/landing.php

4. Create a new account, or use the following default account:

• Username: root
• Password: password

To end the server, run

docker-compose down

Data Sources

The dummy data used in this demo can be found at the following sources. The views reflected/expressed by this content do not reflect the actual views of the author, and was merely used as placeholder data.

• Movie Data: kaggle/harshitshankhdhar

• Sample Review Data: kaggle/lakshmi25npathi

• Additional Movie Data: Open Movie Database API

• Random Profile Data: randomuser.me

The scripts used to parse and format this data can be found in /data-formatting.