Snipplr

(PHP) Report each step of Magento's One Page Checkout to Google Analytics - jdbartlett

Thu, 01 Oct 2009 20:45:00 UTC

This code allows you to track each step of Magento's One Page Checkout in Google Analytics. I installed it at the bottom of my `checkout/onepage.phtml` template file. Once installed, you can set up a funnel for the following: * `/checkout/onepage/` * `/checkout/onepage/billing/` * `/checkout/onepage/shipping/` * `/checkout/onepage/shipping_method/` * `/checkout/onepage/payment/` * `/checkout/onepage/review/` * `/checkout/onepage/success/` (This is a tweak of code [seen here](http://www.magentocommerce.com/boards/viewthread/12564/P0/). I prefer the gist of lanthaler's method over FOOMAN's because the data sent to Google is more specific, and based on explicit requests to load sections rather than requests to save data.)

(PHP) Strip Illegal XML Characters from a UTF-8 String - jdbartlett

Fri, 25 Sep 2009 10:35:48 UTC

Some valid UTF-8 characters are illegal in XML: http://www.w3.org/TR/REC-xml/#charsets This statement strips them from your strings.

(PHP) Google Ajax Libraries API handler for CakePHP - jdbartlett

Fri, 05 Jun 2009 00:11:37 UTC

[Google's "AJAX Libraries API"](http://code.google.com/apis/ajaxlibs/) is great and all, but can slow things down if you're doing a lot of refreshing/cache clearing while debugging. Here's a neat trick: stuff something like this in the `` of your CakePHP Layout to use local versions of these libraries while you're debugging:

(PHP) Include a Model from within a CakePHP Controller - jdbartlett

Tue, 02 Jun 2009 11:53:28 UTC

This code within your CakePHP Controller to include a Model.

(PHP) Saving CakePHP Model data with MySQL functions - jdbartlett

Thu, 07 May 2009 11:54:49 UTC

(MySQL) Correcting wrong character encoding in MySQL data - jdbartlett

Fri, 06 Mar 2009 21:30:47 UTC

When you forget to "SET NAMES utf8", you'll probably end up with a bunch of latin1 data in your utf8 column. This query fixes that, CONVERTing the existing data to its correct collation.

(PHP) Include a component from within a CakePHP controller - jdbartlett

Thu, 18 Dec 2008 13:58:52 UTC

This code within your CakePHP controller to include a component.

(SQL) Delete Dulicate Rows in MySQL - jdbartlett

Mon, 18 Aug 2008 11:26:04 UTC

Where bad_table is the name of the table containing duplicate rows.