Archives For e-commerce

When I was writing my [intlink id=”1578″ type=”page”]Effortless E-Commerce with PHP and MySQL[/intlink] book, I naturally did a bunch of research, particularly with regards to the various laws that apply. Understanding the programming behind an e-commerce site is relatively simple; understanding all the applicable laws and implications of doing e-commerce is complex. One of the sites I found to be quite useful was the U.S. Better Business Bureau (BBB).

I’m currently going through some items in my “to read” folder, and am reading, or perhaps re-reading, the Better Business Bureau’s PDF titled “Security & Privacy – Made Simpler“. If you do any e-commerce, or even just Web development, it’s worth reading. It’s a 22-page document that discusses almost every facet of e-commerce, such as:

  • Developing a security and privacy plan
  • Creating and communicating your security and privacy policies
  • Good employee screening and policies
  • Common hack/theft strategies
  • General Internet security
  • Proper handling of customer data
  • Payment processing
  • What to do in the event of a data breach
  • A preview of international e-commerce considerations

The document also has many resources listed in these and other categories. You can download the PDF from that page, but there are also related FAQs and more on the BBB’s site.

Peachpit Press has just published online another article I wrote titled “Ajax-ifying a Shopping Cart.” The article can be used to expand some of the content in my “Effortless E-Commerce with PHP and MySQL” book. This is the fourth and final article I wrote for Peachpit Press in support of this book (plus the five blog postings).

Peachpit Press has just published online another article I wrote titled “Creating an Ajax-Enabled Rating System for Your Website.” The article can be used to expand some of the content in my “Effortless E-Commerce with PHP and MySQL” book.

Peachpit Press has just published online another article I wrote titled “Building an E-Commerce Site with PHP: Making Product Recommendations.” The article can be used to expand some of the content in my “Effortless E-Commerce with PHP and MySQL” book.

This is my third post in a series in which I’m rewriting the stored procedures used in my “Effortless E-Commerce with PHP and MySQL” book as standard PHP and MySQL. Although stored procedures offer lots of benefits over standard PHP-MySQL logic, not everyone has an environment that supports stored procedures, so I’m writing these posts to help out those readers. [intlink id=”2084″ type=”post”]In my first post[/intlink], I rewrote the examples from Chapter 8, “Creating a Catalog”. Those examples are really simple, running only basic SELECT queries. [intlink id=”2151″ type=”post”]In the second post[/intlink], I presented an alternative version of the stored procedures—and the PHP scripts that call them—for Chapter 9, “Building a Shopping Cart.” Those procedures aren’t too complex either. In this post, I’ll rewrite the stored procedures and update the PHP scripts that call them for Chapter 10, “Checking Out.” This chapter has the most complicated—and important—stored procedures, so the PHP scripts will need to be reworked more than in the other chapters. All three chapters are from the third part of the book, in which an e-commerce site is developed for the sake of selling physical products (viz., coffee). Continue Reading…