Home arrow PHP arrow Building an E-Commerce Site Part 1: Building a Product Catalog

Building an E-Commerce Site Part 1: Building a Product Catalog

This is the first article in a three-part series dealing with using PHP 4 and MySQL to make a comprehensive e-commerce storefront solution. This article covers the product catalog database design and creating the catalog administration interface.

  1. Building an E-Commerce Site Part 1: Building a Product Catalog
  2. Assumptions and Requirements
  3. Overview of a Simplified E-Commerce System
  4. Step 1: Creating the Database
  5. Step 2: Creating the Product Catalog
  6. Step 3: Populating the Tables with Data
  7. Step 4: Creating Catalog Maintenance Screens
  8. Step 5: Putting It All Together
By: Ying Zhang
Rating: starstarstarstarstar / 129
April 25, 2000

print this article



Welcome to E-Commerce Step-by-Step. This guide is meant to show you how to build a basic online store complete with (1) a product catalog, (2) user accounts for customers, and (3) the ability for your customers to order products from your catalog.

After you complete this three part series, you will

  • (part 1) understand the fundamentals components of an E-Commerce site
  • (part 1) learn to create a product catalog
  • (part 1) learn to create maintenance screens for the product catalog
  • (part 2) learn to use the session management capabilities in PHP4
  • (part 2) learn to manage users and user privileges
  • (part 3) learn to display the product catalog
  • (part 3) learn to allow customers to order from the product catalog
  • (part 3) understand how credit card authorization and payment works

To accomplish these goals, we will develop a fictitious store called MyMarket that sells products over the Internet. For this we will use the freely available Apache, MySQL, and PHP programs.

In this installment, we will cover the administrative aspects of building a product catalog. After completing this installment, you have:

  • created the MyMarket database in MySQL
  • created the underlying tables for the product catalog
  • created PHP scripts to add product categories
  • created PHP scripts to edit product categories
  • created PHP scripts to delete product categories
  • created PHP scripts to add products
  • created PHP scripts to edit products
  • created PHP scripts to delete products

>>> More PHP Articles          >>> More By Ying Zhang

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates


Dev Shed Tutorial Topics: