In this section you will take all of the skills you have developed and apply them to a larger problem. Pizza Kitchen is an independent pizza delivery company that specialises in making the finest pizzas out of the highest quality ingredients. The company wants to develop a online ordering system so that their customers can order from their laptops rather than via the phone.
This is where you come in! Using your knowledge of HTML forms and server-side scripting you will develop the online ordering system for Pizza Kitchen.
The first task involves developing the database that will be used to store the pizza types and customer orders. It has been decided that in this first version of the system only pizzas can be ordered online, so there is no need to think about drinks, side-orders or deserts.
The ER diagram below represents the design of the database:
The entities in this database are represented by the following entity descriptions:
, Name, Description, Cost)
, FirstName, LastName, StreetAddress,Town,PostCode,EMailAddress)
, Date, DeliveryTime, _CustomerID_)
, _OrderID_, _PizzaID_, _Inches_, Quantity)
underlined attributes represent primary keys and
italic attributes represent foreign keys.
Write a script to create the given database structure as a MySQL database. You may need to investigate the datatypes MySQL supports.
Pizzas can have names up to 50 characters and descriptions of up to 300 characters.
- 1. Introduction to server-side scripting
- 2. Getting ready for server-side scripting
- 3. Preparing for your first script
- 4. Create your first server-side script
- 5. Capturing and processing data
- 6. Processing the form data
- 7. Server-side scripting and databases
- 8. Adding data to a database
- 9. Displaying data from the database
- 10. More on HTML forms
- 11. Pizza Kitchen
- 12. Administration Forms
- 13. Customer Account Form
- 14. Customer Order Form
- 15. Current Orders