Beginning PHP and MySQL E-Commerce: From Novice to Professional, Second Edition (Beginners Beginning Guide)

__Beginning PHP and MySQL E-Commerce: From Novice to Professional, Second Edition__ covers every step of the design and building process involved in creating powerful, extendable e–commerce web sites. Based around a real–world example involving a web site selling t–shirts, you'll learn how to create and manage a product catalog, build and integrate a shopping cart, and process customer accounts and PayPal/credit card transactions. With the e–commerce framework in place, authors **Emilian Balanescu** and **Cristian Darie** show you how to integrate advanced features sure to set your web site apart from the competition. You'll learn how to expand your catalog using Amazon Web Services, optimize the web site for the search engines, and take advantage of Ajax to build an even more user–friendly shopping cart. Other highlights: * The authors show you how to build a complex, extendable e–commerce web site using sound development practices * This second edition has been updated to take advantage of a more flexible templating system, and new chapters cover Ajax integration and search engine optimization * The text goes beyond basic product and customer management, showing you how to integrate product reviews, process payments using both credit cards and PayPal, and expand your web site catalog using third–party services such as Amazons affiliate program 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

Beginning PHP and MySQL E-Commerce: From Novice to Professional, Second Edition covers every step of the design and building process involved in creating powerful, extendable e–commerce web sites. Based around a real–world example involving a web site selling t–shirts, you’ll learn how to create and manage a product catalog, build and integrate a shopping cart, and process customer accounts and PayPal/credit card transactions.

With the e–commerce framework in place, authors Emilian Balanescu and Cristian Darie show you how to integrate advanced features sure to set your web site apart from the competition. You’ll learn how to expand your catalog using Amazon Web Services, optimize the web site for the search engines, and take advantage of Ajax to build an even more user–friendly shopping cart.

Other highlights:

• The authors show you how to build a complex, extendable e–commerce web site using sound development practices
• This second edition has been updated to take advantage of a more flexible templating system, and new chapters cover Ajax integration and search engine optimization
• The text goes beyond basic product and customer management, showing you how to integrate product reviews, process payments using both credit cards and PayPal, and expand your web site catalog using third–party services such as Amazons affiliate program

What you’ll learn

• Build an extensible e–commerce web site using sound development techniques
• Increase sales through proven techniques such as cross–selling, upselling, and enhancing customer service offerings
• Expand your product and service offerings by integrating with reseller programs such as Amazon Affiliates via XML web services
• Take advantage of search engine optimization techniques to make your web site more easy to find

Who this book is for

This book was written for individuals seeking to build e–commerce web sites using the PHP language and MySQL database.

Beginning PHP and MySQL From Novice to Professional, Second Edition covers every step of the design and building process involved in creating powerful, extendable e commerce web sites. Based around a real world example involving a web site selling t shirts, you ll learn how to create and manage a product catalog, build and integrate a shopping cart, and process customer accounts and PayPal/credit card transactions. With the e commerce framework in place, authors Emilian Balanescu and Cristian Darie show you how to integrate advanced features sure to set your web site apart from the competition. You ll learn how to expand your catalog using Amazon Web Services, optimize the web site for the search engines, and take advantage of Ajax to build an even more user friendly shopping cart. Other * The authors show you how to build a complex, extendable e commerce web site using sound development practices. * This second edition has been updated to take advantage of a more flexible templating system, and new chapters cover Ajax integration and search engine optimization.* Beginning PHP and MySQL E-Commerce: From Novice to Professional, Second Edition is an update to the popular book showing readers how to create e-commerce websites using two of the world's most popular technologies: the PHP scripting language and MySQL database. In addition to guiding readers through the creation of a complete, working website using sound enterprise development techniques, the authors take care to provide readers with a variety of alternative implementation solutions: for instance readers are shown how to accept payments from both PayPal and credit cards. The book has also been updated to reflect the latest development trends, showing readers how to upgrade their shopping cart using Ajax, integrate with Amazon's Web services, and encourage customer feedback through cutting-edge interactive features. * PHP is an open-source server-side scripting language, with millions of users worldwide. It is more popular than Microsoft's ASP and ASP.NET. Version 5, out before the end of Q2 of 2004, features new OO-programming capabilities. * MySQL is the most popular open source RDBMS. * There are a lot of E-commerce elements, such as credit card transaction processing, that are not easy to learn. This book will provide solid e-commerce solutions for PHP and MySQL developers. * This will be a good companion book to Apress' 1893115518 Beginning PHP 5 and MySQL: From Novice to Professional by W.J. Gilmore.