DotKernel 1.3.0 release

This post refers to DotKernel 1, based on Zend Framework 1. If you are looking for DotKernel 3 related posts, go here. DotKernel 1.3.0 is released at last. It contains important changes and new features. – 64: [Feature] Skin switcher … Read MoreRead More

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. This allows pattern matching. It can be used in any valid SQL statement (SELECT, … Read MoreRead More

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 and release processes in client-server applications. The most common … Read MoreRead More

DotKernel 1.2.2 release

This post refers to DotKernel 1, based on Zend Framework 1. If you are looking for DotKernel 3 related posts, go here. Yesterday, we released DotKernel 1.2.2. It contains some bug fixes: 31 – captcha errors try catch 32 – … Read MoreRead More

End of Support for PHP 5.2.x Branch

PHP 5.2.14 was just released . And this is the end of support for 5.2.x branch of PHP . NOTE:This release marks the end of the active support for PHP 5.2. Following this release the PHP 5.2 series will receive … Read More

DotKernel 1.2.0 release

This post refers to DotKernel 1, based on Zend Framework 1. If you are looking for DotKernel 3 related posts, go here. Finally we reached DotKernel 1.2.0 milestone. Since the previous released 1.1.2, some changes have been made. … 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

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 database, but there is more: Zend_Db_Statement, Zend_Db_Select … Read MoreRead More

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 statement. PDO – PHP Data Objects – … Read MoreRead More

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. There are 3 primary DML statements: INSERT – Inserting new rows into database tables. … Read MoreRead More