News Feed
Sections




News Archive
feed this:

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

MaltBlue.com:
ZendDbSqlSelect - The Basics (Columns, Limit & Order)
July 02, 2013 @ 09:53:32

Matthew Setter has posted the third part of his series looking at the Zend Framework 2's DbSqlSelect component and its use. In this latest (and last) tutorial, he talks more specifically about columns, limiting and ordering.

Welcome to the third and last part in this series, introducing you to working with the ZendDbSqlSelect classes in Zend Framework 2. In part one we looked at building SQL Where clauses using the where related functions, predicates and closures, as well as compound queries. In part 2, we looked at all forms of SQL joins as well as a slightly more esoteric feature of SQL - UNIONS. Here, in part 3, in the words of Coldplay, we're going back to the start, and looking at the fundamentals.

He looks at three specific elements - the class constructor, the "limit" and "order" functions and the "Expression" class. He includes sample code showing how to create the class - one normally and one bound to a specific table. The next example shows how to define the columns to be selected using the "select" method. Finally, he shows the use of the "Expression" objects to perform SQL operations in the query (like "COUNT").

0 comments voice your opinion now!
zendframework2 db sql select series part3 column limit order

Link: http://www.maltblue.com/tutorial/zend-db-sql-the-basics

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

David Coallier's Blog:
PEARDB is Deprecated, Got It?
June 04, 2007 @ 15:21:00

In response to several other posts lately about the PEAR::DB package in PEAR (and things that could be done to improve it), David Coallier got a bit fed up and shared his opinion - "PEAR::DB is deprecated, got it?"

All new features are made into MDB2 and not DB, the only thing that is being done on DB is security fixes. So MDB2 is first of all, faster, smaller (Because of it's driver and modularity), easier, and has more features (LOB handling, Iterator, etc) and better end-user documentation, quite solid docs indeed.

Of course, the comments of the post are full of people arguing to keep it around and others that agree with David, especially in light of a MDB2 driver for the Zend Framework he mentions.

0 comments voice your opinion now!
pear db database mdb2 deprecated pear db database mdb2 deprecated


Community News:
New Zend Framework Mailing Lists Announced
September 19, 2006 @ 15:10:10

Going along with the Roadmap update Zend has recently put out about it's Framework, Andi Gutmans has also announced the introduction of more mailing lists to help developers communicate more effectively.

In line with the roadmap email, I'd like to form 8 new mailing lists which will make it easier for people to discuss/participate in subject areas which are of interest to them (actually 7 new ones as docs already exists).

I did think of calling the lists fwdev-* to note them as dev lists but I think it makes more sense to keep them open to the users. I find it very valuable to get users asking questions and commeting on functionality on the dev lists as that's valuable input from the users.

The new mailing lists up and running. They are:

  • fw-webservices@
  • fw-mvc@
  • fw-auth@
  • fw-i18n@
  • fw-db@
  • fw-core@
  • fw-formats@

To check out the topics that fall under each category, check out the sections of the roadmap.

0 comments voice your opinion now!
mailing list zend framework raodmap webservices mvc auth db core mailing list zend framework raodmap webservices mvc auth db core


CodePoets.co.uk:
A Quickstart to using PEAR with PHP
April 13, 2006 @ 07:09:23

On CodePoets.co.uk today, a new tutorial introduces you to the PEAR DB package, giving you a howto guide on performing simple queries with its functionality.

PEAR::DB, provides a uniform, cross platform, cross database method for connecting to databases, when writing PHP applications/scripts. Extensive documentation can be found online here This article aims to show briefly, how queries and updates can be performed when using PEAR DB.

They list a few reasons why one might want to use the PEAR DB package over the normal PHP database functions before they get into the examples. There are four examples - making the connection, querying the database, what to do to avoid SQL injections, and updating your database with prepared statements.

1 comment voice your opinion now!
pear db package quickstart howto connect query sql update pear db package quickstart howto connect query sql update



Community Events





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


code configure language framework interview testing wordpress install laravel developer list opinion refactor release introduction unittest series threedevsandamaybe community podcast

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