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
Blog
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
Aptana PHP installation in Aptana 2.x
As all aptana fans know, Aptana PHP plugin was discontinued in Aptana 2.x, in favor of PDT. But PDT is a joke, not suitable for professional PHP development, major features are missing. So if you want to continue using Aptana … Read More
DotKernel Template Engine
This post refers to DotKernel 1, based on Zend Framework 1. If you are looking for DotKernel 3 related posts, go here. DotKernel Template Engine is an implementation of PHPLib Template engine for PHP5. It has an amazing ability to … Read More