[PHP] Database Abstraction Class

2009-03-07 Thread Michael A. Peters
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 abstraction class that does the actual insert for you, so that if you

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 favour

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

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

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Eric Butera
On Sat, Mar 7, 2009 at 8:04 AM, Michael A. Peters mpet...@mac.com 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

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 eric.but...@gmail.com wrote: On Sat, Mar 7, 2009 at 8:04 AM, Michael A. Peters mpet...@mac.com wrote: In some earlier

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: snip 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?

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Eric Butera
On Sat, Mar 7, 2009 at 5:07 PM, Paul M Foster pa...@quillandmouse.com wrote: On Sat, Mar 07, 2009 at 12:34:40PM -0500, Eric Butera wrote: snip 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

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 pa...@quillandmouse.com wrote: On Sat, Mar 07, 2009 at 12:34:40PM -0500, Eric Butera wrote: snip 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

Re: [PHP] Database Abstraction Class

2009-03-07 Thread Eric Butera
On Sat, Mar 7, 2009 at 5:20 PM, Nathan Rixham nrix...@gmail.com wrote: Eric Butera wrote: On Sat, Mar 7, 2009 at 5:07 PM, Paul M Foster pa...@quillandmouse.com wrote: On Sat, Mar 07, 2009 at 12:34:40PM -0500, Eric Butera wrote: snip PDO.  :)  Anything else is a waste of cpu cycles.

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 pa...@quillandmouse.com wrote: On Sat, Mar 07, 2009 at 12:34:40PM -0500, Eric Butera wrote: snip PDO.  :)  Anything else is a waste of cpu cycles. I've looked into PDO,

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 mpet...@mac.com 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

[PHP] Database abstraction class

2003-01-20 Thread Clarkson, Nick
Hi, Can anyone give me any pointers for creating a database abstraction class ? I know there are a few out there already, but I'm doing this purely as an OO learning exercise. I'm only at the paper design right now and I've only got this far; Properties: Persistent - Persistent connection