Price update:

Picture above shows the main administrative page.

Clicking on the checkbox will link to another HTML page as shown below, where you can key in the new price for each product.

Use php mySQL database for price update.(IMPORTANT)

Structure of the database:

INSERT INTO `table1` (`ID`, `Price`) VALUES (1, 2.00), (2, 2.00), (3, 3.00), (4, 4.75), (5, 5.75);

Once the updated price is submitted, the new price should be reflected on original menu page as shown below.

HTML Code:

JavaJam Coffee House

• Home
• Menu
• Music
• Jobs

Menu Item	Description	Price
Just Java	Regular house blend, decaffeinated coffee, or flavor of the day.	Endless Cup $2.00
Cafe au Lait	House blended coffee infused into a smooth, steamed milk.	Single $2.00 Double $3.00
Iced Cappuccino	Sweetened espresso blended with icy-cold milk and served in a chilled glass.	Single $4.75 Double $5.75

© JavaJam Coffee House

Hi Hi

PS: Urgenty need help with this assignment!

Implement additional pages to perform database management functions such as product price update and generation of daily sales report. >As shown below is an administrative page to select a particular blend of coffee for price update. On clicking a corresponding check box, the user can key in the new sales price for a cup of coffee. On successful update of the sales price into the database, the updated sale prices should be automatically retrieved and display pdat t onto the same page for user confirmation. duvudn Coffee House Product Click to update product prices Price or fiavor of House blended coffee inused into a smooth, steamed Single $2.00 Doubie $3.00 Sweetened espresso blended with icy-cold mik and Single $4,75 Doubie $575 Cafe au Lait