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 → Best PracticeINSERT, 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 PracticeSubqueries 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 PracticeWhat 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 → Best PracticeSQL queries using Zend_Db – SELECT
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', $dbConnec…
Teo · Jun 15, 2010 Read more →