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

Lukas Smith's Blog: Database abstraction mailing list [UPDATE]

Pureform Blog: Memcache & MySQL PHP Session Handler

Wolfgang Drews\' Blog: Some thoughts on indexes & searching in MySQL / PHP

ThinkPHP Blog: Oracle with PHP and PDO

Zend Developer Zone: The ZendCon Sessions Episode 17: SQL Query Tuning: The Legend of Drunken Query


Community Events





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


interview laravel language list library release install api community bugfix podcast opinion series voicesoftheelephpant deployment framework introduction symfony tips package

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