Latest Articles

Javascript

Intro to jQuery

Starting with the 1.5 release, Dotkernel will make the switch from Dojo to jQuery.

Adrian . Jun 01, 2011 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.

arhimede . Mar 14, 2011 Read more → Best Practice

Using LIKE wildcards with Zend_Db

Continuing the Zend_Db article series, let's discuss the LIKE condition. The LIKE condition allows you to use wildcards in the WHERE clause of an SQL statement.

Teo . Sep 10, 2010 Read more → PHP Development

PHP Environment : Development Staging Production

In hosted software development, the environment refers to a server tier designated to a specific stage in a release process. The purpose of these environments is to improve the development, testing an…

Teo . Jul 30, 2010 Read more → Best Practice

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. Why? Because when inserting a new row in the ta…

Teo . Jun 29, 2010 Read more → PHP Development

Protection against SQL Injection using PDO and Zend Framework - part 2

Following the preview article about SQL Injection, here is more - a strong argument why you should use Zend Framework for handling database access. Zend_Db is the primary class used for access the dat…

Teo . Jun 18, 2010 Read more → PHP Development

Protection against SQL Injection using PDO and Zend Framework

SQL injection is a technique that exploits a security vulnerability occurring in the database layer of an application. Usually, user input is not filtered by the script and is passed into a SQL statem…

arhimede . Jun 16, 2010 Read more → Best Practice

INSERT, UPDATE, DELETE statements with Zend_Db

Continuing the Zend_DB article series, we are stopping now at DML statements. DML (Data Manipulation Language) statements are statements that change data values in database tables.

Teo . Jun 16, 2010 Read more → Best Practice

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 fro…

Teo . Jun 15, 2010 Read more → Best Practice

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, , ) array fetchAssoc (string|Zend_Db_Selec…

Teo . Jun 15, 2010 Read more →