Tag Archives: Zend Framework

June 16, 2010
by Teo

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. … Continue reading

Posted in Best Practice | Tagged , | 1 Comment

June 15, 2010
by Teo

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: Continue reading

Posted in Best Practice | Tagged , | 1 Comment

June 15, 2010
by Teo

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, … Continue reading

Posted in Best Practice | Tagged , | 1 Comment

June 15, 2010
by Teo

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); Continue reading

Posted in Best Practice | Tagged , | 4 Comments

October 3, 2008
by Julian

Zend Framework as PEAR accessible repository on Plesk server

Why we want to install ZF as PEAR ? Because is too boring and time consuming to move all ZF files up and down for each script you want to install , there are a lot of files. Also that … Continue reading

Posted in Zend Framework | Tagged , , | 1 Comment