Zend Certified Engineer

Bobby Easland, Zend Certified Engineer

The Zend Certified Engineer exam has some very tough questions but is well within reach. Programming eCommerce platforms tend to utilize only a small number of core functional areas of the PHP language (file functions, cURL/sockets, DB, etc.) but the exam is very balanced. Anyone that is looking to take the exam should purchase the study guide and maybe even the practice questions book. Both of these helped me to understand the key areas that would be addressed and highlight those areas that I needed to brush up on.

I highly encourage my fellow osCommerce and eCommerce developers to look into the certification exam. It is very satisfying to obtain the certification directly from the architects of the PHP language and also brush up on the skills that may not be commonly used.

I would rate my experience with this certification as a 9 out of 10. Good luck to everyone on their path to certifying your skills and experiences!

1 Billion Queries Served in 10 days

I've been working on a high volume client completing a very customized platform. They needed such things as support for 10K+ concrete products and virtualization to bring that total up to 100K+. The core modifications for this were extensive but not only did it need to accomodate functional requirements but also scale with enterprise level traffic (10,000+ concurrent users). As if that weren't enough they also needed to integrate seamlessly with their distributor servers for regular XML inventory and orders updates.

The solution for the product virtualization entailed that I first remove the stock osC attrbutes system since IMO it is useless for large catalogs. The shear amount of administration for each product setup would have been several thousand man hours and taken weeks if not months. Another requirement was that inventory be tracked per option. For example, let's say that there is a costume called "Test Costume". There are several attributes (or options) such as size, color, etc. As each one is sold out it needed to be removed from customer display. All of these were easily handled with the highly customized options core.

The next task that was approached was the XML integration with the distributor. Basically this is a complete backoffice integration that syncs not only the inventory levels but also the orders. As the order goes through received, picking, and finally shipped it updates the orders status with customer notifications. In addition, it is fault tolerant with queue redundancy.

Now the fun problem to work on...high traffic volume. For this I naturally selected a clustered configuration with multiple web, load balancers, and DB servers. The cluster currently can support 5K concurrent users without breaking a sweat. In the future if the site encounters a traffic spike (AdWords campaign, etc.) scaling is as easy as adding another node and a fast configuration change in the load balancer.

Since the cluster went live 10 days ago it has served almost 1 billion queries and climbing by about 100 million queries daily. All the while it is sustaining sub .1 second page render times.

...so...for all those people that have been asking me what I've been working on there you go. Want to see the site? Here you go: Halloween Costumes

How to remove session ID appended URLs from the search engine index

A common scenario is for store owners that were not aware of the "Prevent Spider Sessions" option to have several URLs indexed by spiders with the session ID appended. This situation is troublesome and there are a few options to handle referrals sent through the "wild" session ID URL.

However, the true solution to the problem is to REMOVE THE SESSION ID's from the search engine index! So, how hard is it? Pretty easy!

In includes/application_top.php find this code:

// include the language translations require(DIR_WS_LANGUAGES . $language . '.php');

Under that paste this code:

if ( $spider_flag == true ){ if ( eregi(tep_session_name(), $_SERVER['REQUEST_URI']) ){ $location = tep_href_link(basename($_SERVER['SCRIPT_NAME']), tep_get_all_get_params(array(tep_session_name())), 'NONSSL', false); header("HTTP/1.0 301 Moved Permanently"); header("Location: $location"); // redirect...bye bye } }

This code will redirect the spider to the non-SID URL with a 301 header and over time will remove the session appended URL from the index.

[CONTRIBUTION] Google Sitemap Generator for osCommerce MS-2.2 stores - Categories

After posting the latest version of the Google Sitemap Generator for the catalog products there have been several people request that I also post the one for categories.

So, I have also posted the latest sitemap script for the categories on Digital Point forum as well!

I posted the code inline with the post so that you can inspect it and see how it works. However, I have also attached the file so as to eliminate copy-and-paste errors that will inevitably occur.

If you register on the forum to directly download the file be sure to fill in my screen name (Chemo of course!) so that they know who sent you :-)

Get the new script here: Google Sitemap Generator v1.1 - Categories

PHP4/MySQL Error Handling with an Observer design pattern

I put up an article on Digg.com just to see what kind of response it gets. If people find it useful I'll post more articles on PHP design patterns and some interesting solutions to common problems. Here's the link: PHP4/MySQL Error Handling with an Observer design pattern. If you dig the article...be sure to give me a DIGG! :-)