DotKernel 1.2.0 release

Posted by on | Featured | No Comments

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?

Posted by on | Featured | No Comments

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

Posted by on | Featured | No Comments

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 More … Read More

Tags: ,

INSERT, UPDATE, DELETE statements with Zend_Db

Posted by on | Featured | 3 Comments

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 More … Read More

Tags: ,

Subqueries with Zend_Db

Posted by on | Featured | 1 Comment

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

Tags: ,

What are returning the FETCH functions from Zend_Db

Posted by on | Featured | 1 Comment

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

Tags: ,

SQL queries using Zend_Db – SELECT

Posted by on | Featured | 4 Comments

Zend_Db and its related classes provide a simple SQL database interface for Zend Framework. To connect to MySql database, we are using Pdo_Mysql adapter : $db = Zend_Db::factory(‘Pdo_Mysql’, $dbConnect); … Read More

Tags: ,