http://www.zftutorials.com/templates/Default/img/logo.gifhttp://www.zftutorials.com/http://www.zftutorials.com/zend-db/http://www.zftutorials.com/zend-db/Generic-Data-Admin-Crontroller-l277.htmlZend 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.http://www.zftutorials.com/zend-db/Zend-Framework-hierarchical-Zend-Db-Table-extension-l271.htmlHierarchical zend_db_table extension implements functions for tables with recursive parent_id auto reference for page or category unlimited levels, tree based navigation.http://www.zftutorials.com/zend-db/Using-the-Zend-Framework-with-Multiple-Databases-l235.htmlZend_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.http://www.zftutorials.com/zend-db/Using-ADODB-with-Zend-Auth-and-Zend-Auth-Adapter-l230.htmlSince 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.http://www.zftutorials.com/zend-db/Zend-Db-Love-l227.htmlI’m starting to get hooked on the Zend Framework’s abstraction to the PDOhttp://www.zftutorials.com/zend-db/Zend-Framework-and-Custom-Row-Classes-l225.htmlToday I was toying around with new code architecture. Previously, how I might have implemented a Model would have been something similar to this:http://www.zftutorials.com/zend-db/Extra-fields-for-Zend-Db-Table-l192.htmlZend_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.http://www.zftutorials.com/zend-db/Modified-fields-for-Zend-Db-Table-l191.htmlEarlier 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.http://www.zftutorials.com/zend-db/Extra-fields-for-Zend-Db-Table-l182.htmlI'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.http://www.zftutorials.com/zend-db/Zend-Framework-Programmer-s-Reference-Guide-Zend-Db-l87.htmlZend_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.http://www.zftutorials.com/zend-db/Using-Zend-Framework-Without-PDO-l72.htmlThis is a very quick tutorial on how to allow developers to develop using the Zend Framework without having to or being able to install PDO on their servers. I have to warn you though, this is not an official extension of the Zend Framework just yet.http://www.zftutorials.com/zend-db/Zdbform-Simple-database-admin-forms-with-the-Zend-Framework-l58.htmlI've put together a database admin application using the database functionality provided by the Zend Framework. Basically, it's a generic set of classes that allows people to quickly add, edit, delete, and view data in a database table. The nice thing is that this uses the Zend_DB_Table classes, so it should presumably work with just about any database supported by the Zend Framework. I've tried this on mySQL and sqlite, and it worked just fine on both. There are some limitations of course. Right now this will only work on tables that have auto-increment primary keys. I don't quite know how this would work with databases that don't have auto-increment such as Oracle - maybe this could have support for defining the sequence that should be used when inserting data. This is a PHP5 only class due to it's reliance on the Zend Framework.http://www.zftutorials.com/zend-db/Programming-a-data-layer-classes-l46.htmlThis article contains a few examples on how to create and use data layer classes that was created by extending the Zend_Db_Table class from Zend Framework.http://www.zftutorials.com/zend-db/Work-with-XML-Data-in-the-Zend-FrameworkWork-with-XML-Data-in-the-Zend-Framework-l25.htmlOne of the incubator projects in the Zend Framework is Zend_Db_Xml. Zend_Db_Xml, also known as the XML Content Store (XCS), allows web applications that use XML data to easily update, save, and otherwise manage this data. In this article I will introduce the XCS persistence API and discuss an implementation using IBMÂ’s DB2 9 database with its pureXML technology. Finally, IÂ’ll discuss a sample social networking application to show how easy and fun it is to develop XML-centric applications using the XCS.http://www.zftutorials.com/zend-db/Zend-Framework-Hidden-Gems-Zend-Db-l3.htmlWelcome back for another edition of Zend Framework Hidden Gems. Finally we start on the weird and wonderful world of database abstraction with PHP5, PDO and Zend.