Version 1.0: This is a basic single table PHP project developed over the weekend of October 21, 2017 to demonstrate to students in our CPT283 class at Greenville Tech how to use several web development tools together in order to create a simple web app. Students should review the code for this project to see how the following tools and techniques have been used in this project:
PHP PDO query structure for SELECT, INSERT, UPDATE, and DELETE queries
Twitter's Bootstrap 3 used for look and navigation
mySQL now() function and PHP date() function to create the entered and modified dates in different date layouts
PDO SELECT query for searching the database for a random string
Results page page with simple "Edit Again?" button after processing the UPDATE query
Confirmation page before processing the DELETE query
Version 2.0: Updated and expanded during the Winter Break in December 2017. New features and enhancements include:
Added variables and functions to the config.php file
Added authentication for the administrative user (admin) and moved delete to admin only
Added Bootstrap 3 colored buttons for forms and URL links
Changed Release Year and Movie Rating to separate static tables in the database
Added Stars, Genre, and IMDb Rating to the app, including static tables for Genre
Changed input form control to select form control for the Release Year, Movie Rating, and Genre variables on the Add and Edit screens
Enhanced the Edit screens to highlight the current variable when editing in the select control
Confirmation of movie added to database with option to edit new record
Modified admin delete confirmation page to include the name of the movie about to be deleted
Added movie count query to config.php so output can be accessed on all pages if wanted
Created movie details report for each movie with links on the movie list page
Implemented $app_URL and $app_root variables set in config.php to better control links in app navigation
Changed app name above navigation bar to a link to the index.php file for either the app or the admin section for the app
Used various date function display formats for date added and date modified to demonstrate flexible date formats
Added more developer documentation to the separate pages