In Aptana it’s very simple to set the svn:keywords property for a file. For example if you want to set the svn keyword property Id: … Read More
Best Practice
htaccess 301 redirect non-www to www
To always redirect users to the www site (for example: http://dotboost.com to http://www.dotboost.com), add the following lines to .htaccess, right after RewriteEngine On: RewriteCond %{HTTP_HOST} ^dotboost.com [NC] RewriteRule ^(.*)$ http://www.dotboost.com/$1 [L,R=301] … Read More
Why use CURRENT_TIMESTAMP on a field that record date/time?
On a TIMESTAMP field that records date and time when inserting a new record, it is encouraged to use as a DEFAULT value, the CURRENT_TIMESTAMP constant. … Read More
Subqueries with Zend_Db
Continuing the Zend_DB article series, we are stopping now at subqueries. As you note, the below is a complicate query, with COUNT(), LEFT JOIN(), GROUP BY – select from 3 tables, and make a count from 2 different tables: … Read More
What are returning the FETCH functions from Zend_Db
Continuing the Zend_DB article series, we are stopping now at FETCH methods that are in Zend_Db_Adapter_Abstract: array fetchAll (string|Zend_Db_Select $sql, [mixed $bind = array()], [mixed $fetchMode = null]) array fetchAssoc (string|Zend_Db_Select $sql, [mixed $bind = array()]) array fetchCol (string|Zend_Db_Select $sql, … Read More … Read More