Internet Computing HW

Internet Computing Spring 2024 Homework 3 In this assignment, your task is to create a web application which can process the following movie database. This database contains only one table. Use the sql file on Canvas, also listed here, to create the database like the following The sql file — CREATE DATABASE MSU_Movies — DROP DATABASE IF EXISTS MSU_Movies; CREATE DATABASE MSU_Movies; USE MSU_Movies; — CREATE TABLE Movie; CREATE TABLE Movie ( MovieID INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, MovieTitle varchar (30) NOT NULL, ReleaseDate DATE NOT NULL, Genre varchar(30) NOT NULL ); — Populate movie data INSERT INTO Movie VALUES (1, ‘Superman vs Batman’, ‘2016-03-25’, ‘Action’), (2, ‘Deadpool’, ‘2016-02-12’, ‘Comedy’), (3, ‘Furious 7’, ‘2015-04-03’, ‘Thriller’), (4, ‘PK’, ‘2014-12-19’, ‘Drama’), (5, ‘The Hangover’, ‘2009-06-05’, ‘Comedy’), (6, ‘3 Idiots’, ‘2009-12-25’, ‘Drama’), (7, ‘Spectre’, ‘2015-11-06’, ‘Thriller’), (8, ‘Batman Begins’, ‘2005-06-15’, ‘Action’), (9, ‘The Dark Knight’, ‘2008-07-18’, ‘Crime’); — Create the users and grant priveleges to those users — assume you have already run the book_apps create_db.sql file when you download from GRANT SELECT, INSERT, DELETE, UPDATE ON MSU_Movies.* TO mgs_user@localhost Your database.php file would be similar as in chapter4 except the database is now change from my_guita_shop1 to MSU_Movies. When user visit your site, the landing page like the following will be displayed. Note: PUT ALL members’ names on the second line after MSU Movie Center. Insert User can insert a new movie by click on Add A New Movie link on top of the page A web form like the following will show up Assuming we entered the following Click Insert Movie button. Your app will automatically display the newly changed move table. EDIT (update) Assuming we want to change the genre as Drama. So let’s click Edit button (the update operation) When the Edit button was pressed, the following form appeared with the information of this movie retrieved from our database. Now change Action to become Drama and click Update Movie button. Your app will automatically list all the movies again with the genre of the record updated to Action as the following The table on your database is now modified Delete Let’s delete Gladiator, the newly updated movie, by clicking on its corresponding Delete button. The result as the following. Requirements and submission: – – Use PHP as server side scripting language. Name your controller index.php Use mgs_user credential to access the MSU_Movies database. Use xampp as platform to develop your application. Put all your members’ full names below MSU Movie Center on each web page when run The bottom of each page contains copyright year of MSU as shown above Create a PPT file contains o All members’ names and contribution in percentage o List features implemented o List features did not implemented. Create a short video to demo your web site (i.e., demo insert, delete and update) Create a folder o Put all source code files, PPT file, and MP4 (YT link is even better) into the folder Zip this folder. Submit the zipped folder file to Canvas

Internet Computing HW

We offer the best custom writing paper services. We have answered this question before and we can also do it for you.


We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.