Question: 1.use phpmyadmin to create a database for the three types of coffee and their respective prices 2.on clicking the checkbox on the website, user can

1.use phpmyadmin to create a database for the three types of coffee and their respective prices

2.on clicking the checkbox on the website, user can key in new sales price for a cup of coffee using SQL

3.updated sales price automatically retrieved and displayed onto the same webpage for user confirmation

Webpage code

HTML code:

JavaJam Coffee House Menu

Coffee at JavaJam

Just Java Regular house blend, decaffeninated 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.00 Double $5.75

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Q:

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

Q:

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

Q:

web project Palestinian Best Food Store (PBFS), is an online food store that sales authenticated Palestinian Food, such as Zater, Olive Oil, Sage, ets. Also sales pre-packaged Palestinian meals such...

Q:

Please answer this task: > UNDERSTANDING OF REQUIREMENTS This task is highlighted in red ink on page 10. Overview of each session page. MSc Applied Research Project Cucina Ltd. Competitive advantage...

Q:

MSc Applied Research Project Please answer question (C) Introduction: Section A Fri 31st Jan 2020 Teams should prepare a 10 minute presentation: Venue: Safari Annexe O'Donovan's Road Time:...

Q:

QUESTION: WRITE EXECUTIVE SUMMARY FOR CUCINA LTD PROJECT 300 WORDS MSC Applied Research Project Cucina Ltd. Competitive advantage through data integrity Company History Cucina Ltd. is an Irish...

Q:

I am dyslexic so it takes much longer for me to do any reading, so any and all help is greatly appreciated. I will be sure to thumbs up! Please I need help... Report Layout Structure Table of...

Q:

I am dyslexic so it takes much longer for me to do any reading, so any and all help is greatly appreciated. I will be sure to thumbs up! Please I need help... Report Layout Structure Table of...

Q:

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67...

Q:

A 12 cm piece of nylon string lies along the x-axis, starting at x=0 cm. The first 5 cm of the string has a charge density of -7 C/cm, and the remaining length of the string has a charge density of...

Q:

In 2007, Chrysler Group said it would cut 13,000 jobs, close a major assembly plant and reduce production at other plants as part of a restructuring effort designed to restore profitability at the...

Q:

Account Titles Debit Credit Cash $ 43 Accounts Receivable 14 Prepaid Insurance 6 Equipment 90 Accumulated Depreciation $ 0 Accounts Payable 14 Salaries and Wages Payable 0 Income Tax Payable 0 Common...

Q:

What are the formulas I should know when analyzing the financial statements of a public company from investor relations? This is for market research of a public company. Such as finding the...