We’re setting up a user application for a food truck service. The assignment involves using php, html and sql databases using phpAdmin via localserver. The food truck will serve pizza. The exact types...

Please see attached file for instructions.


We’re setting up a user application for a food truck service. The assignment involves using php, html and sql databases using phpAdmin via localserver. The food truck will serve pizza. The exact types of pizza are pepperoni, cheese, spinach, and chicken. This assignment is from the owner’s viewpoint. We will help them keep track of revenue and inventory. Please send all documents and codes to me. I’ll need to save everything on my computer before I can turn it in. Databases- DaySales –(PepperoniSales,CheeseSales,SpinachSales,ChickenSales) the data will be integers because we’ll be inputting how many slices of each type of pizza we sold. The database will list the money generated by multiplying the amount sold by $2 because each slice is $2. Inventory Table- listing ingredients(Dough8oz, Pepperoni8oz, Cheese8oz,Spinach8oz, TomatoSauce8oz,PaperPlates100ct,Napkins100ct). We need to be able to input amounts such as -2 or +5 to show how much we used or bought of each item daily. User Interface: Use php and html to make an interface where the food truck owner is able to input the daysales information (how many of each slice of pizza was sold) that will return to them how much revenue they made that day. Example: How Many Slices Sold (Input a digit in the box). Pepperoni Cheese Spinach Chicken Submit Daily Sales is: $ Use php and html to make an interface where the food truck owner is able to input ingredients info that will return how much of each ingredient they have left. Please input how many of each ingredient you used (ex. -2) or how much of each ingredient you bought (Ex. +5) Dough8oz Pepperoni8oz Cheese8oz Spinach8oz Chicken8oz TomatoSauce8oz Napkins100ct PaperPlates100ct Submit Great! Your current totals of each item is: Dough8oz Pepperoni8oz Cheese8oz Spinach8oz Chicken8oz TomatoSauce8oz Napkins100ct PaperPlates100ct Professor Instructions: You need an SQL database set up to complete this task. If you have not done so,  please follow the following steps: 1. go to your web-server localhost and click on phpMyAdmin link 2. log into phpMyAdmin with user root without any password 3. click on "User account" -> "Add user account" and pick a username and password for the new account (you should choose single-word for username and password). Check both options in "Database for user account" group and "Check all" for "Global privileges" group 4. click "go" to create the user account and its database. You should have a database with the same name as the username 5. logout of phpMyAdmin and log back in with the newly created username and password. 6.  select the newly created database on the left panel and start creating tables for your project. You can run any SQL query via "SQL" tab. WHAT TO SUBMIT: 1. submit all the files that being used for this project, including the database schema (you can export them from myphpadmin) 2. a video capturing your demonstration of your code and interface in action