You are previewing Effortless E-Commerce with PHP and MySQL, Second Edition.
O'Reilly logo
Effortless E-Commerce with PHP and MySQL, Second Edition

Book Description

In this comprehensive guide to creating e-commerce website using PHP and MySQL, renowned author Larry Ullman walks you through every step—designing the visual interface, creating the database, presenting content, generating an online catalog, managing the shopping cart, handling the order and the payment process, and fulfilling the order—always with security and best practices emphasized along the way. Even if you’re an experienced web developer, you’re guaranteed to learn something new. The book uses two complete e-commerce site examples, with various features and goals, to present the widest possible range of e-commerce scenarios. This fully updated and expanded second edition includes an additional and new payment processing example, and also reflects the latest changes in PayPal’s options and methodologies. There are new chapters on marketing-related tools to improve the site and sales, on adding functionality via Ajax, and on implementing e-commerce functionality using OOP instead of procedural code. Effortless E-Commerce with PHP and MySQL, Second Edition teaches you how to:

  • Think of the customer first, in order to maximize sales and customer satisfaction

  • Create a safe server environment and database

  • Use secure transactions and prevent common vulnerabilities

  • Incorporate different payment gateways

  • Design scalable sites that are easy to maintain

  • Build administrative interfaces

  • Extend both examples to match the needs of your own sites

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Dedication Page
  4. A Bushel—That’s Four Whole Pecks—of Thanks to...
  5. Contents
  6. Introduction
    1. What Is E-Commerce?
    2. About This Book
    3. What You’ll Need
  7. Part One: Fundamentals
    1. 1. Getting Started
      1. Identifying Your Business Goals
      2. Researching Legal Issues
      3. Choosing Web Technologies
      4. Selecting a Web Host
      5. Using a Payment System
      6. The Development Process
    2. 2. Security Fundamentals
      1. Security Theory
      2. PCI Requirements
      3. Server Security
      4. Secure Transactions
      5. Common Vulnerabilities
  8. Part Two: Selling Virtual Products
    1. 3. First Site: Structure and Design
      1. Database Design
      2. Server Organization
      3. Connecting to the Database
      4. The Config File
      5. The HTML Template
      6. Defining Helper Functions
    2. 4. User Accounts
      1. Protecting Passwords
      2. Registration
      3. Logging In
      4. Logging Out
      5. Managing Passwords
      6. Improving the Security
    3. 5. Managing Site Content
      1. Creating an Administrator
      2. Adding Pages
      3. Displaying Page Content
      4. Adding PDFs
      5. Displaying PDF Content
    4. 6. Using PayPal
      1. About PayPal
      2. Testing PayPal
      3. Integrating PayPal
      4. Testing the Site
      5. Using IPN
      6. Renewing Accounts
      7. Going Live
  9. Part Three: Selling Physical Products
    1. 7. Second Site: Structure and Design
      1. About the Site
      2. Database Design
      3. Server Setup
      4. Helper Files
      5. The HTML Template
      6. Making the Most of MySQL
    2. 8. Creating a Catalog
      1. Preparing the Database
      2. Shopping by Category
      3. Listing Products
      4. Indicating Availability
      5. Showing Sale Prices
      6. Highlighting Sales
    3. 9. Building a Shopping Cart
      1. Defining the Procedures
      2. Defining the Helper Functions
      3. Making a Shopping Cart
      4. Making a Wish List
      5. Calculating Shipping
    4. 10. Checking Out
      1. About Authorize.net
      2. Creating a Test Account
      3. Preparing the Site
      4. Taking the Shipping Information
      5. Taking the Billing Information
      6. Processing Credit Cards
      7. Completing the Order
      8. Testing the Site
      9. Going Live
    5. 11. Site Administration
      1. Setting Up the Server
      2. Adding Products
      3. Adding Inventory
      4. Creating Sales
      5. Viewing Orders
      6. Processing Payment
  10. Part Four: Extra Touches
    1. 12. Extending the First Site
      1. New Public Features
      2. Security Improvements
      3. Administrative Changes
      4. Implementing PayPal PDT
    2. 13. Extending the Second Site
      1. Public Suggestions
      2. Administrative Suggestions
      3. Structural Alterations
    3. 14. Adding JavaScript and Ajax
      1. Adding jQuery
      2. Preventing Duplicate Orders
      3. Using Superfish
      4. Adding a Calendar
      5. Pagination and Table Sorting
      6. Applying Ajax
      7. Working with Favorites
      8. Recording Notes
      9. Better Cart Management
      10. Taking Customer Feedback
    4. 15. Using Stripe Payments
      1. About Stripe
      2. Creating an Account
      3. Performing Single Charges
      4. Testing Stripe
      5. Going Live
      6. Capturing Charges
      7. Performing Recurring Charges
  11. Index