It seems that you're in Germany. We have a dedicated site for Germany. Authors: Darie , Cristian, Balanescu , Emilian. 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.

Author:Guzil JoJojar
Language:English (Spanish)
Genre:Personal Growth
Published (Last):16 November 2015
PDF File Size:12.45 Mb
ePub File Size:19.58 Mb
Price:Free* [*Free Regsitration Required]

Want to read Slashdot from your mobile device? Point it at m. The authors use a T-shirt shop scenario as their model for the design and implementation of their e-commerce site. The book is separated into three distinct "phases" of development. Phase I covers the foundations of creating the Web site, what tools to use and how to use them including creating a product catalog, incorporating a search tool, using PayPal payment processing and adding an administration interface.

Phase II proceeds with enhancing the site with a custom shopping cart, a client-server ordering process, a page for pending order administration and a dynamic product recommendations system. Chapter 1 introduces business strategies for considering an online commerce solution and the reasons for launching an e-commerce presence: acquiring more customers, making customers spend more and reducing the costs of fulfilling orders.

A thorough read of Appendix C "Project Management Considerations" would be a good aside at this point. This section provides excellent insight into choosing an appropriate software development cycle model for different projects with a good discussion of advantages and disadvantages of various methods and theories. Chapters 2 through 7 constitute Phase I proper. The authors begin by tackling the basic structure of the site and focusing on flexible design, scalability and reliability.

They introduce a three-tier architecture model: the presentation tier dynamic pages that contain the elements that allow visitor to the site to interact effectively with the business end , the business or middle tier requests for data that are posed by the visitor are passed on by the presentation tier to the data tier and the data tier manages the data and sends appropriate responses back to the business tier when requested.

Chapter 2 lays the groundwork for the reader to establish the TShirtShop site and accompanying database. I quite admire the authors' choice to use Smarty. Smarty parses templates behind the scenes and creates PHP scripts from them so when a Web page is rendered, Smarty reads from the PHP scripts instead of pulling the templates themselves, eliminating run-time parsing of templates. Smarty also has built-in caching of template outputs, which saves on overhead in retrieving data from the database.

After creating the main index. The last step in Chapter 2 is to load phpMyAdmin and create the new tshirtshop database and an admin user.

From this point forward, the authors structure each chapter to adhere to the three-tier model. Implementing the presentation tier, the business tier and the data tier is an integral part of the construction of the site. The reader is encouraged to begin every major aspect of the project with these elements in mind. Chapters 3 and 4 lead the reader through the creation of the product catalog for the TShirtShop site. The first table is created and populated with data, PEAR DB is used to access the data and a Smarty template is used to implement the user interface.

Multiple tables are then added to enhance product catalog features, which allows for a discussion of table relationships. Filtering SQL results and joining data tables are then examined in the section on implementing the data tier. Chapter 5 introduces a product search engine to the site by using MySQL to search the database and using Smarty templates to build the user interface. This is a major component of any e-commerce site and the authors prepare an excellent code set for this purpose by using the full-text searching functionality of MySQL.

The pros and cons of this versus using LIKE are also discussed. Many individual proprietors and small businesses don't have the resources to process credit cards and therefore use Internet Payment Service Providers to process transactions. In this chapter, the authors teach the reader how to create a new PayPal account, how to integrate the PayPal shopping cart and custom checkout and how to configure PayPal to automatically calculate shipping costs.

There is a bit of missing code in this chapter but it appears correctly on this book's Apress errata page apress. The last chapter of Phase I covers implementation of a catalog administration page using componentized templates and a simple authentication scheme for administrator access to the page.

By the completion of Phase I, the design and programming for a completely functional e-commerce site is in place. Phase II begins with a pros and cons discussion of using a simple cart method like PayPal versus creating a custom shopping cart and checkout to enhance flexibility.

There are some neat tricks here including storing the cart ID as a cookie on the client. In Chapters 8 and 9, the reader learns how to store cart info in the database, how to implement a client-side ordering mechanism and an orders administration page for pending orders. The benefit to this is that since the data is now stored in the database, quantitative analysis and tracking can be done based on the products sold.

In Chapter 10, the authors add product recommendations to their TShirtShop site. This dynamic visitor-specific functionality is an excellent sales strategy intended to boost sales by adding suggestions for upgrading a purchase or complementing a purchase with another product. The items recommended are based on what products were ordered together by other customers. The SQL query to get the list of products is very nicely done! This concludes Phase II and the site is again fully functional but with some neat new enhancements: the site has its own shopping cart, credit card processing is accomplished through PayPal and an orders administration page and product recommendations system have been added.

Many individually run or small businesses may stop at this point and be completely content with the e-commerce site that has been developed so far. This final section of the book deals with processing credit cards, using SSL to encrypt data transactions, storing customer accounts, adding a customer product review system think Amazon. The authors spend some time covering the design of the order pipeline and optimizing the logical sequence of tasks that need to be tracked.

Chapter 12 deals with the modifications necessary to the enable pipeline processing and the database schema changes for auditing and storing data. Chapter 13 implements the pipeline sections in preparation for adding full credit card transaction functionality in Chapter 14 and rounds out with the creation of a new orders admin page that shows an audit trail for any particular order stored in the database.

Full implementation of credit card orders is completed in Chapter The authors discuss credit card transaction fundamentals including working with credit card payment gateways, understanding transactions and card processing.

Product review integration is the subject of Chapter This is another highly coveted enhancement to e-commerce sites. The authors provide a very simple and therefore, elegant, in my view implementation of code to add review capabilities to the sample site. Appendices A-C cover necessary application installation as mentioned above , hosting advice, steps for getting your files where they need to be on various hosting models and project management theory.

Access to code and errata is available on the Apress Web site apress. This book has a nice layout, clean typography, plenty of screen shots and the code sets are offset from the main body of text and are extremely easy to follow.

The book can readily be propped open while looking on from your development machine and the overall size of the book isn't unwieldy or awkward to place on a surface.

In the The Expert's Voice in Open Source series, Apress has harnessed the knowledge and expertise of some of the best folks in open source and this book is no exception.

Both authors have prepared a book that will enable any intermediate developer to create a fully functional e-commerce Web site that they can then customize and extend. This book is consistent, well organized and clearly presented. Beginning PHP 5 and MySQL E-Commerce: From Novice to Professional is the perfect tutorial-style book for start-to-finish e-commerce site development instruction for any developer with the desire to learn the advanced tools and techniques to get a scalable professional site designed and in production.

Slashdot welcomes readers' book reviews -- to see your own review here, read the book review guidelines , then visit the submission page.

This discussion has been archived. No new comments can be posted. Its not like we are all sitting at are computers trying to be the first to post on a news story and forbid there be a error in the post If you need ecommerce, or any web application for that matter, then there is no point in starting from scratch. My own favorite is Drupal [drupal. For example, some creative guy wrote an Ecommerce [drupal.

Stuff like: Bayesian inference [ibm. All of those examples are from the same author the guy in charge of phpmath. I immediately write off as "clueless" any author that suggests that MySQL is a good tool to use for things that require security like shopping carts, or for anything close to mission critical.

Beyond that, I wouldn't trust CC info in any database. The method I use is to split up the storage of CC info, one part to one database, another to another database on another machine and the key stored on another. It's a bit of a pain in the ass to set up, but it would take one helluva of a catastrophe for a hacker to steal CC info. There may be more comments in this discussion. Without JavaScript enabled, you might want to turn on Classic Discussion System in your preferences instead.

Automatically sync your GitHub releases to SourceForge quickly and easily with this tool and take advantage of SourceForge's massive reach. Follow Slashdot on LinkedIn. The authors have prepared a book with real-world application in a tutorial format; they give detailed instruction on how to create a fully developed e-commerce web site from design phase to deployment. This book is not for the raw beginner; some knowledge of PHP and MySQL is assumed and truthfully, this book will most benefit a professional web designer who has some experience building dynamic elements into web sites.

More Login. Score: 3 , Funny. Share twitter facebook linkedin. Re:my God! Score: 1 , Offtopic. Looks like Timothy needs to read this himself. Oh wait, Slashdot runs on Perl Thank you, I'm here all week. Score: 1. No kidding. I thought maybe the whole book was posted up here! Score: 2 , Funny. The blurbs are getting longer. Score: 2. Stupid mods. That one had me laughing out loud. Tim Berners-Lee surrenders". Holy Shit Score: 2 , Insightful. Talk about a shameless plug, they put the entire review on the front page!

Re:Holy Shit Score: 1.


Beginning PHP and MySQL E-Commerce



Slashdot Top Deals




Related Articles