PEAR is archived and read-only

This mirror preserves historical PEAR package releases and metadata so existing references remain available.

Home » Database » DB

Database Abstraction Layer

Download latest release 1.12.3 (there might be newer Composer installable version)

License: PHP License

Description

DB is a database abstraction layer providing:
* an OO-style query API
* portability features that make programs written for one DBMS work with other DBMS's
* a DSN (data source name) format for specifying database servers
* prepare/execute (bind) emulation for databases that don't support it natively
* a result object for each query response
* portable error codes
* sequence emulation
* sequential and non-sequential row fetching as well as bulk fetching
* formats fetched rows as associative arrays, ordered arrays or objects
* row limit support
* transactions support
* table information interface
* DocBook and phpDocumentor API documentation

DB layers itself on top of PHP's existing
database extensions.

Drivers for the following extensions pass
the complete test suite and provide
interchangeability when all of DB's
portability options are enabled:

fbsql, ibase, informix, msql, mssql,
mysql, mysqli, oci8, odbc, pgsql,
sqlite and sybase.

There is also a driver for the dbase
extension, but it can't be used
interchangeably because dbase doesn't
support many standard DBMS features.

DB is compatible with PHP 5 and PHP 8.

Documentation

Manual

Maintainers

Dependencies

Required

Releases

Bugs

IDStatusTypeVersionDateSummary
#6ClosedBug2003-09-14tableInfo() returns no flags under mssql
#13ClosedBug2003-09-16Connect broken Null PW in Mysql 4.0.15
#25Wont fixBug2003-09-21DB::factory() left to bitrot, DB::connect() duplicates code
#31ClosedBug2003-09-23Ampersand in WHERE clause of Autoexecute statement causes error
#37BogusBug2003-09-26Error in DB
#42BogusBug2003-09-28Erroneous sequence tracking for PostgreSQL
#49ClosedBug2003-09-30sybase simpleQuery is broken
#51ClosedBug2003-09-30SQL Server 2000 Text column problem
#53ClosedBug2003-10-01cannot use prepared statement where sql contains \' special character
#58BogusBug2003-10-03ODBC result not freed for UPDATE and INSERT
#72ClosedBug2003-10-07OCI8 Execute always requires placeholders
#73ClosedBug2003-10-07[PATCH] OCI8 Prepare() does not raise SQL parse error
#77ClosedBug2003-10-07PEAR DB OCI8 calls could suppress output when followed by oci8RaiseError
#81ClosedBug2003-10-08PEAR::DB mssql implementation uses fetch_array where intension is fetch_assoc
#82BogusBug2003-10-09loading of php-extension fails
#91ClosedBug2003-10-13OCI8 Prepare() does not allow '!' as placeholder
#97Wont fixReq2003-10-13Native Sequence Lookup for postgres
#101ClosedBug2003-10-14fetchRow method in oci8 backend ignores options["optimize"] setting
#104BogusBug2003-10-15query() does not return bind variable in stored procedure call
#107Wont fixBug2003-10-15pgsql does not handle BYTEA througth the '&' placeholder in the prepare method
#135ClosedBug2003-10-22DB_pgsql: invalid replacing of sequence names
#161BogusBug2003-10-28Sybase: Stored Procedure fails
#162ClosedBug2003-10-28DB::executeEmulateQuery() error
#181ClosedBug2003-11-01MSSQL: transaction logic problem with multiple tables and concurrent inserts
#206ClosedBug2003-11-06Authentication using PEAR ok with mysql, not with oci
#227DuplicateBug2003-11-12Wrong Object handle with PHP5
#229ClosedBug2003-11-12getXxx methods return null result when used with $params array
#230ClosedBug2003-11-12Add tableinfo()
#231DuplicateBug2003-11-12sybase fetchInto() returns incompatible data
#232ClosedBug2003-11-12getAssoc ignores $fetchMode
#234ClosedBug2003-11-12DB_*::quote() needs straightening up
#241Wont fixBug2003-11-13DB::common autoExecuteMultiple
#276DuplicateBug2003-11-19Bind variables do not work with oci8 calls.
#277ClosedBug2003-11-19Fetching Objects with PEAR DB
#287BogusBug2003-11-23nextId() uses wrong sequence
#288ClosedBug2003-11-24Not reading binary files
#292ClosedBug2003-11-25DB::sqlite request for adding error control operator for function calls
#305Wont fixBug2003-11-27_pgFieldFlags() fails for schemas
#339ClosedBug2003-12-03DB::PGSQL doesn't recognize sockets for a pgsql connection
#341ClosedBug2003-12-03no DB::isWarning
#350ClosedBug2003-12-03sybase.php returns on fetchRow(DB_FETCHMODE_ASSOC) array with numerical AND str
#361ClosedBug2003-12-05patch: return non-variables by reference
#363Wont fixBug2003-12-05No support for specifying desired character set
#380ClosedBug2003-12-08Problem with LIMIT in pgsql PEAR::DB
#386BogusBug2003-12-09query hangs
#393ClosedBug2003-12-09DB_storage::setup() warning on multi-columnar primary keys
#397ClosedBug2003-12-10patch: fetchInto() can lowercase keys for all DBMS's
#430Wont fixBug2003-12-15func _isManip and comments in sql-queries
#436BogusBug2003-12-16IBase - The memory could not be "read"
#437ClosedBug2003-12-16patch: sybase connect produces output
#438ClosedBug2003-12-16patch: TESTERS line endings
#446ClosedBug2003-12-17errorCode($errormsg) is not working correctly for postgresql 7.4 (PATCH)
#474ClosedBug2003-12-21A bug in oci8::modifyLimitQuery()
#502BogusBug2003-12-29[PATCH] FreeTDS-Compatible DB_mssql::tableInfo()
#519BogusBug2004-01-04Call to undefined function: raiseerror() in ..DB/common.php on line 1239
#551Wont fixBug2004-01-09mysql sequences cant honour transactions
#564ClosedBug2004-01-13Connection without password disabled in sybase.php
#575ClosedBug2004-01-14no autoPrepare with NULL-Values
#585ClosedBug2004-01-15query() fails with params is assoc array
#593ClosedBug2004-01-16pgsql driver does not properly handle SHOW command
#598ClosedBug2004-01-19IFX fetchrow() broken
#606BogusBug2004-01-21pgsql tableInfo has a bug that free's the result set
#607ClosedBug2004-01-21Can getMessage contain the Oracle error text?
#613ClosedBug2004-01-22Patch: Solution for quoting table and column names OCI8 connection issues
#616BogusBug2004-01-24Warning: Undefined index: autofree in DB.php (when doing a query)
#617ClosedBug2004-01-24Warnings from PhpEclipse
#631ClosedBug2004-01-27Segfault when connecting to the database without password
#669Wont fixReq2004-02-02Singleton method
#679ClosedBug2004-02-04oci8::modifyLimitQuery() Missing quotes for column alias containing spaces
#682ClosedReq2004-02-05getListOf('pgsql:schema.table');
#693ClosedBug2004-02-06Undefined index in mysql.php
#696ClosedBug2004-02-06Some notices can appear
#700Wont fixBug2004-02-06Feature Request: Oracle should allow a "normal" DSN for a non-TNS connection
#724ClosedBug2004-02-10DB/mysql.php $case_func issues w/ patch
#729BogusBug2004-02-10quoteSmart() Notice error (1.6.0RC1)
#739Wont fixBug2004-02-12oci8 numRows only works once for a result
#752ClosedReq2004-02-13getSpecialQuery('synonyms'); for oracle user synonyms
#756BogusBug2004-02-13limit queries not working in peardb using odbc
#769BogusBug2004-02-16Failing to include db-specific files is a fatal error but produces no error msg
#780BogusBug2004-02-17DB/common.php -> DB mismatch (DB 1.6.0RC6)
#792BogusBug2004-02-18? in query with sybse and db->query doesnt work
#811BogusBug2004-02-20Change to DB 1.6.0 Breaks Informix BC
#832No FeedbackReq2004-02-21Deadlock Support Patch
#862BogusBug2004-02-26PEAR QA: improvement for get_class()-usage
#928ClosedReq2004-03-01__wakeup() for serialize & unserialize
#930ClosedBug2004-03-01missing bind-var support in DB oci-numRows-function
#955Wont fixBug2004-03-06SQLRelay backend available
#1005ClosedBug2004-03-12affectedRows returns 0 for 'load data infile'
#1017BogusBug2004-03-15QuoteSmart not very smart (BC break)
#1043BogusBug2004-03-20Call to undefined function: simplequery()
#1046BogusBug2004-03-20Can't change fetchmodes with getAll()
#1049Wont fixReq2004-03-21reset result row-pointer
#1061BogusBug2004-03-24fetchRow problem with limit count=-1
#1086BogusBug2004-03-28DB::isError($res) triggers warning when $res is the result of a DELETE query
#1088ClosedBug2004-03-28Notice because of object-integer-comparison
#1089BogusBug2004-03-29postgresql "permission denied" error ignored when using PEAR_ERROR_RETURN mode
#1099BogusBug2004-03-30db_common->prepare() doesn't allow escaped ?&!
#1112BogusBug2004-04-01Memory Leak in Pear DB
#1117Wont fixReq2004-04-02autoExecuteMultiple
#1142DuplicateBug2004-04-05DB throws conversion error
#1209ClosedReq2004-04-14toString()
#1231BogusBug2004-04-17Wrong escaping of ampersand char '&'
#1234ClosedBug2004-04-17Error in mysqli's escapeSimple
#1243BogusBug2004-04-20prepare() handles "!=" as token
#1297BogusBug2004-04-27Prepare statements don't tolerate extra parameters
#1307BogusReq2004-04-28Allow tableInfo to accept also the db name
#1317ClosedReq2004-04-29tableInfo for SQLite (includes fix)
#1324BogusBug2004-05-01DB-ODBC fails to update memo fields
#1325ClosedBug2004-05-01SQLite module creates dbfile with wrong mode
#1337ClosedReq2004-05-04DB::assertExtension should use PEAR::loadExtension
#1338DuplicateReq2004-05-04Permit oci8:execute() bind output
#1339BogusBug2004-05-04PEAR::DB select distinct ( text field ) Error
#1343Wont fixReq2004-05-04Last Insert Id
#1355BogusBug2004-05-06DB/odbc::quote fails with numeric data stored as strings
#1363ClosedBug2004-05-07mssql_fetch_array($result, MSSQL_ASSOC) fails
#1376Bogus2004-05-10yaz_record function not returning array
#1394BogusBug2004-05-12PEAR DB PROBLEM
#1405BogusBug2004-05-14Could not access DB class in DB\mysql.php
#1410BogusBug2004-05-14DB mssql_field_* functions do not work
#1432BogusBug2004-05-18limitQuery() unable to return very first record in Oracle DB
#1470BogusBug2004-05-22Query across multiple tables does not return proper results
#1495BogusBug2004-05-25getAll() causes segmentation fault with sybase connection
#1511BogusBug2004-05-26Problem using MySQL SQL extensions with prepared statements
#1524BogusBug2004-05-28AutoExecute function return wrong object on Error
#1525BogusBug2004-05-28DB_FETCHMODE_ASSOC doesn't work with MSSQL
#1526No FeedbackBug2004-05-28mysqli DSN needs socket to work
#1549ClosedBug2004-06-03getSpecialQuery() method problem
#1566Wont fixReq2004-06-07show the default value of each field as result of tableInfo
#1607DuplicateReq2004-06-10[patch] PostgreSQL schema (aka namespace) support
#1660DuplicateBug2004-06-16insert does not recognize strings
#1666BogusBug2004-06-17nextId don't create sequence with postgresql and mysql database
#1677ClosedReq2004-06-18Add getQuery() method to DB_Result
#1690BogusBug2004-06-21PEAR::DB no catch query() error ? @mysql
#1725Wont fixBug2004-06-26sysdate, to_date, fail on autoExecute with Oracle
#1771Wont fixReq2004-07-02change getOne() and getRow() to use limitQuery()
#1812ClosedBug2004-07-07sybase_connect - 4th parameter (charset) is never used
#1826ClosedBug2004-07-08If Database in string DSN has '=' won't work
#1834Wont fixBug2004-07-09autocommit with functions in pgsql
#1905ClosedReq2004-07-17Patch : Use new_link with mysql_connect
#1919ClosedBug2004-07-20Incorrect handling of postgres port for unix domain sockets
#1964BogusBug2004-07-23Problem running multiple queries
#1973BogusReq2004-07-24sybase_connect call not backward-compatible
#2011ClosedBug2004-07-28UNABLE TO DETECT CONECTION ERROR WITH PGSQL
#2026BogusBug2004-07-30nextID() produce a warning when sequence dosent exists on sqlite
#2084DuplicateBug2004-08-07DB_pgsql does not handle schemas
#2085ClosedBug2004-08-07getListOf('views') lists Postgresql internal views
#2094ClosedBug2004-08-09escapeSimple applied on autoexecute (sqlite)
#2111BogusBug2004-08-11Faulty Message from freeResults() in sybase.php
#2140ClosedBug2004-08-16Bad syntax in mssql for connection to SQL Server 2000 for non-standard port
#2142ClosedReq2004-08-16DB_dbase does not implement tableInfo()
#2166BogusBug2004-08-19query() does not return db_result object for SELECT
#2198DuplicateBug2004-08-23[MSSQL] can't fetch column name with DB_FETCHMODE_ASSOC
#2218BogusReq2004-08-25failed include because of empty dsn
#2223Wont fixReq2004-08-26combine limitQuery() with getAll()
#2224BogusBug2004-08-26PHP 5.0.1 !!!, give all kinds of e_strict errors
#2234BogusBug2004-08-27Non-static method DB::connect() should not be called statically
#2236Wont fixReq2004-08-27Error messages using gettext
#2307BogusBug2004-09-10numRows() not working properly
#2331ClosedReq2004-09-14code for function getSpecialQuery($type)
#2368BogusBug2004-09-21Using getRow() with an mysql UPDATE command results in a fatal error
#2369BogusBug2004-09-21MSSQL datetime retrieval error for ini_set("mssql.datetimeconvert", 0)
#2374BogusBug2004-09-22$db->tableInfo($resultset) on mysql
#2385ClosedReq2004-09-24ODBC Cursor Type
#2399ClosedBug2004-09-25DB_pgsql->errorCode() regexp test fails
#2404Wont fixReq2004-09-27optimization
#2417ClosedBug2004-09-30[PATCH] Incorrect processing of 'permission denied' style error messages
#2468BogusBug2004-10-06Deprecated code in DB.php
#2469BogusBug2004-10-06method disconnect no Php5/MySQL
#2473BogusBug2004-10-06Mysqli (4.1.4gamma) can't connect to 'localhost'
#2483Wont fixReq2004-10-08prepare type which quotes identifiers
#2518BogusBug2004-10-13Cannot connect to mysql 4.1.5-gamma-nt database
#2552BogusBug2004-10-17query works fine first time only
#2586ClosedBug2004-10-22queries starting with multiple open parentheses are not supported
#2611BogusBug2004-10-25Not suported (?) SQL query.
#2622ClosedBug2004-10-26oci-problem hangs up Apache
#2643BogusBug2004-10-29Wrong tableinfo
#2644Wont fixReq2004-10-29Executed queries
#2649Wont fixBug2004-10-29can't use spaces in coumn names
#2664BogusBug2004-11-01DB::isError() returns FALSE when DB_Error object is passed
#2666BogusBug2004-11-01Transaction problem with mysql "SELECT ... FOR UPDATE"
#2669ClosedReq2004-11-01DB ODBC Table Info
#2673ClosedBug2004-11-02DB::Connect fails to connect to PostgreSQL through UNIX socket.
#2691BogusBug2004-11-04Object Disconnect Closes all connections
#2731ClosedReq2004-11-10mssql connect doesn't work after version 1.6.5 on Linux
#2734BogusBug2004-11-10error in function buildManipSQL
#2743BogusBug2004-11-12PEAR1.3.3 needs deconstructor
#2812BogusReq2004-11-23support for nested transactions (mysql)
#2813ClosedReq2004-11-23support for unbuffered query (mysql)
#2814DuplicateReq2004-11-23create NEW connection (mysql)
#2825BogusBug2004-11-24calling getAll() with array query parametre throws error in DB.php
#2828Wont fixReq2004-11-25execute SQL Script file
#2858BogusBug2004-11-30Query cursor lost after insert record (firbird)
#2864Wont fixReq2004-12-01Execution of multiple SQL statements with SQLite
#2865DuplicateReq2004-12-01don't use mysql_select_db on each action
#2883ClosedBug2004-12-03no numRows or rowsAffected after SELECT ... INTO OUTFILE (mysql)
#2907BogusBug2004-12-06DB_FETCHMODE_ASSOC not working with mssql
#2926Wont fixBug2004-12-08Where clause not being added in buildManipSQL
#2941Wont fixReq2004-12-10No Timeout on DB Connection !
#2960ClosedBug2004-12-13mysqli->connect fails due to unspecified socket/port
#2967Wont fixReq2004-12-14auto-increment tables: all in one table?
#2982BogusReq2004-12-16No support for MySQL 4.1 Password Hashing
#2988ClosedBug2004-12-18"property of non-object" notice when passing table name to tableInfo()
#3016BogusBug2004-12-22Bug in DB_pgsql::fetchInto when using a row number
#3021ClosedReq2004-12-23have quoteSmart() convert floats to strings
#3078BogusBug2005-01-02DB problem with CLI php
#3081Wont fixBug2005-01-03unescaped ! don't work even though enclosed in ''
#3083BogusBug2005-01-03Sybase Module Produces Notices on Free Result
#3090ClosedReq2005-01-04Syntax error in example
#3115DuplicateBug2005-01-05condition failure in pgsql tableinfo() w/db_dataobject
#3153DuplicateBug2005-01-10an if return always true because PHP5
#3177ClosedReq2005-01-12Documentation on limitQuery
#3228ClosedReq2005-01-18need to be able to supply connect_timeout to pgsql::connect
#3241ClosedReq2005-01-19Oracle fetch: too long with default prefetch parameter (1)
#3278BogusBug2005-01-24DB::parseDSN bug
#3299BogusBug2005-01-26Update/Insert on mssql gives false Error
#3321ClosedReq2005-01-28db transaction documentation
#3347ClosedBug2005-02-01ifx, numRows bug
#3413BogusBug2005-02-09Pear DB/ibase.php crash with SIGSEGV after query
#3454Wont fixReq2005-02-13RAIDb style support on database
#3460BogusBug2005-02-14function tableInfo() in DB.php
#3483BogusBug2005-02-15DB_FETCHMODE_ASSOC and CaseSensitiveField
#3500ClosedBug2005-02-17DB->getOne and DB->getRow error executing query with params on Firebird 1.5.1
#3512BogusBug2005-02-17if getCol receives $params, but no $col, an error is returned
#3583ClosedReq2005-02-24pgsql please add more errors in errorCode()
#3594ClosedBug2005-02-25createTables.php doesn't work for PostgreSQL backend with DB 1.7.0RC1
#3595ClosedReq2005-02-25Get list of views in PostgreSQL wrong
#3632DuplicateBug2005-02-27DB 1.7.0RC1 breaks DB_DataObject 1.7.2's createTables.php
#3659No FeedbackBug2005-03-01Bugs pear-DB with mssql on FreeBSD-ports
#3663ClosedBug2005-03-01getOne/getRow optimization causes query error
#3666ClosedBug2005-03-02getOne/getRow optimization causes query error
#3680ClosedBug2005-03-03getOne throws error
#3691ClosedBug2005-03-03mssql: tableInfo - no propertys for flags
#3704Wont fixReq2005-03-04IBASE_TEXT and IBASE_UNIXTIME flags in fetch functions
#3705ClosedBug2005-03-04Request # 1771 breaks SHOW queries
#3732No FeedbackBug2005-03-07enumField problem
#3735BogusBug2005-03-07sybase doesn't work with createTables.php from DB_DataObjects
#3748BogusBug2005-03-08postgres password does not escape spaces.
#3759ClosedBug2005-03-09Array DSN not converted to string in PEAR::ERROR user info
#3794BogusBug2005-03-12DB::connect() fails to throw error
#3809Wont fixReq2005-03-14counter for queries
#3823BogusBug2005-03-15No check for PHP <4.2.0 for $dsn['new_link']
#3833DuplicateBug2005-03-15Supplied parameter misclassified in mysql.php
#3841BogusBug2005-03-16Statement Prepare function too greedy
#3850BogusBug2005-03-16DB/oci8.php line 128
#3895ClosedBug2005-03-21DB::isManip issues
#3906BogusReq2005-03-21get*() should return an empty array instead of NULL
#3934BogusBug2005-03-23function tableInfo in DB_ibase class return error
#3954ClosedBug2005-03-24DB_Common::buildManipSQL() does not return error object
#3993ClosedBug2005-03-29parameter new_link isn't a valid parameter for mysql_pconnect
#4006BogusBug2005-03-30DB error says no database selected when the DB connection is closed
#4023BogusBug2005-03-31Error because of pear DB
#4024BogusBug2005-04-01Cannot use object of type DB_Error as array
#4052Wont fixBug2005-04-04DB_mysqli::tableInfo() doesn't work for "special" table names
#4078BogusBug2005-04-06DB_PORTABILITY_LOWERCASE with OCI8 not working in all cases
#4094Wont fixReq2005-04-07Connect-On-Demand?
#4112ClosedBug2005-04-10pgsql simpleQuery: FETCH queries should return DB_result
#4129ClosedBug2005-04-12MSSQL fetch array
#4145Wont fixBug2005-04-14autoExecute doesn't check for $fields_values
#4185Wont fixReq2005-04-20Performances increased
#4186Wont fixBug2005-04-20Compat check in getRow() and getAll()
#4190BogusBug2005-04-20fetchInto On MSSQL In DB_FETCHMODE_ASSOC Broken
#4220Wont fixReq2005-04-25Informix 7.2 support - unified diff format
#4221Wont fixBug2005-04-25MSSQL driver fails to select database
#4226BogusBug2005-04-26DB_FETCHMODE_ORDERED, grouping and malformed query
#4253BogusBug2005-05-011
#4272ClosedReq2005-05-03tableInfo breaks in mysql.php when crossing database boundaries
#4281BogusBug2005-05-04PEAR - nextID
#4282BogusBug2005-05-05mssql & columns' names
#4319BogusBug2005-05-10Little typo in mysql(i).php
#4365ClosedBug2005-05-17Missing Field Reported as Missing Relation (pgsql)
#4388ClosedBug2005-05-19[PATCH] DB Error if calling numRows() before tableInfo() (ORACLE)
#4398Wont fixReq2005-05-21Executed queries count
#4419Wont fixReq2005-05-24DB_AUTOQUERY_REPLACE for autoPrepare and auto Execute
#4423BogusBug2005-05-25Using JOIN results in corrupt result set
#4446ClosedBug2005-05-26"unknown error" reported when database handle has been disconnected (pgsql)
#4452No FeedbackBug2005-05-27Return of query function
#4459Wont fixBug2005-05-28FETCH query does not return DB_RESULT
#4461Wont fixBug2005-05-28Suggestion for warning about incorrect use of getOne
#4467DuplicateBug2005-05-29mysql transactions don't work properly
#4500BogusBug2005-06-01php bear crash with euro
#4513BogusBug2005-06-02oci8.php line 577 str_replace wrong parameter
#4539DuplicateReq2005-06-06cannot connect to Oracle with host/database
#4588ClosedBug2005-06-14sybase connections require a database name
#4649ClosedBug2005-06-21MSSQL: numRows() returns wrong result for limitQuery()
#4706BogusBug2005-06-29DB::connect halts output
#4736Wont fixBug2005-07-04PostgreSQL function names will be changed in 4.2.0 release to confirm to curren
#4766ClosedBug2005-07-07PHP Warning
#4791Wont fixReq2005-07-11Trace and Benchmarking
#4801BogusBug2005-07-12query ,wtih one recordset
#4813ClosedBug2005-07-13MS access error using timestamp in SQL-where clause
#4855Wont fixReq2005-07-19passing value lists into query placeholders
#4856DuplicateBug2005-07-19isManip bug with 'SELECT .* INTO'
#4868BogusBug2005-07-20PHP4.4 Only variable references should be returned by reference
#4915ClosedBug2005-07-26ini_set() not allowed for security reasons
#5013Wont fixReq2005-08-05Member to retrieve last fully formed query upon error
#5204ClosedBug2005-08-25Informix driver does not support stored procedures returning values
#5241Wont fixReq2005-08-30MSSQL table info is inadequate
#5270Wont fixReq2005-09-01PEAR::DB: escaping in DSNs
#5353Wont fixBug2005-09-09suppress deprecated is_a warning in PHP5
#5406DuplicateBug2005-09-14DB_FETCHMODE_ASSOC don't works with MSSQL
#5451ClosedBug2005-09-19segment error
#5476Wont fixReq2005-09-21proposal for "texis" driver
#5519Wont fixReq2005-09-26getter for $autocommit
#5522Wont fixBug2005-09-26autoExecute() doesn't escape field names
#5563Wont fixReq2005-09-29mysql connect() on php 4.1.x
#5611Wont fixBug2005-10-05limitQuery doesn't work with $limit = -1
#5646Wont fixBug2005-10-10mssql tableInfo() needs [] for tables with reserved words as name
#5655Wont fixBug2005-10-11Sqlite: missing transactions implementation
#5657ClosedReq2005-10-11SSL-Connection fails / vartype boolean
#5673ClosedReq2005-10-12Feature req.: Last inserted ID.
#5680ClosedBug2005-10-13tableInfo() in mysqli.php
#5738No FeedbackReq2005-10-21DB.php LDAP version patch
#5762ClosedBug2005-10-24Empty getRow() result causes ocifreestatemet() error
#5795Wont fixReq2005-10-27MsAccess ODBC directly to file
#5796ClosedBug2005-10-27Add Schema support to _pgFieldFlags in pgsql driver
#5855Wont fixBug2005-11-03Missing parameter for OCILOGON()/OCIPLOGON() in oci8.php
#5926BogusReq2005-11-10portability for boolean data types
#5982ClosedBug2005-11-16No connection with PostgreSQL via sockets and non default port
#6015Wont fixBug2005-11-19Syntax error, DB.php on line 470
#6043BogusBug2005-11-23query
#6060BogusReq2005-11-24add a quoteIdentifier method in Oci8 driver
#6091BogusBug2005-11-27sqlite_escape_string
#6125Wont fixReq2005-12-01Query logger
#6131DuplicateBug2005-12-02pgsql - simpleQuery - isManip Bug
#6143BogusBug2005-12-04DB::autoExecute dies without error.
#6194Wont fixReq2005-12-08function _isAlreadyQuoted and _quoteIdentificator behavior
#6315Wont fixBug2005-12-21SQL comments before query confuse isManip()
#6329Wont fixBug2005-12-22tableInfo() for postgres driver returns -1 as field length for type varchar
#6363BogusBug2005-12-28Assigning the return value of new by reference is deprecated
#6414DuplicateBug2006-01-04DB module attempts to guess which statements modify the database, incorrectly
#6477ClosedBug2006-01-12Broken types array in mysqli extension
#6571DuplicateBug2006-01-24Thinks a decimal(10,2) is unknown(11) not_null unsigned
#6583Wont fixReq2006-01-25Rearrange function paramenters of fetchInto and fetchRow
#6658BogusBug2006-02-01bytea data insertion doesont work for me
#6668BogusBug1.7.62006-02-02Error handling of Pear::DB (DB_Error)
#6679Wont fixBug1.7.62006-02-03when object is defined connection to DB gives error
#6683ClosedBug1.7.62006-02-03createTables.php - sybase - FatalError
#6693Wont fixBug1.7.62006-02-04Trouble with mysql_free_result -> "not a valid MySQL result resource"
#6710DuplicateBug1.7.62006-02-06tableInfo() always returns field length 0 when using mysqli driver
#6730BogusBug1.7.62006-02-08PEAR::DB is not compliant with PHP 5
#6795Wont fixReq2006-02-16portability problem with case and alias
#6832BogusBug1.7.62006-02-18no error messages if db name is not specified in dsn
#6897DuplicateBug1.7.62006-02-22Impossible to determine if autoCommit is on or off
#6925DuplicateBug1.7.62006-02-24cannot connect to Oracle with host/database
#6967ClosedReq1.7.62006-02-28DB_dbase freeResult does not exist.
#7068Wont fixReqCVS2006-03-09Auto Detect AutoPrepare
#7080Wont fixBug1.7.62006-03-09php complains about static function calls
#7114DuplicateBug1.8.42006-03-13Pgsql - incorrect results for schema
#7131Wont fixBug1.7.62006-03-15pgsql tableinfo return no table name
#7168Wont fixReq1.7.62006-03-20mysql_fetch* returns only strings - compatibility option
#7194Wont fixBug1.7.62006-03-24mysql INIT DB on every query
#7216ClosedBug1.7.62006-03-27OCI8 module ignores non-standard port
#7226DuplicateReq1.7.62006-03-28Using the oci8 with instant client couldn't connect
#7227ClosedBug1.7.62006-03-28Wrong Parameter Count
#7258DuplicateBug1.7.62006-03-30MSSQL DONT WORKS: DB_FETCHMODE_OBJECT
#7274BogusBug2006-04-01SQL query ORDER BY error in fetchRow method
#7343ClosedBugCVS2006-04-08mysql's tableInfo() broken because of wrong parameter order
#7501ClosedBug1.7.62006-04-27ORACLE: connect method for PHP4 does not consider 'database' field in $dsn var
#7502ClosedBug1.7.62006-04-27DB_result::fetchRow() that sets $rownum still increments row_counter
#7632ClosedBug1.7.62006-05-15oracle: unable to get numRows from prepared query
#7636Wont fixReq1.7.62006-05-16mysqli multi query
#7661Wont fixBug1.7.62006-05-18Unwanted notices under PHP5
#7737ClosedBug1.7.62006-05-28mysql(i) drivers quoteIdentifier() do not quote backticks
#7768BogusBug1.7.62006-05-31DSN is return in case of connection problem
#7857Wont fixReq1.7.62006-06-10Improve a little package DB (add an option for mysqli connector already present
#7911Wont fixReq1.7.62006-06-15Oracle BLOB Handling Is Missing - Patch Included
#8217ClosedBug1.7.62006-07-14AutoPrepare returns false
#8285Wont fixBug1.7.62006-07-25insert into auto_increment field with '' fails but works with null
#8307BogusReq1.7.62006-07-27Default value of seqname_format option
#8336ClosedBug1.7.62006-08-01(MS SQL) tableInfo() retuns error for table named "group"
#8404DuplicateBug1.7.62006-08-09query problem with 'into' in where clause
#8561DuplicateBug1.7.62006-08-25Call to SP with Parameter "x into y" Causes Errenoneous Result
#8642BogusBug1.7.62006-09-06postgres and some characters fails
#8671DuplicateBug1.7.62006-09-10Postgre:"select * into temp TABLE" is query SQL
#8719ClosedBug1.7.62006-09-17ORACLE 10: can't connect to db
#8918BogusBug1.7.62006-10-09portability layer does not work
#9096ClosedBug1.7.62006-10-19mssql_fetch_array() returns null in fetchInto()
#9381BogusBug1.7.62006-11-19Can not use gettext with tr_TR locale
#9512BogusBugCVS2006-11-30Database connection failure with length over 30 char
#9599ClosedBug1.7.62006-12-12Error mapping broken since 5.2.0
#9626BogusBug1.7.62006-12-15Errors in files: DB.php, common.php, sybase.php
#9709ClosedBugCVS2006-12-29tests/driver/16tableinfo.phpt fails against MySQL 5
#9859BogusBug1.7.72007-01-17Empty strings are treated as booleans
#9869ClosedBug1.7.8RC12007-01-18SQL Command doesn't work
#9995Wont fixBug1.7.82007-01-31DB_mysql::tableInfo() should quote identifier for table name
#10135BogusBug1.7.92007-02-20Compilation Error
#10211ClosedBug1.7.92007-02-27MySQL v5.x 'bit' fields not recognized
#10473ClosedBug1.7.102007-03-23With fbsql, when calling commit or rollback, the connection is not passed-on
#10611Wont fixReq1.7.112007-04-04make modifyLimitQuery() public so it can be used with convenience methods
#10772Wont fixBug1.7.112007-04-18full-text NOISE WORDS
#10813BogusBug1.7.112007-04-23Process forking destroys PEAR::DB connections in an unexpected manner
#10894ClosedBug1.7.112007-04-30Problem running tests
#11080ClosedReq2007-05-19getListOf('schema.views')
#11107Wont fixReq1.7.112007-05-23Include a 'mock' database driver for unit testing
#11110ClosedReq2007-05-23Feature: Oracle / oci8 ->getListOf(views)
#11111BogusBug1.7.112007-05-23Informix connection error
#11125ClosedBug1.7.112007-05-24wrong pg_escape_string() call
#11364Wont fixReq1.7.112007-06-19finding out current sequence value
#11377Wont fixBug1.7.112007-06-20DB::isManip wrongly classifies some queries
#11577BogusBug1.7.122007-07-10Errors while making "big" queries
#11580ClosedBug1.7.122007-07-10DB_mysql::tableInfo() bug when using several connections
#11581ClosedReq1.7.122007-07-11Avoid some strict warnings
#11609Wont fixBug1.7.122007-07-16Identifier in DB::nextId() needs to be quoted
#11716ClosedBug1.7.122007-07-31SQLite returns result field names with quotes
#11828Wont fixReqCVS2007-08-13add setCharset($charset) method
#11907BogusBug1.7.122007-08-24query() generates unknown error in a Stored Procedure call
#11993Wont fixBug1.7.122007-09-06ifx: cannot execute select on TEXT_FIELD
#12057BogusDoc1.7.122007-09-15Non-static method DB::isError() should not be called static
#12067Wont fixBug1.7.122007-09-18DB_oci8::connect ignores hostspec
#12105ClosedBug1.7.132007-09-24Extra error message for field not found
#12173BogusBug1.7.132007-10-02Wrong evaluation for placeholders
#12188BogusBug1.7.132007-10-05Prepare Method Returns "int(0)" or "int(1)" Instead of Handle With Postgres
#12260ClosedBug1.7.132007-10-16autoCommit(FALSE) does not begin a new transaction block
#12418ClosedBug1.7.132007-11-10OCI8 Generates Invalid last_query For Executed Query
#12546No FeedbackBug1.7.132007-11-29pgsql commit() doesn't commit in non-autocommit mode
#12673Wont fixBug1.7.132007-12-12Return error when execute statement INSERT INTO [TABLE1] SELECT FROM [TABLE2]
#13193ClosedReq1.7.132008-02-25'auto_increment' feature in tableInfo() for sqlite
#13366Wont fixBug1.7.132008-03-10nextId does not correctly handle $ondemand parameter with PostgreSQL 8.2
#13537No FeedbackBug1.7.132008-03-30limitQuery always returns the same result set
#13574BogusBug2008-04-03Object of class DB_result could not be converted to string
#13632ClosedDoc1.7.14RC12008-04-09list comparison of get() method results
#13676BogusBug2008-04-14db2connection from PHP
#14271ClosedBug1.7.14RC12008-07-01oci8: freePrepared() does not free _prepared_queries array
#14603ClosedBug1.7.132008-09-05Wrong replace in last_query
#14884ClosedBugCVS2008-10-26Tests should skip if no configuration is available
#15115ClosedBug1.7.14RC12008-11-21__wakeup passes the wrong params to connect
#15142BogusBug1.7.132008-11-24Commands out of sync , without reason!
#15481No FeedbackBug1.7.132009-01-01float values are quoted
#16117ClosedBug1.7.132009-04-17MSSQL escape doesn't take into account trailing backslashes
#16621BogusBug1.7.14RC12009-09-16query() with placeholders messes up in sqlite driver
#16859Wont fixBugUnknown2009-12-01DB_mysql::quote() should be compatible with that of DB_common::quote()
#16881BogusReq1.7.14RC12009-12-07getter-Method for connection resource
#16893Wont fixReq1.7.14RC12009-12-08Native SQL Server Driver
#17136ClosedBug1.7.132010-02-19PostgreSQL Recursive SQL (or simply WITH Query) doesn't work properly
#17272BogusBugSVN2010-03-26mysql_connect()
#17384No FeedbackBug1.7.132010-05-10limitQuery in DB2 always returns first row
#17511Wont fixBug1.7.132010-06-22Missing connect parameters for Ibase
#17587BogusBug1.7.14RC12010-07-14can't locate DB
#17642DuplicateBugUnknown2010-07-30error - Assigning the return value of new by reference
#17722ClosedBugSVN2010-08-17patch: Using PCRE functions
#18506Wont fixBugUnknown2011-05-05DB executes does not process oracle in clause
#18923BogusBug1.7.142011-10-22fetchRow() leaks like a sieve.
#19187FeedbackReq1.7.142012-01-04add DB_PORTABILITY_BOOLEAN for postgres
#19296Wont fixReq1.7.142012-02-17Grant access
#19544BogusBug1.7.142012-08-04Failing tests with PHP 5.4
#19639Wont fixReq1.7.142012-10-07Get list of views from mysql
#19641Wont fixBug1.7.142012-10-07Pgsql-driver uses rawurlencode() in tableInfo()
#19674SpamBugUnknown2012-10-24db
#19785ClosedBug1.7.142013-01-15mysqli quote() security flaw
#19794OpenBugUnknown2013-01-22Can not use the literal "select" in text field
#20078No FeedbackBug1.7.142013-10-01DB_mysqli::tableInfo(..) doesn't work.
#20209BogusBugUnknown2014-03-03SHA256 auth plugin mysqlnd
#20210DuplicateBugUnknown2014-03-03SHA256 auth plugin mysqlnd
#20447ClosedBug1.8.12014-11-26Recent quoteString() change has broken many apps
#20975FeedbackBug1.8.22015-10-28Unable to execute another query after calling a MySQL Stored Procedure
#21037BogusBug1.9.22016-03-04DML operation not working for tables that have InnoDB storage engine
#21146DuplicateBug1.9.22016-11-07ERROR FOR PHP 7
#21217AssignedBug1.9.22017-06-02autoExecute failed UPDATE if placeholders presents in WHERE
#21228ClosedBug1.9.22017-07-10count used on a string value
#21256FeedbackBug1.9.22017-11-08Error PHP 7.0.23 connect function to mysql
#23733BogusBug1.9.22018-01-04escapeSimple has incomplete return type documentation
#23784OpenBug1.9.32018-12-21The getRow method with placeholder causes PHP warning and doesn't return data
#23785ClosedBug1.9.32018-12-21The getRow method with placeholder occurs PHP warning and does not return corre