Re: [PHP] Pear DB

2008-07-10 Thread Lester Caine
John Comerford wrote: Hi Folks, I have just successfully lobbied for the company I work for to use PHP/MySQL for our next website. My Question is regarding DB abstraction . I know there is a Pear DB module, is this the best to use ? I have a vague memory of reading somewhere that there is

RE: [PHP] Pear DB

2008-07-10 Thread Alex Chamberlain
> Hi Folks, > > I have just successfully lobbied for the company I work for to use > PHP/MySQL for our next website. My Question is regarding DB abstraction > . I know there is a Pear DB module, is this the best to use ? I have a > vague memory of reading somewhere that there is a newer lib o

Re: [PHP] Pear DB

2008-07-10 Thread Larry Garfield
PEAR::DB was deprecated years ago. Do not use it. PEAR::MDB2 is the preferred PEAR wrapper these days. Personally, I skip them both and prefer to go straight to PDO, available in PHP 5. http://www.php.net/pdo On Thursday 10 July 2008 1:47:34 am John Comerford wrote: > Hi Folks, > > I ha

Re: [PHP] Pear DB

2008-07-10 Thread Jason Norwood-Young
On Thu, 2008-07-10 at 16:47 +1000, John Comerford wrote: > Hi Folks, > > I have just successfully lobbied for the company I work for to use > PHP/MySQL for our next website. My Question is regarding DB abstraction > . I know there is a Pear DB module, is this the best to use ? I have a > va

Re: [PHP] PEAR::DB and PDO

2006-08-01 Thread Ezra Nugroho
I've used PDO, PEAR::DB, and ADOdb. I like ADOdb the most. You'd love it's new Active Record extension. On Tue, 2006-08-01 at 18:47 +0100, Yannick Warnier wrote: > Hi there, > > I will soon need to include a database abstraction layer in my company's > software and I am looking for the best ch

Re: [PHP] PEAR::DB and PDO

2006-08-01 Thread Lester Caine
Yannick Warnier wrote: Hi there, I will soon need to include a database abstraction layer in my company's software and I am looking for the best choice to make. The software is promoted as working with PHP4, so I wouldn't use PDO, although I see that a PHP4 implementation of PDO exists [1] and

Re: [PHP] Pear DB and memcached

2006-06-06 Thread Richard Lynch
Resources cannot be stored from script to script. PHP cleans them up and nukes their contents at script end. This is what all the "frameworks" folks are trying to "fix"... :-) :-) :-) On Tue, June 6, 2006 8:55 am, Ruben Rubio Rey wrote: > Hi, > > Im having a trouble using memcached with pear db

Re: [PHP] PEAR DB nextId() sequences

2006-05-04 Thread Richard Lynch
On Thu, May 4, 2006 2:48 pm, Drew Butler wrote: > Just had a quick question for anyone out there. I've been using PEAR's > DB > object for quite a while, as I have to simultaneously work with both > MySQL > and PostgreSQL. Currently I use the nextID() method to find new IDs > for the > rows that I

Re: [PHP] PEAR DB vs ADODB

2004-12-30 Thread Lester Caine
Matthew Weier O'Phinney wrote: There's not much benefit or point in PEAR developers developing for a non-PEAR library -- the idea is to create a set of high quality libraries following a common set of coding standards and practices; compatibility with outside libraries doesn't make sense if those l

Re: [PHP] PEAR DB vs ADODB

2004-12-29 Thread Matthew Weier O'Phinney
* [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > > Haven't done much with either of them, besides reading docs, but I'd > > lean towards ADODB for its exception handling(with php5), if you > > need error handling. > > > > Having that said, I haven't really a clue what I'm talking about in > > this regard

Re: [PHP] PEAR DB vs ADODB

2004-12-28 Thread daniel
> Haven't done much with either of them, besides reading docs, but I'd > lean towards ADODB for its exception handling(with php5), if you need > error handling. > > Having that said, I haven't really a clue what I'm talking about in > this regard, so I'll be listening in with interest. > I'm assum

Re: [PHP] PEAR DB vs ADODB

2004-12-28 Thread Rory Browne
Haven't done much with either of them, besides reading docs, but I'd lean towards ADODB for its exception handling(with php5), if you need error handling. Having that said, I haven't really a clue what I'm talking about in this regard, so I'll be listening in with interest. On Wed, 29 Dec 2004 1

Re: [PHP] PEAR DB flipped fetch mode

2003-09-13 Thread Curt Zirzow
* Thus wrote Dan Phiffer ([EMAIL PROTECTED]): > Could somebody explain (or point me to some online docs) the usage of > DB_FETCHMODE_FLIPPED, defined by PEAR DB? I feel like I've seen it mentioned > on the PEAR site, but somehow I can't find it now. > > I'm pretty sure it's on a page linked from h

RE: [PHP] PEAR DB class

2002-02-14 Thread Matthew Walker
Sure is legal. I use it all /over/ the place. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Gary [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:26 PM To: [EMAIL PROTECTED] Subject: [PHP] PEAR DB class Hi all, Before I get starte

RE: [PHP] PEAR DB Results

2001-10-31 Thread Jeremy Allen
Based on the snippet you have sent us you need to at least start by enclosing your column names in your accesses to the associative array containing your results. Each line just use print_r or var_dump: while($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) { print_r($row); } This will sh

RE: [PHP] PEAR DB Questions

2001-09-26 Thread Matthew Walker
Thanks. That will work quite nicely. -Original Message- From: Jack Dempsey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 1:20 PM To: Matthew Walker; [EMAIL PROTECTED] Subject: RE: [PHP] PEAR DB Questions don't know about pear, but in case you can't do it,

RE: [PHP] PEAR DB Questions

2001-09-26 Thread Jack Dempsey
don't know about pear, but in case you can't do it, there's a mysql version- LAST_INSERT_ID() like this: mysql> select last_insert_id(); +--+ | last_insert_id() | +--+ | 262 | +--+ 1 row in set (0.04 sec) -jack -Original Message--