Upgrades: Character Sets and Collations

 hints, zen-cart  Comments Off on Upgrades: Character Sets and Collations
Dec 202016
 

As more and more web-hosts retire PHP 5.4, more and more Zen Cart stores are going through the “upgrade process” … many of them from versions of Zen Cart prior to v1.5.1.  Since the concept of identifying the character-set used by the database (the DB_CHARSET definition) wasn’t introduced until Zen Cart 1.5.1, those stores’ databases […]

Zen Cart Rule #3: Don’t Over-Prepare

 hints, php, troubleshoot, zen-cart  Comments Off on Zen Cart Rule #3: Don’t Over-Prepare
Oct 312015
 

When you’re performing database manipulations, it’s important to prepare your textual input so that there aren’t any stray single- (‘) or double-quotes  (“) that will wreck havoc with your MySQL queries.  Zen Cart provides methods (the functions zen_db_input and $db->prepare_input) that will help, but you need to have a plan for what method you’re going […]

Zen Cart Rule #2: Additional Images’ Names

 hints, troubleshoot, zen-cart  Comments Off on Zen Cart Rule #2: Additional Images’ Names
Sep 292015
 

From “Animal Farm”, by George Orwell: All animals are equal, but some are more equal than others. You’ve got your Zen Cart set up and have been placing all your products’ images in the base images’ folder (/images). It’s getting hard to maintain all those images in a single folder (and it’s surely increasing your […]