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
Blog
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
SQL 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’, $dbConnect); … Read More
Sending emails using Dot_Email component and Zend_Email
Dot_Email class extends Zend_Mail, so all the methods from Zend_Mail are available in Dot_Email. Dot_Email is a simple class composed only from 2 methods, except constructor, all other methods beeing inherited from Zend_Mail. … Read More
camelCase Table Names in MySQL on Windows
If you are using a WAMP stack, like WAMP or XAMPP, and try to create a table in camelCase ( example: adminLogin) you will notice that camelCase is not working, table name will be lowercase: adminlogin. In order to fix … Read More