Re: [PHP] database abstraction layer

2010-02-03 Thread Lester Caine
Ashley Sheridan wrote: On Tue, 2010-02-02 at 23:19 +0100, Rene Veerman wrote: function getMax($table, $field) If I saw this sort of code I'd be appalled! It's possibly the worst way to get the auto increment value. You won't notice it testing the site out on your own, but all hell will break

Re: [PHP] database abstraction layer

2010-02-02 Thread Paul M Foster
On Wed, Feb 03, 2010 at 06:39:29AM +0100, Rene Veerman wrote: > On Wed, Feb 3, 2010 at 5:49 AM, Jochem Maas wrote: > > you can bet you ass that every other DB out there that's worth it's salt > > has atomic id incrementor functionality exposed in some way or other. > > > > @Rene: all that talk of

Re: [PHP] database abstraction layer

2010-02-02 Thread Rene Veerman
On Wed, Feb 3, 2010 at 5:49 AM, Jochem Maas wrote: > you can bet you ass that every other DB out there that's worth it's salt > has atomic id incrementor functionality exposed in some way or other. > > @Rene: all that talk of maxId functions and random retries etc, etc, is > complete pooh. > don'

Re: [PHP] database abstraction layer

2010-02-02 Thread Jochem Maas
Op 2/3/10 12:19 AM, Ashley Sheridan schreef: > On Wed, 2010-02-03 at 00:21 +0100, Rene Veerman wrote: > >> the auto_increment sytnax is not uniform across servers, is it? >> >> On Wed, Feb 3, 2010 at 12:11 AM, Ashley Sheridan >> wrote: >> >>> I saw it happen on a site that was getting only about

Re: [PHP] database abstraction layer

2010-02-02 Thread Phpster
Lol, damn iPod corrections. The app designers is what was meant. Bastien Sent from my iPod On Feb 2, 2010, at 8:41 PM, Robert Cummings wrote: Phpster wrote: Yep, love those race conditions. We have them all over the app cuz the app ciders don't know shit! Mmmm... apple cider... to cu

Re: [PHP] database abstraction layer

2010-02-02 Thread Paul M Foster
On Tue, Feb 02, 2010 at 11:19:29PM +0100, Rene Veerman wrote: > oh, on using adodb.sf.net and 0-overhead for jumping between mysql and > postgresql; > > keep all your queries to as simple & early-standard sql as possible. > the auto_increment incompatibilities can be circumvented with a > relativ

Re: [PHP] database abstraction layer

2010-02-02 Thread Michael A. Peters
Robert Cummings wrote: *snip* Einstein I believe said something along the lines of "A smart person solves a problem. A wise person avoids it in the first place" Might not have been Einstein, but anyway ... Do you mean the following quote? The difference between a smart person and a wise

Re: [PHP] database abstraction layer

2010-02-02 Thread Robert Cummings
Michael A. Peters wrote: Robert Cummings wrote: Rene Veerman wrote: eh thats "randomize the timing of the retry attempt".. On Wed, Feb 3, 2010 at 12:17 AM, Rene Veerman wrote: and after the sleep(rand(1,3)) it might need a short loop like this; $rnd = rand(1,9); $a=0; for ($i=0; $i<$rn

Re: [PHP] database abstraction layer

2010-02-02 Thread Michael A. Peters
Robert Cummings wrote: Rene Veerman wrote: eh thats "randomize the timing of the retry attempt".. On Wed, Feb 3, 2010 at 12:17 AM, Rene Veerman wrote: and after the sleep(rand(1,3)) it might need a short loop like this; $rnd = rand(1,9); $a=0; for ($i=0; $i<$rnd; $i++) { $a++ } to furt

Re: [PHP] database abstraction layer

2010-02-02 Thread Robert Cummings
Rene Veerman wrote: On Wed, Feb 3, 2010 at 12:18 AM, Ashley Sheridan wrote: The problem is where 2 people choose the same instant to perform an action on your site that inserts a record into your db. The db engine inserts them one after the other, and then responds about the max(id) to your PH

Re: [PHP] database abstraction layer

2010-02-02 Thread Robert Cummings
Phpster wrote: Yep, love those race conditions. We have them all over the app cuz the app ciders don't know shit! Mmmm... apple cider... to cure what ails you or at least get you drunk enough to not care about the horrible race conditions >:) Cheers, Rob. -- http://www.interjinn.com Applica

Re: [PHP] database abstraction layer

2010-02-02 Thread Robert Cummings
Rene Veerman wrote: On Wed, Feb 3, 2010 at 12:35 AM, Ashley Sheridan wrote: It's the reason transactions exist, to prevent things happening like this. When you have two actions where one is dependent on the other, unless you have a way to tie them together so that they can't be broken, you run

Re: [PHP] database abstraction layer

2010-02-02 Thread Robert Cummings
Rene Veerman wrote: On Wed, Feb 3, 2010 at 12:18 AM, Ashley Sheridan wrote: The problem is where 2 people choose the same instant to perform an action on your site that inserts a record into your db. The db engine inserts them one after the other, and then responds about the max(id) to your PH

Re: [PHP] database abstraction layer

2010-02-02 Thread Robert Cummings
Rene Veerman wrote: eh thats "randomize the timing of the retry attempt".. On Wed, Feb 3, 2010 at 12:17 AM, Rene Veerman wrote: and after the sleep(rand(1,3)) it might need a short loop like this; $rnd = rand(1,9); $a=0; for ($i=0; $i<$rnd; $i++) { $a++ } to further randomize the retry

Re: [PHP] database abstraction layer

2010-02-02 Thread Robert Cummings
Rene Veerman wrote: i haven't had the pleasure yet of writing for sites that generate so many hits/sec that they'd update the max value of any table at exactly the same time. i usually ask for the max value about 2 milliseconds before doing the insert. And if the insert fails, i can auto-retry v

Re: [PHP] database abstraction layer

2010-02-02 Thread Phpster
Good lord that is exacty the same logic applied in our app. It only takes about 100 users to create the issue. Bastien Sent from my iPod On Feb 2, 2010, at 6:05 PM, Rene Veerman wrote: i haven't had the pleasure yet of writing for sites that generate so many hits/sec that they'd update t

Re: [PHP] database abstraction layer

2010-02-02 Thread Phpster
Yep, love those race conditions. We have them all over the app cuz the app ciders don't know shit! Bastien Sent from my iPod On Feb 2, 2010, at 5:46 PM, Ashley Sheridan wrote: On Tue, 2010-02-02 at 23:19 +0100, Rene Veerman wrote: function getMax($table, $field) If I saw this sort

Re: [PHP] database abstraction layer

2010-02-02 Thread Rene Veerman
On Wed, Feb 3, 2010 at 12:35 AM, Ashley Sheridan wrote: > It's the reason transactions exist, to prevent things happening like this. > When you have two actions where one is dependent on the other, unless you > have a way to tie them together so that they can't be broken, you run the > risk of col

Re: [PHP] database abstraction layer

2010-02-02 Thread Ashley Sheridan
On Wed, 2010-02-03 at 00:31 +0100, Rene Veerman wrote: > On Wed, Feb 3, 2010 at 12:18 AM, Ashley Sheridan > wrote: > > > The problem is where 2 people choose the same instant to perform an > > action on your site that inserts a record into your db. The db engine > > inserts them one after the ot

Re: [PHP] database abstraction layer

2010-02-02 Thread Rene Veerman
On Wed, Feb 3, 2010 at 12:18 AM, Ashley Sheridan wrote: > The problem is where 2 people choose the same instant to perform an > action on your site that inserts a record into your db. The db engine > inserts them one after the other, and then responds about the max(id) to > your PHP script. Then,

Re: [PHP] database abstraction layer

2010-02-02 Thread Ashley Sheridan
On Wed, 2010-02-03 at 00:21 +0100, Rene Veerman wrote: > the auto_increment sytnax is not uniform across servers, is it? > > On Wed, Feb 3, 2010 at 12:11 AM, Ashley Sheridan > wrote: > > > I saw it happen on a site that was getting only about 3000 hits a day. It > > just takes the right combina

Re: [PHP] database abstraction layer

2010-02-02 Thread Ashley Sheridan
On Wed, 2010-02-03 at 00:17 +0100, Rene Veerman wrote: > and after the sleep(rand(1,3)) it might need a short loop like this; > $rnd = rand(1,9); $a=0; > for ($i=0; $i<$rnd; $i++) { $a++ } > > to further randomize the retry attempt.. > > > On Wed, Feb 3, 2010 at 12:05 AM, Rene Veerman wrot

Re: [PHP] database abstraction layer

2010-02-02 Thread Rene Veerman
the auto_increment sytnax is not uniform across servers, is it? On Wed, Feb 3, 2010 at 12:11 AM, Ashley Sheridan wrote: > I saw it happen on a site that was getting only about 3000 hits a day. It > just takes the right combination of circumstances and it all goes pear > shaped. You really should

Re: [PHP] database abstraction layer

2010-02-02 Thread Rene Veerman
eh thats "randomize the timing of the retry attempt".. On Wed, Feb 3, 2010 at 12:17 AM, Rene Veerman wrote: > and after the sleep(rand(1,3)) it might need a short loop like this; > $rnd = rand(1,9); $a=0; > for ($i=0; $i<$rnd; $i++) { $a++ } > > to further randomize the retry attempt.. > >

Re: [PHP] database abstraction layer

2010-02-02 Thread Rene Veerman
and after the sleep(rand(1,3)) it might need a short loop like this; $rnd = rand(1,9); $a=0; for ($i=0; $i<$rnd; $i++) { $a++ } to further randomize the retry attempt.. On Wed, Feb 3, 2010 at 12:05 AM, Rene Veerman wrote: > i haven't had the pleasure yet of writing for sites that generate

Re: [PHP] database abstraction layer

2010-02-02 Thread Ashley Sheridan
On Wed, 2010-02-03 at 00:05 +0100, Rene Veerman wrote: > i haven't had the pleasure yet of writing for sites that generate so many > hits/sec that > they'd update the max value of any table at exactly the same time. > > i usually ask for the max value about 2 milliseconds before doing the > inser

Re: [PHP] database abstraction layer

2010-02-02 Thread Rene Veerman
i haven't had the pleasure yet of writing for sites that generate so many hits/sec that they'd update the max value of any table at exactly the same time. i usually ask for the max value about 2 milliseconds before doing the insert. And if the insert fails, i can auto-retry via a wrapper function

Re: [PHP] database abstraction layer

2010-02-02 Thread Ashley Sheridan
On Tue, 2010-02-02 at 23:19 +0100, Rene Veerman wrote: > function getMax($table, $field) If I saw this sort of code I'd be appalled! It's possibly the worst way to get the auto increment value. You won't notice it testing the site out on your own, but all hell will break loose when you start get

Re: [PHP] database abstraction layer

2010-02-02 Thread Rene Veerman
oh, on using adodb.sf.net and 0-overhead for jumping between mysql and postgresql; keep all your queries to as simple & early-standard sql as possible. the auto_increment incompatibilities can be circumvented with a relatively simple function getMax($table, $field) { in adodb, you'd loop through

Re: [PHP] database abstraction layer

2010-02-02 Thread Paul M Foster
On Tue, Feb 02, 2010 at 01:15:22PM -0800, Daevid Vincent wrote: > > -Original Message- > > From: Lars Nielsen [mailto:l...@mit-web.dk] > > Sent: Tuesday, February 02, 2010 12:24 PM > > To: php-general@lists.php.net > > Subject: [PHP] database abstraction laye

RE: [PHP] database abstraction layer

2010-02-02 Thread Daevid Vincent
> -Original Message- > From: Lars Nielsen [mailto:l...@mit-web.dk] > Sent: Tuesday, February 02, 2010 12:24 PM > To: php-general@lists.php.net > Subject: [PHP] database abstraction layer > > Hi List > > I am trying to make a Database Abstraction Layer so

Re: [PHP] database abstraction layer

2010-02-02 Thread Paul M Foster
On Tue, Feb 02, 2010 at 09:23:47PM +0100, Lars Nielsen wrote: > Hi List > > I am trying to make a Database Abstraction Layer so I can which the DB > of my application between MySQL and Postgresql. I have been looking at > the way phpBB does it, and it seems that it is only then php-functions > wh

Re: [PHP] database abstraction layer

2010-02-02 Thread Rene Veerman
i'm a fan of adodb.sf.net, which i've used with both postgresql and mysql. On Tue, Feb 2, 2010 at 9:23 PM, Lars Nielsen wrote: > Hi List > > I am trying to make a Database Abstraction Layer so I can which the DB > of my application between MySQL and Postgresql. I have been looking at > the way ph

Re: [PHP] database abstraction layer

2010-02-02 Thread Lester Caine
Lars Nielsen wrote: Hi List I am trying to make a Database Abstraction Layer so I can which the DB of my application between MySQL and Postgresql. I have been looking at the way phpBB does it, and it seems that it is only then php-functions which are different. The SQL seems to be the same. Is

Re: [PHP] database abstraction layer

2010-02-02 Thread Michael A. Peters
Lars Nielsen wrote: Hi List I am trying to make a Database Abstraction Layer so I can which the DB of my application between MySQL and Postgresql. I have been looking at the way phpBB does it, and it seems that it is only then php-functions which are different. The SQL seems to be the same. Is

Re: [PHP] database abstraction layer

2010-02-02 Thread James Colannino
Lars Nielsen wrote: Is it save to assume that I can use the same SQL, or should i make some exceptions? Standard SQL should work across all SQL servers with only a few exceptions (for example, MySQL doesn't support full outer joins.) Anything that has to do with server administration, howeve

[PHP] database abstraction layer

2010-02-02 Thread Lars Nielsen
Hi List I am trying to make a Database Abstraction Layer so I can which the DB of my application between MySQL and Postgresql. I have been looking at the way phpBB does it, and it seems that it is only then php-functions which are different. The SQL seems to be the same. Is it save to assume that

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

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

Re: [PHP] Database abstraction?

2008-04-17 Thread Jason Pruim
On Apr 17, 2008, at 2:22 PM, Jim Lucas wrote: Jim Lucas wrote: Jim Lucas wrote: Jason Pruim wrote: On Apr 17, 2008, at 11:14 AM, Jim Lucas wrote: Stut wrote: On 17 Apr 2008, at 13:33, Jason Pruim wrote: Maybe I'm showing my ignorance here in programming... Maybe it's because I delt with

Re: [PHP] Database abstraction?

2008-04-17 Thread Jim Lucas
Jim Lucas wrote: Jim Lucas wrote: Jason Pruim wrote: On Apr 17, 2008, at 11:14 AM, Jim Lucas wrote: Stut wrote: On 17 Apr 2008, at 13:33, Jason Pruim wrote: Maybe I'm showing my ignorance here in programming... Maybe it's because I delt with a kid who decided to scream for a good share of

Re: [PHP] Database abstraction?

2008-04-17 Thread Jim Lucas
Jason Pruim wrote: On Apr 17, 2008, at 2:12 PM, Jim Lucas wrote: Jason Pruim wrote: On Apr 17, 2008, at 11:14 AM, Jim Lucas wrote: Stut wrote: [/snip] Both ideas worked great... Thank you! Now I do still have one question, I decided that what Jim put up worked a little bit better for

Re: [PHP] Database abstraction?

2008-04-17 Thread Jim Lucas
Jim Lucas wrote: Jason Pruim wrote: On Apr 17, 2008, at 11:14 AM, Jim Lucas wrote: Stut wrote: On 17 Apr 2008, at 13:33, Jason Pruim wrote: Maybe I'm showing my ignorance here in programming... Maybe it's because I delt with a kid who decided to scream for a good share of the night and I'm

Re: [PHP] Database abstraction?

2008-04-17 Thread Jason Pruim
On Apr 17, 2008, at 2:12 PM, Jim Lucas wrote: Jason Pruim wrote: On Apr 17, 2008, at 11:14 AM, Jim Lucas wrote: Stut wrote: [/snip] Both ideas worked great... Thank you! Now I do still have one question, I decided that what Jim put up worked a little bit better for me so I'm going off

Re: [PHP] Database abstraction?

2008-04-17 Thread Jim Lucas
Jason Pruim wrote: On Apr 17, 2008, at 11:14 AM, Jim Lucas wrote: Stut wrote: On 17 Apr 2008, at 13:33, Jason Pruim wrote: Maybe I'm showing my ignorance here in programming... Maybe it's because I delt with a kid who decided to scream for a good share of the night and I'm sleep deprived :)

Re: [PHP] Database abstraction?

2008-04-17 Thread Jason Pruim
On Apr 17, 2008, at 11:14 AM, Jim Lucas wrote: Stut wrote: On 17 Apr 2008, at 13:33, Jason Pruim wrote: Maybe I'm showing my ignorance here in programming... Maybe it's because I delt with a kid who decided to scream for a good share of the night and I'm sleep deprived :) But in my current

Re: [PHP] Database abstraction?

2008-04-17 Thread Jim Lucas
Stut wrote: On 17 Apr 2008, at 13:33, Jason Pruim wrote: Maybe I'm showing my ignorance here in programming... Maybe it's because I delt with a kid who decided to scream for a good share of the night and I'm sleep deprived :) But in my current system I have this: echo <<

Re: [PHP] Database abstraction?

2008-04-17 Thread Richard Heyes
And since no word in the English language begins with FT You're forgetting Ftork... -- Richard Heyes +-+ |Access SSH through a Windows mapped drive| |http://www.phpguru.org/sftpdrive | +-+ -- PHP General M

Re: [PHP] Database abstraction?

2008-04-17 Thread Daniel Brown
On Thu, Apr 17, 2008 at 10:24 AM, Richard Heyes <[EMAIL PROTECTED]> wrote: > > SASH > > That should have been SSH of course - seems my spell checker isn't very > technical... > +-+ > |Access SSH through a Windows mapped drive| > |http://www.phpguru.or

Re: [PHP] Database abstraction?

2008-04-17 Thread Jason Pruim
On Apr 17, 2008, at 10:26 AM, Daniel Brown wrote: On Thu, Apr 17, 2008 at 10:19 AM, Richard Heyes <[EMAIL PROTECTED]> wrote: Daniel Brown wrote: On Thu, Apr 17, 2008 at 8:38 AM, Jason Pruim <[EMAIL PROTECTED]> wrote: I took a quick look at it, and quickly realized you know more then me

Re: [PHP] Database abstraction?

2008-04-17 Thread Daniel Brown
On Thu, Apr 17, 2008 at 10:19 AM, Richard Heyes <[EMAIL PROTECTED]> wrote: > Daniel Brown wrote: > > > On Thu, Apr 17, 2008 at 8:38 AM, Jason Pruim <[EMAIL PROTECTED]> wrote: > > > > > I took a quick look at it, and quickly realized you know more then me > :P > > > I'll dig into it more today hope

Re: [PHP] Database abstraction?

2008-04-17 Thread Richard Heyes
> SASH That should have been SSH of course - seems my spell checker isn't very technical... -- Richard Heyes +-+ |Access SSH through a Windows mapped drive| |http://www.phpguru.org/sftpdrive | +-+ -- PHP

Re: [PHP] Database abstraction?

2008-04-17 Thread Richard Heyes
Daniel Brown wrote: On Thu, Apr 17, 2008 at 8:38 AM, Jason Pruim <[EMAIL PROTECTED]> wrote: I took a quick look at it, and quickly realized you know more then me :P I'll dig into it more today hopefully once the caffeine kicks in better and I can make a full sentence without having it take me 5

Re: [PHP] Database abstraction?

2008-04-17 Thread Daniel Brown
On Thu, Apr 17, 2008 at 8:38 AM, Jason Pruim <[EMAIL PROTECTED]> wrote: > > I took a quick look at it, and quickly realized you know more then me :P > I'll dig into it more today hopefully once the caffeine kicks in better and > I can make a full sentence without having it take me 5 minutes :)

Re: [PHP] Database abstraction?

2008-04-17 Thread Stut
On 17 Apr 2008, at 13:33, Jason Pruim wrote: Maybe I'm showing my ignorance here in programming... Maybe it's because I delt with a kid who decided to scream for a good share of the night and I'm sleep deprived :) But in my current system I have this: echo <<

Re: [PHP] Database abstraction?

2008-04-17 Thread Jason Pruim
On Apr 16, 2008, at 10:55 AM, Richard Heyes wrote: I'm back with yet another question But getting closer to sounding like I know what I'm talking about and that's all thanks to all of you. A free beer (Or beverage of choice)* for everyone who has helped me over the years! I would pref

Re: [PHP] Database abstraction?

2008-04-17 Thread Jason Pruim
On Apr 17, 2008, at 2:16 AM, Chris wrote: Jason Pruim wrote: On Apr 16, 2008, at 5:37 PM, Chris wrote: Jason Pruim wrote: Hi Everyone! I'm back with yet another question But getting closer to sounding like I know what I'm talking about and that's all thanks to all of you. A free beer

Re: [PHP] Database abstraction?

2008-04-16 Thread Chris
Jason Pruim wrote: On Apr 16, 2008, at 5:37 PM, Chris wrote: Jason Pruim wrote: Hi Everyone! I'm back with yet another question But getting closer to sounding like I know what I'm talking about and that's all thanks to all of you. A free beer (Or beverage of choice)* for everyone who ha

Re: [PHP] Database abstraction?

2008-04-16 Thread Jason Pruim
On Apr 16, 2008, at 5:37 PM, Chris wrote: Jason Pruim wrote: Hi Everyone! I'm back with yet another question But getting closer to sounding like I know what I'm talking about and that's all thanks to all of you. A free beer (Or beverage of choice)* for everyone who has helped me over

Re: [PHP] Database abstraction?

2008-04-16 Thread Nathan Nobbe
On Wed, Apr 16, 2008 at 1:30 PM, Richard Heyes <[EMAIL PROTECTED]> wrote: > hope ya dont mind if i borrow that one :D > > > > arm, have you seen my website...? :-) > umm; sry, havent :( i was reading through it, and i was like; holy shit; that dudes from the > list !! btw, i talked to the guy

Re: [PHP] Database abstraction?

2008-04-16 Thread Chris
Jason Pruim wrote: Hi Everyone! I'm back with yet another question But getting closer to sounding like I know what I'm talking about and that's all thanks to all of you. A free beer (Or beverage of choice)* for everyone who has helped me over the years! Here's my question... I have a pr

Re: [PHP] Database abstraction?

2008-04-16 Thread Richard Heyes
hope ya dont mind if i borrow that one :D arm, have you seen my website...? :-) i was reading through it, and i was like; holy shit; that dudes from the list !! btw, i talked to the guy who wrote solar, when i was in dc last year. really cool fellow; but i talked his ear off :O Hope you re

Re: [PHP] Database abstraction?

2008-04-16 Thread Nathan Nobbe
On Wed, Apr 16, 2008 at 9:15 AM, Richard Heyes <[EMAIL PROTECTED]> wrote: > off-subject (yes total thread robbery here [more of a side note really]). > > i saw a reference to some of your work in the Solar framework richard, for > > clearing out the 'environment' or rather the superglobal arrays

Re: [PHP] Database abstraction?

2008-04-16 Thread Richard Heyes
off-subject (yes total thread robbery here [more of a side note really]). i saw a reference to some of your work in the Solar framework richard, for clearing out the 'environment' or rather the superglobal arrays. good stuff. Thanks (I think you're referring to clearing register_globals cra

Re: [PHP] Database abstraction?

2008-04-16 Thread Larry Garfield
On Wed, 16 Apr 2008 10:43:15 -0400, Jason Pruim <[EMAIL PROTECTED]> wrote: > Hi Everyone! > > I'm back with yet another question But getting closer to sounding > like I know what I'm talking about and that's all thanks to all of > you. A free beer (Or beverage of choice)* for everyone who has

Re: [PHP] Database abstraction?

2008-04-16 Thread Steve Holmes
Assuming a recent release of MySQL: open the schema information_schema then select TABLE_NAME, COLUMN_NAME from COLUMNS where TABLE_NAME = '$table'; Steve On Wed, Apr 16, 2008 at 10:55 AM, Richard Heyes <[EMAIL PROTECTED]> wrote: > I'm back with yet another question But getting closer to so

Re: [PHP] Database abstraction?

2008-04-16 Thread Nathan Nobbe
On Wed, Apr 16, 2008 at 8:55 AM, Richard Heyes <[EMAIL PROTECTED]> wrote: > I'm back with yet another question But getting closer to sounding like > > I know what I'm talking about and that's all thanks to all of you. A free > > beer (Or beverage of choice)* for everyone who has helped me over

Re: [PHP] Database abstraction?

2008-04-16 Thread Richard Heyes
I'm back with yet another question But getting closer to sounding like I know what I'm talking about and that's all thanks to all of you. A free beer (Or beverage of choice)* for everyone who has helped me over the years! I would prefer hard (or soft) cash... :-) Here's my question... I h

Re: [PHP] Database abstraction?

2008-04-16 Thread David Giragosian
On 4/16/08, Jason Pruim <[EMAIL PROTECTED]> wrote: > > Hi Everyone! > > I'm back with yet another question But getting closer to sounding like > I know what I'm talking about and that's all thanks to all of you. A free > beer (Or beverage of choice)* for everyone who has helped me over the year

[PHP] Database abstraction?

2008-04-16 Thread Jason Pruim
Hi Everyone! I'm back with yet another question But getting closer to sounding like I know what I'm talking about and that's all thanks to all of you. A free beer (Or beverage of choice)* for everyone who has helped me over the years! Here's my question... I have a program, where I wa

Re: [PHP] Database Abstraction Idea

2008-02-27 Thread Ray Hauge
Daniel Brown wrote: Should catch(e) really be catch(Exception $e) ? Something like that. I was paraphrasing, which seems weird, since I was looking at the code for the class description anyway :) Thanks for the info. -- Ray Hauge www.primateapplications.com -- PHP General Mailing Lis

Re: [PHP] Database Abstraction Idea

2008-02-27 Thread Daniel Brown
On Wed, Feb 27, 2008 at 12:30 PM, Ray Hauge <[EMAIL PROTECTED]> wrote: > I've been working on a project that was started from scratch. I'm a > minimalist, so I like to keep things as simple as possible. I've been > using this idea for a database abstraction, and I thought I'd see if I > could

[PHP] Database Abstraction Idea

2008-02-27 Thread Ray Hauge
I've been working on a project that was started from scratch. I'm a minimalist, so I like to keep things as simple as possible. I've been using this idea for a database abstraction, and I thought I'd see if I could get some constructive criticism. Here is an example of how I use this first:

[PHP] Re: [PHP-DB] PHP Database Abstraction Layer

2003-02-06 Thread Maxim Maletsky
"Luke Woollard" <[EMAIL PROTECTED]> wrote... : > I once read a great article in the first or second issue of > http://www.phparch.com/ on database abstraction layers. At which point I > used the tutorial as a starting point for creating a very similar structure > I named dbWave. There are only mi

[PHP] PHP Database Abstraction Layer

2003-02-05 Thread Luke Woollard
I once read a great article in the first or second issue of http://www.phparch.com/ on database abstraction layers. At which point I used the tutorial as a starting point for creating a very similar structure I named dbWave. There are only minor differences and a postgresql driver is now included f

[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

RE: [PHP] Database Abstraction Suite

2002-06-13 Thread SP
-Original Message- From: David Russell [mailto:[EMAIL PROTECTED]] Sent: June 13, 2002 10:05 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Database Abstraction Suite Hi all I am busy developing a PHP DB application. I obviously want this to be as portable as possible - and t

[PHP] Database Abstraction Suite

2002-06-13 Thread David Russell
Hi all I am busy developing a PHP DB application. I obviously want this to be as portable as possible - and then went to the Zend pages. I have looked at the DB abstraction Applications. There are five or so which have all been rated as a four dot (I presume out of 5). Does anyone have any ex

RE: [PHP] Database abstraction layer oci

2002-03-11 Thread Andrew Hill
e- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, March 08, 2002 5:39 AM > > > To: [EMAIL PROTECTED] > > > Subject: [PHP] Database abstraction layer oci > > > > > > > > > > > > Hi everybody. > &g

Re: [PHP] Database abstraction layer oci

2002-03-09 Thread Thies C. Arntzen
angelism > http://www.openlinksw.com/virtuoso/whatis.htm > OpenLink Virtuoso Internet Data Integration Server > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Friday, March 08, 2002 5:39 AM > > To: [EMAIL PROTECTED] &

RE: [PHP] Database abstraction layer oci

2002-03-08 Thread Andrew Hill
March 08, 2002 5:39 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Database abstraction layer oci > > > > Hi everybody. > > I would like your opinion on the Database Abstraction Layer you prefer (I > will use it with Oracle 8i) > I know that there is Metabase end Pear

[PHP] Database abstraction layer oci

2002-03-08 Thread DrouetL
Hi everybody. I would like your opinion on the Database Abstraction Layer you prefer (I will use it with Oracle 8i) I know that there is Metabase end Pear DB What's your opinion on both or others ? Laurent Drouet -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: htt

[PHP] database abstraction module

2001-03-14 Thread Marc Boeren
Hi! I'ld like to announce the availability of a database abstraction module, called 'dbx'. It gives you the ability to code your database-enabled php-templates once (for a specific database), and port to a different database later by just changing the string "odbc" to "mysql" (e.g.) once. This