Re: [phpesp-dev] OT: perl Class::DBI for php?

[Chad B. <ch...@be...>]

Yep I use that already.  Class::DBI is an oop abstraction over the DB 
interface.  It looks at all of the tables and create accessors methods. 
  What's more if you define relationships then it auto gets that stuff 
too.  for example

Survey->has_many(questions, Questions::DBI)
Question->might_have(choices, Choice::DBI)

Just pseudo code but you get the idea.

I've built an interface to phpESP using the Pear_DB package but it's 
very tedious...although workable.

Not everything is finished but it is being used.  My reports utilize 
Smarty so admins can create their own formats. I use Math_Stats to gen 
stats for numerical type questions like rankings, dates, etc...  I also 
create math stats for choice questions and just assume a rank of 1 for 
the first choice, 2 for second...etc.

If you are interested in any of my work I'll be happy to share.

chad.

On Friday, Aug 22, 2003, at 18:01 US/Eastern, James E. Flemer wrote:

> Chad Bearden wrote:
>> I've googled around the web for a pear plugin that duplicates perl's 
>> Class::DBI but can't find anything.  Anyone know of anything?  I'm 
>> interested after reading these articles on perl.com
>> http://www.perl.com/pub/a/2003/07/15/nocode.html
>> chad.
>
> There is PEAR::DB[1] which is intended to be the Pear equivaliant of 
> Perl DBI.  See more Pear packages here[2].
>
> [1] http://pear.php.net/package/DB
> [2] http://pear.php.net/packages.php
>
> -James
>