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
>
|
