Database Articles

Zend\Db\Sql\Select - The Basics (Columns, Limit & Order)

April 2, 2013

In part 3 of this series on \Zend\Db\Sql\Select in Zend Framework 2 We cover the constructor, columns function, aliases and expressions, finishing up with limit and order functions. Come wind up the series in style.

\Zend\Db\Sql - Creating Joins and Unions with Ease

April 27, 2013

In part two of the \Zend\Db\Sql\Select series, we create inner, outer, left and right joins as well as union queries with ease. Come learn more about building queries simply, effectively and easily in your every day applications with Zend Framework 2.

\Zend\Db\Sql - Build SQL Where Clauses Easily and Efficiently

April 20, 2013

In this tutorial we’re working through the basics of \Zend\Db\Sql\Where, showing how to build SQL Where clauses for database queries. We’ll show how to create different predicates from simple to nested queries using of and, or, like, between and in conditions.