|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #21418 Changing PEAR::DB
Submitted: 2003-01-04 17:18 UTC Modified: 2003-01-04 19:36 UTC
From: bmichael at goldparrot dot com Assigned:
Status: Not a bug Package: Feature/Change Request
PHP Version: 4.2.3 OS:
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: bmichael at goldparrot dot com
New email:
PHP Version: OS:


 [2003-01-04 17:18 UTC] bmichael at goldparrot dot com
I am justing getting into working with the PEAR::DB and DB_DataObjects code.

I have some changes that I am making to PEAR::DB and would like to know who to talk to or how I should submit those changes.

The following is what I am changing:

In PEAR::DB common.php file:
   Added  an new option to the $options array:
             'setPrefetch' => 1

For advanced Oracle queries, you use the OCI8setPrefetch limit to > 1. Other databases might find this useful for processing large queries if supported by the database type.

Secondly, in PEAR::DB DB.php
   I am adding a fetchStatement routine to DB_result class that supports limiting and the rownum feature.  This then calls the appropriate $this->dbh->fetchStatement() routine.

There are others as well, adding a static variable to numCols and numRows so that fetchStatement can load these variables, while fetchInto and fetchRow stills functions as expected.

In DB_oci8, changed constructor to use OCI8setPrefetch based upon the $this->option["setPrefetch"]

Created an OCI8setPrefetch function so that it can be called specifically/dynamically when the option changes. Currently the change only is reflected in new DB objects after setOptions is called.

As mentioned, changed numRows/numCols also in DB_oci8.

Adding DB_AUTOQUERY_DELETE to buildManipSQL.

Other changes, I am adding. Get number of rows for table in tableInfo for oci8.  Can use statistics from the table or use COUNT(*) - I will be doing this shortly.

I am doing a very large project with PEAR::DB and DB_DataObjects using Oracle to start, with versions running on mysql, mssql, potentially access, db2, Sybase, etc.  

In doing so, I have created an offshoot of DB_Dataobjects that will fully sustain many Databases in the same fashion as PEAR::DB. Alan and I have already talked about it.  But I am just informing the community.

How can I submit the changes to the PEAR::DB code.      


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2003-01-04 17:44 UTC]
Not a bug please talk about it in

Try to contact the leader of the package who is Stig or look at

If you want to join the PEAR developper team please fill

Thank you for your report.
 [2003-01-04 19:36 UTC]
It's actually:
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Jul 16 20:01:29 2024 UTC