Zend DB

Zend framework provides powerful data abastraction and here are a few controller methods that work for any data model. A foundation for scaffolding, CRUD , BREAD development or AJAX request handling.

Hierarchical zend_db_table extension implements functions for tables with recursive parent_id auto reference for page or category unlimited levels, tree based navigation.

Zend_Db_Table does a great job of abstracting database tables, but it's really intended to hit one database per application. This tutorial demonstrates a method of using as many databases as you want by simply specifying them in your config file.

Since I prefer ADODB over Zend Framework's own Zend_DB, I had a small problem: How to use it with Zend_Auth to authenticate the user?
Good thing Zend employs smart people: they use an adapter to control the database access in the Zend_Auth class, called Zend_Auth_Adapter. You can define your own authentication adapter quite easily by creating a class which implements the Zend_Auth_Adapter_Interface interface class.

I’m starting to get hooked on the Zend Framework’s abstraction to the PDO

Today I was toying around with new code architecture. Previously, how I might have implemented a Model would have been something similar to this:

Zend_Db_Table is a very, VERY handy class for working with databases. It has come up in numerous posts on this blog. But I’ve always felt that for a complete model implementation there was something missing.

Earlier today, I wrote a little extension to Zend_Db_Table that allows for “custom” fields to be added to it’s rows. When it was done some other ideas came floating up. Why wouldn’t I make my life even easier, by creating fields that don’t output their values directly.

I'm taking a quick look at adding fields that aren't in the table, but may be handy in your application. Like adding a field "name" that combines both first and last name, without having to change your database or write too much code. Quick, dirty, but extremely handy.

Zend_Db_Adapter is the database API abstraction layer for the Zend Framework. Based on PDO, you can use Zend_Db_Adapter to connect to and work with any of the supported SQL database systems using the same API. These include Microsoft SQL Server, MySQL, PostgreSQL, SQLite, and others.