Many to Many with Zend_Form and Zend_Db

May 21st, 2009

This is part 2 in a series on many to many with Zend_Form and Zend_Db. I suggest starting with last week’s video on Zend_Db and many-to-many in order to follow the configuration of our models. Grab the code and follow along! This concludes this series on Zend_Db. I’ve also uploaded a zipped version of the code if that’s easier than Google Code.

 

Many to Many with Zend_Db and Zend_Form

May 13th, 2009

Exposing many-to-many in a practical application took a little more time and effort than I had anticipated. With that in mind, I to use this opportunity to explore how Zend_Form, Zend_Controller and Zend_Db could be integrated. This is the first in a two part set looking at our data model.

By the end of the second video, you should have a project that explores the following concepts with Zend_Db:

  • A user has many tasks (many-to-many)
  • A task has many users (many-to-many)
  • A user has one contact type (one-to-many)
  • A contact type has many users (many-to-one)

Unfortunately, this only gets through setting up the database, CRUD with Tasks and setting up the Many-to-Many classes in Zend_Db. The next video will cover how we can write a Zend_Form that will map the associations between the users and tasks. Enjoy!

If you can’t wait till the next video, grab the code on google code and play with it firsthand.

 

One to Many with Zend_Db

May 4th, 2009

This is part 3 in the Zend_Db series. I’m only scratching the surface with what you can do with Zend_Db_Table classes, however starting is often the hardest part. I’ve posted the code once again on the Google code for this episode, so please don’t be shy and grab a copy.

There’s a lot of discussion over where and how I’m using the model in the comments, and I have a feeling that as I keep doing this, some of my controversial design decisions (whether out of ignorance, which I’ll gladly acknowledge, or professional experience) might start to surface. I’m really hoping to do a series of similar videos with Doctrine, since I find their solution to database persistence really elegant. If anyone has any suggestions, or would like access to the Google code, I would love to open up the discussion and find the “best practices” here. Personally, I would start by moving our custom made form to Zend_Form and adding some much needed validation to the project.

Lastly, I need to apologize for the delay, this week has been quite full due to work and personal commitments. I’m going to keep the video a week schedule as best I can. The video also deals with setting up the MySQL database, if this isn’t interesting, skip to the 12 minute mark.

 

Zend_Db Update and Delete

April 22nd, 2009

This is the second in a series exploring Zend_Db_Table. We finish up the project in the last video by adding Update and Delete functionality to our UserService. Grab the source code and follow along.
 

Desktop RSS feed iPhone + iPod