PROGRAMMER TUTORIALS
solutions to programmer problems

ASP
C#
C++
COBOL
Delphi
HTML
Java
J2EE
JavaScript
JSP
.NET
Perl
PHP
SQL
Visual Basic
XML
View Shopping Cart


Get a FREE Apple iPod Photo

  Books Beginning PHP 5 and MySQL E-Commerce: From Novice to Professional

Rating: 5 out of 5 stars - Cristian Darie has done it again!
Cristian Darie has done it again. The last book I had authored by him was Beginning ASP.NET 1.1 E-Commerce. It was a book which guided me from the introduction of three-tier programming all the way to the creation of a full-blown, feature packed e-commerce website using Microsoft's ASP.NET Technologies.

This book, Beginning PHP 5 and MySQL E-Commerce was written with the similar concept in mind.

Very often, programmers are faced with situation where once the web application is fully developed, modifying or extending it in the near future is nothing but a nightmare! The solution? Three-Tier architecture! They are the presentation tier, business tier and the data tier. In this book, Christian Darie and his co-author Mihai Bucica, first introduces the reader into the world of three-tier architecture programming.

From there, the reader is given preliminary information such as the various technologies available for dynamic page creation and the different tools which the reader would expect to use during the course of the book such as PHP for dynamic web page generation and MySQL as the database management system.

One fundamental aspect of the book which I found rather interesting was the way the authors blended the different tools and programming language used to develop the e-commerce website with the context of the three-tier architecture as mentioned earlier.

The presentation tier here was presented with the a mix of both HTML and PHP. Instead of the confusing spaghetti code style where PHP coding is seen interleaved with HTML coding, Bucica and Darie introduced the idea of using Smarty Templates which is similar to Microsoft's ASP.NET code-behind concept where the programming language is separated from the HTML code to improve code management and readability.

The online store's business logic is then coded in PHP classes which represents the business tier of the architecture.

Then comes the third tier, also known as the data tier where the store's data management resides. This tier is represented by MySQL. However in an effort to provide a systematic way in managing SQL coding, the authors followed the idea of using Stored Procedures which, at the time of writing was not a feature available with MySQL. As such, a plugin name PEAR DB was introduced to help facilitate the usage of stored procedures.

With such clear cut separation between HTML, PHP coding, business logic PHP classes, MySQL for data management and PEAR DB to manage SQL Queries (stored procedures) , managing, upgrading and maintaining the application from a coding perspective is simply a breeze.

When it comes to learning, there is nothing like practical, hands-on work and this is where this book excels in. After introducing readers to the concept of the three-tier architecture, readers are then brought through a step-by-step creation of a fictional online e-commerce store called the TShirtShop which comes complete with a shopping cart, web based administration system for the online store all the way to receiving online payments through various channels such PayPal and credit cards.

If these may scare you, fear not, the authors present coding in a clear, easy to understand manner with suggestion of best coding practices, code manageability alongside with self-explaining comments within each snippet of code.

Another advantage when using this book is the different stages in which the authors introduce various features to compliment to the site. After completing the first few chapters (chapters 1 through 9), you have a complete site which comes with shopping cart functionality, catalogue search and ability in receiving orders. Other functionalities which were also covered in the book such as implementing credit card transactions, customer product reviews, product recommendations and integration to various web services such as that of Amazon.com can be implemented on a needed basis.

As such, if you have preliminary knowledge on the PHP programming language and would like to have a feature packed e-commerce solution on an open source platform, this is certainly one of the best books I would recommend to anyone venturing into the world of e-commerce.



Rating: 5 out of 5 stars - Real Code - Straight to the Point!!
This book has helped me immensely with real-life-like code examples and all that it takes to bringing an e-commerce site up and running. Lots of coding with brisk explanations. Starts with laying out the site: Presentation tier, Business tier, Data tier. Templating with Smarty, PEAR, Caching, Paypal, Shopping Basket, Orders, Order Pipeline, Payment Gateways, Credit-card Transactions, Web Services, Security, SSL, and what not? I wish the 2nd Chapter had a little bit more of explanation for a stronger foundation. I almost lost the chain of thought while reading this chapter and had to re-read it to grasp the techniques used. Other than that and out and out, the book is simply amazing and straight to the point!!

Shekar Reddy



Rating: 5 out of 5 stars - THE BOOK the industry doesn't want you to have! Darie Rocks!
I have bought numerous programming books in the past and have always wanted a thorough book that covers detailed development of an e-Commerce website. I've bought several that claim to be indepth in this area but they have all fallen short of being what I was looking for. I've never bought a book without reading the reviews on it first....but this book was so new when I bought it that there were no reviews available for it. It sounded like it contained what I was looking for so I took a chance and bought it. I'm really glad I took that chance! "Beginning PHP 5 and MySQL E-Commerce: From Novice to Professional" is THE ABSOLUTE BEST BOOK available that details, step-by-step, how to build a full-fledge e-Commerce website...and believe me, I have bought every PHP/MySQL book (plus many more) that can't hold up to their claims....but this book delivers what the others can't. This is truly a ONE OF A KIND book.

Firstly, this books covers the ins and outs of installing PHP, PEAR, MySQL, and Apache on your Unix based machine (installations for Windows systems are also covered).

Secondly, the book shows you detailed code that performs different functions and then explains step-by-step what each bit of the code is doing.

Plus, this is THE ONLY book that will show you how to do database queries that return images from a product catalog and lay out the images with a description and link to a product page. The other PHP / MySQL books only go as far as showing you how to build a page header and footer with text only query results.

Also, the book helps you set up your site for future expansion. It uses Smarty Templating for page layouts so that your site is easy to modify and maintain and Darie shows you how to use PEAR DB abstraction to allow for changes in the type of database you might decide to use in the future (ex. , migrating from MySQL to Oracle). That being said, the title of the book is a little misleading in the fact that MySQL is used very little in this book. The book uses PEAR to perform the MySQL functionality.

I have bought books in the past that end up being written hastily with poor writing style and code errors galore. Cristian Darie and Mr. Bucica have taken the time to write a near perfect book. If you don't believe me look at the erata for this book at Apress.com....there are almost no coding errors at all. And, their writing style really makes the book fun to read.

Lastly, and definitely worth mentioning, I ran into a PHP problem that I couldn't solve. Cristian Darie listed his website and e-mail address in the front of this book and I thought I'd try e-mailing him to help me. I didn't expect to receive a reply, especially since having e-mailed other authors in the past with no reply. Within three hours Cristian Darie had replied to my e-mail with the solution to my problem. He was very nice and polite and even offered his help if I ran into future problems as I was working through the book! This is absolutely amazing and UNPARALLELED CUSTOMER SUPPORT.

If you want to know how to develop your site the right way and learn a lot in the process, then this is the book for you!



Rating: 5 out of 5 stars - Everything you need to know to build an E-commerce site
The use of PHP 5 and MySQL for e-commerce is a tested and proven combination. This book is primarily intended for the reader who already has some PHP knowledge and needs to understand how to build an e-commerce site. It does not focus on teaching either PHP 5 or MySQL but instead focuses on how to use the combination to produce an exceptional e-commerce solution.

The authors use the example of a Tshirt shop and walk the reader through every step of completely constructing a viable e-commerce site. The book covers everything from designing your site, to creating a product catalog, searching the catalog, receiving payments, catalog administration, creating a shopping basket, working with customer orders, product recommendations, storing customer information, secure connections, implementing the order pipeline, working with credit cards, and setting up product reviews.

The appendixes include detailed information on installing Apache, PHP, MySQL, and phpAdmin (for both Windows and Unix-like systems), hosting your web site, and project management.

While this is not a book about learning the PHP scripting language it does contain enough detailed code to create a functioning e-commerce site even if you don't understand how the code works. For example, on page 192 it says to "Create a new template file named admin_login.tpl in the templates folder and add the following code to it:..." This is followed by a long code listing that produces the desired results. There is a short explanation of the function of various sections of the code but nothing that details the purpose of each command, variable, etc. This is really not a problem since they state up front that the target audience is a PHP programmer who needs to learn how to build an e-commerce site, but it does deserve mention for those who have no knowledge of PHP and are considering the book.

The first thing a person might notice when thinking about purchasing this book is that there is no CD in the back containing all the many examples of source code. This could be very discouraging as the examples are extensive and rewriting them by hand without error can be a daunting task. However, Apress does make all of the examples available for download at their web site.

Beginning PHP 5 and MySQL E-Commerce is highly recommended for anyone who has some basic knowledge of PHP and MySQL and wants to capitalize on this to build a powerful e-commerce site.



Rating: 5 out of 5 stars - Got a fish and learned how to fish
Before I buy a program book, I always to read the book to see if it meets my two basic requirements: one is writing style. It should be written in clear and plain English and well organized. The another is more, clear explanation of "How it works", not only just put all the codes and without or with only little bit explanation. Cristian Darie's books always are one of my top choices. I recommend that you read CHAPTER 8, The Shopping Basket and CHAPTER 11, Customer Details. It lists all methods, dig more detail and offer "Do it yourself". Finally, you Got a Fish and Learned How to Fish!!!



page 4 of  5
 1  2  3  4  5 


2000-2006 ProgrammerTutorials.com


Top100WebShops.com