Beginning PHP and MySQL E Commerce

Contents......Page 6
About the Authors......Page 13
About the Technical Reviewers......Page 14
Acknowledgments......Page 15
Introduction......Page 16
PART 1: Phase I of Development......Page 23
Deciding Whether to Go Online......Page 24
Let\'s Make Money......Page 26
Risks and Threats......Page 27
Designing for Business......Page 28
TShirtShop......Page 31
Summary......Page 32
CHAPTER 2: Laying Out the Foundations......Page 33
Designing for Growth......Page 34
Choosing Technologies and Tools......Page 40
Choosing Naming and Coding Standards......Page 47
Summary......Page 48
CHAPTER 3: Starting the TShirtShop Project......Page 49
Implementing the Site Skeleton......Page 59
Preparing the Database......Page 78
Summary......Page 81
Showing Your Visitors What You\'ve Got......Page 82
Roadmap for This Chapter......Page 86
Storing Catalog Information......Page 88
Communicating with the Database......Page 98
Adding Logic to the Site......Page 104
Displaying the List of Departments......Page 118
Creating the Link Factory......Page 127
Summary......Page 131
Storing the New Data......Page 132
Querying the New Data......Page 144
Writing the New Database Stored Procedures......Page 148
Completing the Business Tier Code......Page 157
Implementing the Presentation Tier......Page 165
Summary......Page 193
CHAPTER 6: Product Attributes......Page 194
Implementing the Data Tier......Page 195
Implementing the Business Tier......Page 200
Implementing the Presentation Tier......Page 201
Summary......Page 207
CHAPTER 7: Search Engine Optimization......Page 208
Optimizing TShirtShop......Page 209
Supporting Keyword-Rich URLs......Page 210
mod_rewrite and Regular Expressions......Page 214
Building Keyword-Rich URLs......Page 218
URL Correction with 301 Redirects......Page 222
Customizing Page Titles......Page 226
Updating Catalog Pagination......Page 229
Correctly Signaling 404 and 500 Errors......Page 232
Summary......Page 239
Choosing How to Search the Catalog......Page 240
Teaching the Database to Search Itself......Page 242
Implementing the Business Tier......Page 251
Implementing the Presentation Tier......Page 256
Summary......Page 267
CHAPTER 9: Receiving Payments Using PayPal......Page 268
Getting Started with PayPal......Page 269
Integrating the PayPal Shopping Cart and Checkout......Page 271
Using the PayPal Single Item Purchases Feature......Page 283
Summary......Page 285
CHAPTER 10: Catalog Administration: Departments and Categories......Page 286
Previewing the Catalog Administration Page......Page 287
Setting Up the Catalog Administration Page......Page 290
Administering Departments......Page 304
Administering Categories......Page 314
Summary......Page 323
Administering Product Attributes......Page 324
Administering Products......Page 339
Administering Product Details......Page 346
Creating In-Store Administration Links......Page 370
Summary......Page 379
PART 2 : Phase II of Development......Page 380
CHAPTER 12: Creating Your Own Shopping Cart......Page 381
Designing the Shopping Car......Page 382
Storing Shopping Cart Information......Page 384
Administering the Shopping Cart......Page 410
Summary......Page 416
AJAX Quick Start......Page 417
Creating the AJAX Shopping Cart......Page 430
Summary......Page 448
Implementing an Order-Placement System......Page 449
Administering Orders......Page 460
Summary......Page 478
Increasing Sales with Dynamic Recommendations......Page 479
Selecting Recommendations from the Database......Page 481
Implementing Product and Shopping Cart Recommendations......Page 488
Summary......Page 492
Part 3: Phase III of Development......Page 493
CHAPTER 16: Managing Customer Details......Page 494
Storing Customer Accounts......Page 495
Implementing the Security Classes......Page 497
Adding Customer Accounts Functionality to TShirtShop......Page 517
Creating the Checkout Page......Page 547
Summary......Page 557
Adding Orders to Customer Accounts......Page 559
Administering Customer Orders......Page 563
Handling Tax and Shipping Charges......Page 575
Summary......Page 584
CHAPTER 18: Implementing the Order Pipeline: Part 1......Page 585
Designing the Order Pipeline......Page 586
Laying the Groundwork......Page 590
Updating the Orders Processing Code......Page 602
Summary......Page 608
Implementing the Pipeline Sections......Page 609
Testing the Pipeline......Page 618
Updating the Checkout Page......Page 627
Updating the Orders Administration Page......Page 630
Summary......Page 637
Credit Card Transaction Fundamentals......Page 638
Working with DataCash......Page 640
Working with Authorize.net......Page 657
Summary......Page 668
CHAPTER 21: Product Reviews......Page 669
Planning the Product Reviews Feature......Page 670
Implementing Product Reviews......Page 671
Summary......Page 677
Introducing Web Services......Page 678
Accessing the Amazon Web Services......Page 680
Integrating A2S with TShirtShop......Page 689
Summary......Page 700
A......Page 702
B......Page 703
C......Page 704
D......Page 707
E......Page 708
G......Page 709
J......Page 710
M......Page 711
P......Page 712
R......Page 715
S......Page 716
T......Page 718
W......Page 719
Z......Page 720