Create a file titled writeFilms.php$.$ This file should query your database to find all the movies for each category. You need to write to a text file a record for each category. The record should contain the film category, the number of films in the category, and a list of the films. You should also write this information to an HTML table with $3$ columns. Column $1$ is category, Column $2$ is a count of movies in the category, column $3$ is a comma delimited list of the movies in the category. Use the format shown below for your text file. Both the html table and the text file should be sorted by category.

Category:number of films:filmTitle$1,$filmTitle$2$;

For example $($fake data for example purposes$)$:

Comedy:$2$:Berets Agent,Boiled Dares;

You may use any combination of SQL $/$ PHP you wish. You can write a fancy SQL statement to do some processing for you, or you can simply use SQL to $$grab$$ the info from the database, then use PHP to process the info. Film category can be used as a key in an associative array.

Task $2$

For this task you will create a reverse SHA lookup website. A user will be able to provide a SHA hash value, and you should present the string that created the SHA value. You are given $3$ input files, sha$1\_$list.txt$,$ sha$224\_$list.txt$,$ and sha$256\_$list.txt$.$ Each file has the given word followed by its hash value, separated by a colon. Each file uses the algorithm specified in the file name.

A user should be able to access an html file called html$,$ and enter a sha hash value that will be submitted to a file called sha.php$.$

The sha.php file should load the information from the $3$ text files into a data structure of your choice. $($note that the hash values are unique among all $3$ files, so you can use the hash value as a key in an associative array$).$ Next, the php script should search for the string that generated the given hash value.

Your php script should generate a dynamic html file that displays the hash value that was searched for, along with either the string that generated the hash value, or a message indicating that the value could not be found in the server$$s records.

You should include a button and an input form that allows the user to search for another string and triggers the same php script again. $($You simply set the action field of the form to point back at the sha.php file. Make sure your post array variable is set correctly again as well$)$

Task $3$

Design and create a survey database entity$-$relationship diagram. Your model should also be able to track each student$$s survey response. A survey question can be one of two types: multiple choice, text$-$based. The question should be stored in some tables. Create appropriate relationships. Include appropriate attributes. Make sure to indicate primary keys for each Entity Set. Include multiplicities. You should have between $4$ and $8($inclusive$)$ entity sets.