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
> 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
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
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
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 or somethin
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
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
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 I could
use this one (any
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
Hi,
Im having a trouble using memcached with pear db.
When im using memcache to store and retrieve an string, all works fine.
When Im using memcache to store a pear db resulset, it does not work!!
This retrieves data but pear::db does not understand it.
I really dont know
Any ideas?
Thanks in
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
Hey guys,
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 insert, but am running into an issue with its sequ
I'm using PEAR::DB to connect to a MS SQL Server 2000.
I'm attempting to run the following query:
SELECT * FROM myTable FOR XML AUTO, ELEMENTS
When I run the above query using the Query Analyzer, I get back
the results as expected. However, when I try to run the same query
using PEAR, I get the
I originally submitted this to the PHP DB mailing list. Hopefully
someone on this list not on the other can give me some help.
My company runs a Linux based PHP website with a MySQL database backend.
We also have several MSSQL databases deployed throughout the
organization. One of our MSSQL dat
Hi,
Having heard good things about the PEAR DB package I wanted to try
it out on a new project. I'm using PHP 5.0.3, ran the go-pear and
installed the latest version but upon including it in my script it
brings up rafts of errors such as:
Strict Standards: Assigning the return value o
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
* [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
> 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
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
Hi there I am in a bit of a dilemma, I have been leaning towards ADODB for
its speed, but I amliking to use some pear components that only handle pear db
etc .. Honest
opinions, I am doingweb applications and building a little framework for it,
will I notice any
performance differences if Iuse DB
Salut!
is there a good way to present data from table (many fields / not only one)
into $itemData instead of array_push (line 12 .. 16) ?
And how come the result always has space (kinda ) and it's moving
upper and upper when I click Next.
Correction to my code below would be very welcome .
1 quer
Hello,
I've just performed a few tests when using PEAR::DB and
the results weren't good at all.
If I compare a script using PEAR::DB with a script using
standard functions (and which supports mysql, pgsql and
sqlite databases), the script using PEAR::DB is 10 times
slower than the other.
In one of
[This has be cross-posted. Be careful when following up, please.]
Greetings:
Crack open the beer, PEAR DB 1.6.0 is here! (Hey, I'm a bit giddy
with excitement that my intense work during the past seven weeks
has come to fruition.)
For those unfamiliar with PEAR DB, it's a package of PHP classes
Hello Again:
Another release of PEAR DB was made yesterday, 1.6.0RC5.
The most important change was fixing the bug for people who use
arrays for the DSN information when connecting.
It also adds a new method called quoteIdentifier(), which is used
for delimiting identifiers (such as field names
Hi Folks:
I just released version 1.6.0RC4 of PEAR DB. Several things have been
fixed since RC1 which is included with the latest PHP RC release. Also,
if you're using 1.5.0 variants or earlier, definitely check out the new
version for loads of enhancements and way fewer bugs.
I've also spent a
I'm having some problems with the DB::isError function identifying a
non-object as an error object (or so it seems). I'm using postgreSQL
7.3.x. The relevant code is below:
/***[ my code start ]***/
$sql_queries = array();
* 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
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 here:
http://pear.php.net/manual/en/package.database.php
Anyone intersted in helping integrate PHPMyAdmin to PEAR? It's seperate
from phpMyAdmin right now, but might be integrated later...
-Michael
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello,
I am using a script running PEAR. I did a:
$db = DB::connect($database_string);
at I get the error:
Fatal error: Undefined class name 'db' in
/var/www/html/prattcms/variables/global.inc.php on line 17
Any ideas?
-Michael
--
Some people's minds are like cement; all mixed up and permanentl
Hi, I'm a bit new to mySQL. I got my program working fine locally, but it
doesn't work when I upload it to my ISP.
db.php and pear.php couldn't be found on my server when I first ran it. I
uploaded them, but could that be part of my problem?
The following code is returning "DB Error: not found":
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
Hi all,
Before I get started and have to figure out a problem. Is it legal in
PEAR DB to connect like this
$dbh = DB::connect("mysql://$user:$pass@$host/$dname); where user,
password, host and database names are coming from an include?
TIA
Gary
--
PHP General Mailing List (http://www.php.n
neral Mailing List
Subject: [PHP] PEAR DB Results
I am trying to do a joined query using PEAR DB? My code looks something like
this:
$sql = "SELECT wwwpages.pid,wwwpages.name,media.pid,media.name FROM
wwwpages, media WHERE wwwpages.pid = '$pid'";
if(DB::isError($result
I am trying to do a joined query using PEAR DB? My code looks something like
this:
$sql = "SELECT wwwpages.pid,wwwpages.name,media.pid,media.name FROM
wwwpages, media WHERE wwwpages.pid = '$pid'";
if(DB::isError($result = $db->query($sql))){
echo "ERROR:" . DB::errorMessage($result);
} else {
w
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,
--Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 2:24 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PEAR DB Questions
I've got the docs you all mentioned in response to my earlier questions.
Thanks a ton! They were almost exactly what I ne
I've got the docs you all mentioned in response to my earlier questions.
Thanks a ton! They were almost exactly what I needed.
There's only one thing that I can't figure out how to do with the
module. In PHP, there's a function 'mysql_insert_id()'. It returns the
Autoincriment ID of the last ins
can anyone help with PEAR nextId() function.
it's in mysql.php but NOT part of DB.php
usage?
rgds.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PR
ssb Thu Mar 22 17:15:10 2001 EDT
Modified files:
/php4/pear DB.php PEAR.php.in
/php4/pear/DB STATUS common.php oci8.php
/php4/pear/DB/tests errors.inc fetchrow.inc numrows.inc
sequences.inc
/php4/pear/DB/tests/ibase
ssb Tue Jan 9 17:02:00 2001 EDT
Added files:
/php4/pear/scripts pear.in php-config.in phpextdist phpize.in
Removed files:
/php4/pear pear.in php-config.in phpextdist phpize.in run-tests.in
Modified files:
/php4/pea
41 matches
Mail list logo
