This is an urgent assignment that I want done in the next 5-7 hours. More than happy to pay extra for urgent work. It's 4 basic questions. Must know how use
PHP,
HTML, and
MySQL. The assignment description is linked.
Practice problems/Assignment description.pdf Use the HTML code included in this document to complete the following: Also use php and MySQL where necessary. /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ Problem 1 When the name and age values are entered and “Display Customer Information” button is clicked, generate a response page that displays an output similar to the following sample output: Customer Information Name: John Smith Age: 22 ___________________________________________________________________ Problem 2 Part a. Calculate and display the cost of an Uber ride. The cost of a ride is based on the number of miles and the standard rate is $3.00 per mile. Add the appropriate tip if the user has selected a particular tipping rate. For example, total cost is (number of miles)*3*(1 + rate) Part b. Number of miles must be numbers between 0 and 100. Display an appropriate error message if the input value is invalid. ___________________________________________________________________ Use the moviestore database created in Week 6 Activity to complete Problem 3 and Problem 4. Problem 3 When a movie type is selected and the 'Display Movies' button is clicked, display a list of movies (title,year, type) for a selected movie type. ____________________________________________________________________ Problem 4 When the 'Classical Movies' link is clicked, display title, year, and type of all the movies with year < 1970="" html="" file="" to="" use:="" cs382="" sample="" exam="" i="" p,="" table="" {margin-left:="" 50px;}="" .datagrid="" {="" width:="" 400px;}="" .selectitem="" {="" padding:="" 5px;}="">
Problem 1: Customer Information
Problem 2: Uber Fair Estimator
Calculate a fare estimate for your next trip.
Problem 3: Display a list of movies (title,year, type) based on the selected movie type from the following list:
Practice problems/members.sql SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `moviestore` -- -- -------------------------------------------------------- CREATE DATABASE IF NOT EXISTS `moviestore`; -- -- Table structure for table `members` -- DROP TABLE IF EXISTS `members`; CREATE TABLE `members` ( `memberID` int(11) NOT NULL, `firstName` varchar(15) NOT NULL, `lastName` varchar(15) NOT NULL, `phone` varchar(30) NOT NULL, `memberType` varchar(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `members` -- INSERT INTO `members` (`memberID`, `firstName`, `lastName`, `phone`, `memberType`) VALUES (1, 'Christian', 'Schmidt', '(262) 555-8353', 'Preferred'), (2, 'Jill', 'Finelli', '(262) 555-1122', 'Preferred'), (3, 'Jackie', 'Hollander', '(262) 555-7352', 'Preferred'), (4, 'Jean', 'Montgolfier', '(262) 555-9264', 'Regular'), (5, 'Juan', 'Santiago', '(262) 555-9865', 'Student'), (6, 'Julie', 'Smith', '(262) 555-9785', 'Preferred'), (7, 'Louis', 'Pascal', '(262) 555-6439', 'Regular'), (8, 'Nadia', 'Likorsky', '(262) 555-8352', 'Student'), (9, 'Rudolph', 'Geiger', '(262) 555-6286', 'Preferred'), (10, 'Ryan', 'Greene', '(262) 555-8370', 'Preferred'), (11, 'Sony', 'Nathan', '(262) 555-1234', 'Preferred'), (12, 'Chris', ' Schultz', ' 262 555-8999', ' Preferred\r'), (13, ' James', ' Fox', ' 262 555-1155', 'Preferred'), (14, ' Jake', ' Holdon', ' 262 555-7777', ' Preferred\r'), (15, ' Jean', ' Montegomery', ' 262 555-9666', ' Regular\r'), (16, ' Jual', ' Santana', ' 262 555-9888', ' Student\r'), (17, ' Julie', ' Brown', ' 262 555-9777', ' Preferred\r'), (18, ' Louis', ' Armstrong', ' 262 555-6444', ' Regular\r'), (19, ' Nate', ' Lancaster', ' 262 555-8333', ' Student\r'), (20, ' Derek', ' Randall', ' 262 555-6226', 'Preferred'), (21, ' Ryan', ' Bush', ' 262 555-8377', ' Preferred\r'), (22, ' Sony', ' Panasonic', ' 262 555-1444', ' Preferred'), (23, 'Sam', 'Samarans', '262-555-1216', 'Regular'), (24, 'Sam', 'Walton', '262 555-9999', 'Preferred'), (25, 'Donald', 'Clark', '262 555-8999', 'Student'); -- -- Indexes for dumped tables -- -- -- Indexes for table `members` -- ALTER TABLE `members` ADD PRIMARY KEY (`memberID`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `members` -- ALTER TABLE `members` MODIFY `memberID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; Practice problems/movies.sql -- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Sep 23, 2021 at 05:02 AM -- Server version: 10.4.21-MariaDB -- PHP Version: 7.4.23 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `moviestore` -- CREATE DATABASE IF NOT EXISTS `moviestore`; -- -------------------------------------------------------- -- -- Table structure for table `movies` -- DROP TABLE IF EXISTS `movies`; CREATE TABLE `movies` ( `movieID` int(11) NOT NULL, `title` varchar(100) NOT NULL, `year` year(4) NOT NULL, `type` varchar(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `movies` -- INSERT INTO `movies` (`movieID`, `title`, `year`, `type`) VALUES (1, 'All Quiet on the Western Front', 1930, 'Adventure'), (2, 'Gone with the Wind', 1939, 'Romance'), (3, 'Casablanca', 1940, 'Romance'), (4, 'The Lost Weekend', 1945, 'Drama'), (5, 'Hamlet', 1948, 'Drama'), (6, 'All About Eve', 1950, 'Suspense'), (7, 'From Here to Eternity', 1953, 'Comedy'), (8, 'On the Waterfront', 1954, 'Drama'), (9, 'Around the World in 80 Days', 1955, 'Adventure'), (10, 'Gigi', 1958, 'Musical'), (11, 'Ben Hur', 1959, 'Drama'), (12, 'West Side Story', 1961, 'Romance'), (13, 'Lawrence of Arabia', 1962, 'Drama'), (14, 'My Fair Lady', 1964, 'Musical'), (15, 'The Sound of Music', 1965, 'Drama'), (16, 'A Man for All Seasons', 1966, 'Adventure'), (17, 'Oliver!', 1968, 'Musical'), (18, 'Airport', 1970, 'Drama'), (19, 'The French Connection', 1971, 'Drama'), (20, 'The Godfather', 1972, 'Drama'), (21, 'The Sting', 1973, 'Drama'), (22, 'The Godfather, Part 2', 1974, 'Drama'), (23, 'One Flew Over the Cuckoo\'s Nest', 1975, 'Drama'), (24, 'Rocky', 1976, 'Action'), (25, 'Annie Hall', 1977, 'Musical'), (26, 'Star Wars', 1977, 'Sci-Fi'), (27, 'The Deer Hunter', 1978, 'Drama'), (28, 'Kramer vs. Kramer', 1979, 'Drama'), (29, 'Ordinary People', 1980, 'Comedy'), (30, 'Chariots of Fire', 1981, 'Drama'), (31, 'Raiders of the Lost Ark', 1981, 'Adventure'), (32, 'ET', 1982, 'Sci-Fi'), (33, 'Tootsie', 1982, 'Comedy'), (34, 'Gandhi', 1982, 'Drama'), (35, 'Terms of Endearment', 1983, 'Drama'), (36, 'Amadeus', 1984, 'Drama'), (37, 'Out of Africa', 1985, 'Drama'), (38, 'Howard the Duck', 1986, 'Comedy'), (39, 'Platoon', 1986, 'Drama'), (40, 'Overboard', 1987, 'Comedy'), (41, 'The Last Emperor', 1987, 'Drama'), (42, 'The Princess Bride', 1987, 'Drama'), (43, 'Big', 1988, 'Comedy'), (44, 'Rain Man', 1988, 'Drama'), (45, 'Who Framed Roger Rabbit', 1998, 'Animation'), (46, 'Driving Miss Daisy', 1989, 'Comedy'), (47, 'Dances With Wolves', 1990, 'Drama'), (48, 'Rescuers Down Under', 1990, 'Animation'), (49, 'Beauty and the Beast', 1991, 'Animation'), (50, 'Silence of the Lambs', 1991, 'Mystery'), (51, 'Unforgiven', 1992, 'Western'), (52, 'Schindler\'s List', 1993, 'Drama'), (53, 'Forrest Gump', 1994, 'Comedy'), (55, 'Maverick', 1994, 'Western'), (56, 'The Lion King', 1994, 'Animation'), (57, 'Braveheart', 1995, 'Drama'), (58, 'Seven', 1995, 'Drama'), (59, 'Fargo', 1996, 'Drama'), (60, 'The English Patient', 1996, 'Drama'), (61, 'Titanic', 1997, 'Drama'), (62, 'Shakespeare in Love', 1998, 'Drama'), (63, 'Matrix', 1999, 'Adventure'), (64, 'Tarzan', 1999, 'Animation'), (65, 'Star Wars: Episode I', 1999, 'Sci-Fi'), (66, 'The Lord of the Rings: the Fellowship of the Ring', 2002, 'Action'), (67, 'The Pianist', 2002, 'Drama'), (68, 'Finding Nemo', 2003, 'Animation'), (69, 'Million Dollar Baby', 2004, 'Drama'), (70, 'Sin City', 2005, 'Action'), (71, 'Batman Begins', 2005, 'Action'), (72, 'V for Vandetta', 2005, 'Action'), (73, 'The Departed', 2006, 'Mystery'), (74, 'The Prestige', 2006, 'Drama'), (75, 'No Country for Old Men', 2007, 'Mystery'), (76, 'The Bourne Ultimatum', 2007, 'Action'), (77, 'Into the Wild', 2007, 'Adventure'), (78, 'Ratatouille', 2008, 'Animation'), (79, 'The Dark Knight', 2008, 'Action'), (80, 'Slumdog Millionaire', 2008, 'Drama'), (81, 'Crash', 2005, 'Drama'), (82, 'A Beautiful Mind', 2001, 'Drama'), (83, 'The Artist', 2011, 'Drama'), (84, 'The King\'s Speech', 2010, 'Drama'), (85, 'Chicago', 2002, 'Musical'), (86, 'Birdman', 2014, 'Adventure'), (87, 'Argo', 2012, 'Action'), (88, 'Gladiator', 2000, 'Sci-Fi'), (89, 'American Beauty', 1999, 'Drama'), (90, 'The Hurt Locker', 2009, 'Action'), (91, '12