News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

MaltBlue.com:
ZendDbSql - Creating Joins and Unions with Ease
July 01, 2013 @ 09:41:51

On the MaltBlue.com blog Matthew Setter has a new post about the ZendDbSql component of Zend Framework 2, specifically related to making easy joins and unions. This is the second part of his series on this component.

In the first part of this series on ZendDbSqlSelect, we jumped the gun a bit and went straight in to looking at building Where clauses. We looked at a number of the predicates that are available to us, such as In, Between and EqualTo and saw just how easy ZendDbSqlSelect makes both building and maintaining queries. In this, the second part, we're backtracking a bit and looking at Joins and a slightly more esoteric feature of SQL - UNIONs. By the end of today's tutorial, you'll be building some pretty good queries that should satisfy most of your daily requirements.

He starts with a look at joins, showing in several code examples the various kinds - inner, outer, left and right (as well as self joins). He then moves on to unions, intersects and excerpts with examples of each.

0 comments voice your opinion now!
zendframework2 tutorial sql db tutorial join union

Link: http://www.maltblue.com/tutorial/zend-db-sql-creating-joins-and-unions-with-ease

blog comments powered by Disqus

Similar Posts

Evan Coury: Creating a simple view helper in Zend Framework 2

WorkingSoftware.com.au: Configuring PHP4 and PHP5 to run concurrently on FreeBSD

Pádraic Brady's Blog: XSS in PHP (Part 1): How Not to Use Htmlspecialchars

PHPMaster.com: PHP Security: Cross-Site Scripting Attacks (XSS)

NetTuts.com: Integrating Two-Factor Authentication with CodeIgniter


Community Events





Don't see your event here?
Let us know!


api tips deployment conference list development community interview zendserver introduction laravel voicesoftheelephpant podcast code language bugfix framework series threedevsandamaybe release

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework