News Feed
Sections




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

DevShed:
Running Conditional Select Statements with the Active Record Pattern
March 18, 2009 @ 07:58:54

DevShed continues their look at the Active Record pattern with this third part of the series focusing on a new method in their class that will make select requests for the Active Record layer.

If you're a PHP programmer who wants to learn how to implement the active record pattern within a MySQL abstraction class to make your database-driven applications more robust and maintainable, then look no further. [...] In this third chapter of the series I'm going to show you how to add a new method to the class. It will be charged with executing conditional SELECT statements via a modified version of the active record pattern.

After reviewing the CRUD functionality from the previous articles, they add in the new method - a fetchWhere function that allows the user to submit a table name and the parameters to add to the where clause as an array. Some sample code is included.

0 comments voice your opinion now!
activerecord designpattern pattern mysql layer abstraction fetchwhere


blog comments powered by Disqus

Similar Posts

Zend Developer Zone: PHP in Action - Chapter 7, Design Patterns. Part - I

Phpro.org: Introduction to PHP and MySQL

PHPMaster.com: Avoid the Original MySQL Extension, Part 2

David Coallier's Blog: Simple DBAL, PHP5, Light, Fast, Simple.

Richard Heyes' Blog: PEAR::DB database class(es) replacement


Community Events





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


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

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