Hour 20. Creating an Online Store

In Hour 16, “Building a Simple Shopping Cart,” I provided an example of an online store that demonstrated how one uses session management to create a shopping cart. In this hour, I’m going to extend that example to show how you can use a relational database to store all the data used by a Web site—specifically an online store. In this hour, you’ll look at modified versions of the programs from Hour 16 that interface with a relational database.

In this hour you’ll learn

  • What the database schema for a basic online store looks like

  • How to write a catalog script that works with a relational database

  • How a database simplifies the shopping cart script

  • How a real-life checkout script works

Get Sams Teach Yourself CGI in 24 Hours, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.