Note: Just looking for some pointers here on the scripting involved; I don't need any documentation, screenshots, etc

The SMT Movie Rental needs a system for its clients to search movies online. You are required to develop an online movie search application. Specifications and Requirements Develop the application with PHP and MySQL. The SMT Movie Rental provides an MS-Excel file that contains the list of movies to be used in the application. o The file contains around 2300 movies. You will need to find a way to generate SQL scripts to store the movie records in an appropriate database table, MySQL database. The application will access the movies database stored in the server. Address what develop and run environment are used, e.g. what tools will be used for design and development. How you will set up server-side environment and database base. o Identify any ambiguity in the specifications and requirements, and clarify them before designing the application. Design the application o Produce the prototype of the user interface in a visual format such as in images or template web site. Include website navigation hierarchy. o Provide the database design, create database and validate it against the design, e.g. database structure. o Save your design separately before developing the application. o Implement appropriate forms of user inputs and develop the application. Use HTLM forms elements with CSS for your design. o Design separate web modules/components, e.g. header, footer modules to be included Develop the application. The application must: o Have a search form, searchable by the title, genre, rating and year. For example, Search movies by genre (Comedy or SciFi) with Rating (PG) before 1995. o Display the full details of each movie found. If no movie is found, the application will display a user-friendly message. o Have an option to display a chart image of top 10 most frequently searched movies. Provide a test documentation o Test your code against the PEAR code standard with an appropriate static analysis tool, e.g. PHP_CodeSniffer ? Fix the errors detected. E.g. you can use the PHP Code Beautifier utility. o Demonstrate software risk analysis and provide a simple report. ? Identify potential software risks or problems, e.g. Possible invalid user inputs that cause unexpected behaviour? Is requirements incomplete? Security issues? o Test and validate with sample inputs with screenshots. Test the logic of the contents of the application. Validate the consistency between the code and the software design. Include testing in various browsers, e.g. Chrome and Firefox. o Provide an evidence that you adjusted your application base on the test.

Submit: o Web files. Save the main page as index.php in the root directory. o The SQL scripts of the movies database and table(s) generation in a text file as movies.sql ? NOTE: The assessor will copy your SQL statements (exactly as it is) and run to create the database/table/records you used in your program. All the database records required in your program must be correctly created. Test your SQL statements before submit. o Your source files must have enough comments o Test documentation and all your answers to the questions above. o Screenshots of application running.