Re: [PHP] Database Abstraction Class

2009-03-07 Thread Lester Caine
( Sorry Eric - forgot to change the email address again :( ) Eric Butera wrote: On Sat, Mar 7, 2009 at 8:04 AM, Michael A. Peters wrote: In some earlier thread (I really don't want to dig to find it) I argued for running mysql_real_escape_string right on the _POST I must concede I was definit

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Paul M Foster
On Sat, Mar 07, 2009 at 05:12:28PM -0500, Eric Butera wrote: > On Sat, Mar 7, 2009 at 5:07 PM, Paul M Foster wrote: > > On Sat, Mar 07, 2009 at 12:34:40PM -0500, Eric Butera wrote: > > > > > > > > > >> > >> PDO.  :)  Anything else is a waste of cpu cycles. > > > > I've looked into PDO, and I jus

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Eric Butera
On Sat, Mar 7, 2009 at 5:20 PM, Nathan Rixham wrote: > Eric Butera wrote: >> >> On Sat, Mar 7, 2009 at 5:07 PM, Paul M Foster >> wrote: >>> >>> On Sat, Mar 07, 2009 at 12:34:40PM -0500, Eric Butera wrote: >>> >>> >>> >>> PDO.  :)  Anything else is a waste of cpu cycles. >>> >>> I've looked

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Nathan Rixham
Eric Butera wrote: On Sat, Mar 7, 2009 at 5:07 PM, Paul M Foster wrote: On Sat, Mar 07, 2009 at 12:34:40PM -0500, Eric Butera wrote: PDO. :) Anything else is a waste of cpu cycles. I've looked into PDO, and I just didn't find it as feature-rich as the "native" (non-OO) function assortme

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Eric Butera
On Sat, Mar 7, 2009 at 5:07 PM, Paul M Foster wrote: > On Sat, Mar 07, 2009 at 12:34:40PM -0500, Eric Butera wrote: > > > > >> >> PDO.  :)  Anything else is a waste of cpu cycles. > > I've looked into PDO, and I just didn't find it as feature-rich as the > "native" (non-OO) function assortment fo

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Paul M Foster
On Sat, Mar 07, 2009 at 12:34:40PM -0500, Eric Butera wrote: > > PDO. :) Anything else is a waste of cpu cycles. I've looked into PDO, and I just didn't find it as feature-rich as the "native" (non-OO) function assortment for database types like MySQL and PostgreSQL. Can PDO be extended? I

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Nitsan Bin-Nun
I'm personally using CI DB abstraction layer, also used zend_db, they both good but as Eric said, I think PDO is a better option. On Sat, Mar 7, 2009 at 7:34 PM, Eric Butera wrote: > On Sat, Mar 7, 2009 at 8:04 AM, Michael A. Peters wrote: > > In some earlier thread (I really don't want to dig

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Eric Butera
On Sat, Mar 7, 2009 at 8:04 AM, Michael A. Peters wrote: > In some earlier thread (I really don't want to dig to find it) I argued for > running mysql_real_escape_string right on the _POST > > I must concede I was definitely wrong about that. > > The right place to do it is in a database abstracti

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Richard Heyes
Hi, > Never used pear before, but I seem to recall there being some issues where > pear did not provide very good forward support when moving to new versions > of php causing a need to recode. Is that still an issue? Don't really know. I've not really had a problem with the stuff that I've writte

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Michael A. Peters
Richard Heyes wrote: Hi, Anywhoo, that being said, does anyone have a suggestion for a good database abstraction class? Ooh, I think you'll get the odd one or two... Preferably one that already has decent support for several open source databases? PEAR::DB was good, but IIRC it's now been

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Richard Heyes
Hi, > Anywhoo, that being said, does anyone have a suggestion for a good database > abstraction class? Ooh, I think you'll get the odd one or two... > Preferably one that already has decent support for several open source > databases? PEAR::DB was good, but IIRC it's now been deprecated in favo