Effortless E-Commerce with PHP and MySQL (2nd Edition) (Voices That Matter)

Effortless E-Commerce with PHP and MySQL (2nd Edition) (Voices That Matter)

Language: English

Pages: 552

ISBN: 0321949366

Format: PDF / Kindle (mobi) / ePub


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

PHP Advanced and Object-Oriented Programming: Visual QuickPro Guide (3rd Edition)

Wicked Cool Ruby Scripts: Useful Scripts That Solve Difficult Problems

Guide to Web Development with Java: Understanding Website Creation

Build Your Own Website The Right Way Using HTML & CSS (2nd Edition)

Professional WordPress

 

 

 

 

 

 

 

 

 

 

 

 

installation of Composer (assuming the process worked). You should find in the folder you used (in Step 2) composer.phar. That script will do the work of installing dependencies. * * * Note You need to install Composer only once, not once for each site. * * * Next, you need to identify the dependencies for the project. That’s accomplished by creating a file of JSON (JavaScript Object Notation) data named composer.json. Put this in your site’s includes directory. Here are the

administrators to log out. Then, restrict the lifetime of an authentication cookie so that it will expire some minutes after they’ve stopped being active on your site (online banks may only allow 10–15 minutes of user inactivity). This will narrow the window of CSRF danger to just that brief cookie lifetime. * * * Note CSRF attacks are more successful against very popular sites that use long-lasting cookies. * * * Not making sensitive information (like a user ID value) public is

better to save more information than you end up needing than to later discover you haven’t been storing something you do need. * * * All payments will be handled through PayPal. Even though PayPal will provide detailed logs of every transaction, it’s wise to record the basics of each transaction in this system as well. The orders table stores every transaction that goes through PayPal, associated with the ID of the user (as taken from the users table). Each order is associated with

creating a more seamless and professional experience. Part 4, “Extra Touches,” is entirely new in this edition of the book. Part 4 explores dozens of features, techniques, approaches, and so forth that you can apply to the two example sites or to e-commerce in general. One chapter makes specific recommendations regarding the virtual product example site. Another chapter gives the same treatment to the second example site (which sells physical products). The third new chapter singles out

every coffee product looks like this: Click here to view code image SELECT gc.description, gc.image, CONCAT("C", sc.id) AS sku, CONCAT_WS(" - ", s.size, sc.caf_decaf, sc.ground_whole, CONCAT("$", FORMAT(sc.price/100, 2))) AS name, sc.stock FROM specific_coffees AS sc INNER JOIN sizes AS s ON s.id=sc.size_id INNER JOIN general_coffees AS gc ON gc.id=sc.general_coffee_id WHERE general_coffee_id= AND stock>0 ORDER by name ASC; Figure 8.1 shows the MySQL output for the

Download sample

Download