summaryrefslogtreecommitdiff
path: root/adodb.inc.php
AgeCommit message (Collapse)AuthorFilesLines
2025-11-22autoExecute return false on update with no matchDamien Regad1-2/+3
If the specified where clause returns no rows, then we return false early, there is no point building and executing an UPDATE statement that will do nothing. Fixes #1148
2025-11-22autoExecute: always use DB_AUTOQUERY_* constantsDamien Regad1-13/+20
2025-11-22Fix autoExecute() skipping updatesDiogo Galvão1-3/+4
AutoExecute fetches a row from the table prior to performing an insert or update. When $forceUpdate is false, only modified columns should be updated. However, the WHERE clause was not being used when fetching the row, so the comparison was always made against an arbitrary row, causing differences to be detected or missed by chance. This change makes use of the $where parameter when fetching the row from the table, making the comparison work as intended. Fixes #1146
2025-10-25PHP 8.5: fix Non-canonical cast deprecationsDamien Regad1-3/+3
Non-canonical cast (integer) is deprecated, use the (int) cast instead Global search and replace throughout the code base. Fixes #1143
2025-08-03Bump version to 5.22.10v5.22.10Damien Regad1-1/+1
2025-05-01Bump version to 5.22.9v5.22.9Damien Regad1-1/+1
2025-03-22Bump version to 5.22.9-devDamien Regad1-1/+1
2025-01-25Bump version to 5.22.8v5.22.8Damien Regad1-1/+1
2024-03-22Fix getAssoc() with ADODB_FETCH_DEFAULT modeDamien Regad1-3/+5
With mysqli (and possibly with other drivers where driver-specific fetchMode values are different from ADOdb's as well, but this has not been tested), getAssoc() would not return the expected key=>value pairs when fetch mode was set to ADODB_FETCH_DEFAULT. We now use ADORecordSet::$adodbFetchMode property as reference fetch mode instead of the driver-specific ADOConnection::$fetchMode (which is often not set), and check it against both ADODB_FETCH_BOTH and ADODB_FETCH_DEFAULT. Fixes #1023
2024-01-10Bump version to 5.22.8-devDamien Regad1-1/+1
2023-11-04Bump version to 5.22.7v5.22.7Damien Regad1-1/+1
2023-06-12Bump version to 5.22.7-devDamien Regad1-1/+1
2023-06-11Bump version to 5.22.6v5.22.6Damien Regad1-1/+1
2023-06-11Set AllowDynamicProperties attribute on ADOFetchObj classhschletz1-0/+1
Avoid deprecation warning on PHP 8.2. Fixes #975, as temporary workaround for #982 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2023-04-30Define ADOConnection::_query() methodDamien Regad1-0/+12
- Update child classes to be consistent with this declaration. - Remove unnecessary, non-PHPDoc comments - Consistent parameter names Fixes #966
2023-04-30PHPDoc: fix ADOConnection::execute() return typeDamien Regad1-1/+1
Remove redundant PHPDoc block in child classes ADODB_mysqli, ADODB_oci8. Fixes #964
2023-04-15Add missing AODRecordSet::$rowsPerPage declarationDamien Regad1-1/+2
Fixes #954
2023-04-15PHPDocDamien Regad1-14/+23
2023-04-15Bump version to 5.22.6-devDamien Regad1-1/+1
2023-04-03Bump version to 5.22.5v5.22.5Damien Regad1-1/+1
2023-03-17PHPDocDamien Regad1-3/+15
2023-03-17Remove safe mode referencesDamien Regad1-6/+3
safe_mode was deprecated in PHP 5.3 and removed in 5.4. This removes remaining references to it in the code. Fixes #934
2023-03-17Fix PHP 8.2 dynamic properties deprecation warningsDamien Regad1-1/+40
- ADOConnection: add $_metars, $locale, $metaColumnsSQL, $identitySQL, $_genSeqSQL, $_dropSeqSQL and $_genIDSQL; add PHPDoc to $metaDatabasesSQL $metaTablesSQL - Exceptions: add $msg property - DB2: reference parent connection object and fix $_queryID case - Informix: don't cache version info in SetVersion - odbtp: define $odbc_name, $_canSelectDb, $_lastAffectedRows properties NOTE: this is somewhat academical as the driver is obsolete - oci8: define $_refcursor property - sybase: use existing $hasTransactions property instead of $_hastrans - text: rename unused ADOConnection::$_evalAll property to $evalAll - perf: define $settings property - xml: add properties dbTable::$currentPlatform, dbTable::$data, dbData::$current_field, adoSchema:$obj This is adapted from changes proposed in #926
2023-03-17Define ADOConnection::$connectStmtDamien Regad1-0/+4
Adapt the few drivers that were previously using this property. Fixes dynamic properties deprecation in PHP 8.2 Based on original submission in PR #926
2023-03-12Allow dynamic properties for ADOFieldObject classDamien Regad1-1/+5
Fixes #906
2023-03-12PHPDoc add variable type hintDamien Regad1-0/+1
Signed-off-by: Damien Regad <dregad@mantisbt.org>
2023-03-12Define ADORecordSet::$insertSigDamien Regad1-0/+2
Fixes PHP 8.2 Deprecated warning: Creation of dynamic property. Fixes #908 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2023-03-12Define ADORecordSet::$tableNameDamien Regad1-0/+6
Fixes PHP 8.2 Deprecated warning: Creation of dynamic property. Fixes #909 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2023-03-12Fix PHP 8.2 deprecation warnings + PHPDoc fixesDamien Regad1-0/+6
Cherry picked from commits feadc3df1fdb199bbef50eb404f81b7d78f94c79 and 5e41924806e5f310d30e203100f0c97cd5e93893. # Conflicts: # adodb.inc.php Creation of dynamic property - ADORecordset_sqlite3::$adodbFetchMode in adodb-sqlite3.inc.php (#911) - ADOFieldObject::$scale in adodb-sqlite3.inc.php (#912) Partially-supported callable - in adodb-pdo-inc.php (#928)
2023-03-12Remove deprecated $databaseName propertyDamien Regad1-1/+8
ADOConnection::$databaseName was marked as obsolete in ADOdb 4.66. Since the assignment that was kept for backwards-compatibility in the ADOConnection::selectDB() method is causing deprecation warnings with PHP 8.2, now is the time to get rid of it. The 2018 rewrite of DB2 driver introduced a private $databaseName property; this has been removed in favor of ADOConnection::$database. Fixes #932, #904 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2023-01-17Improve autoExecute() PHPDoc, fix $where param typeDamien Regad1-18/+16
$where was wrongly typed as bool. Changed it to string and updated the default value from false to ''. Fixes #915
2022-11-23Bump version to 5.22.5-devDamien Regad1-1/+1
2022-11-23ADODB_FETCH_DEFAULT should be treated as ASSOCMark Newnham1-3/+1
Ensures that the recordset is returned in the default provided by the PHP driver as per the documentation. Fixes #886
2022-10-28Bump version to 5.22.4v5.22.4Damien Regad1-1/+1
2022-09-08Fix mysqli_result could not be converted to intDamien Regad1-3/+1
Partial revert of 721c31492ac77aa1bd9bdd01193cd6071087b49f. This was an early attempt to fix #848; the actual fix was implemented in the PostgreSQL driver, but the change to ADORecordSet::__destruct() was not reverted. Fixes #867
2022-09-08Bump version to 5.22.4-devDamien Regad1-1/+1
2022-09-06Bump version to 5.22.3v5.22.3Damien Regad1-1/+1
2022-09-03Fix backtrace printed twice in debug mode 99Damien Regad1-3/+0
See https://github.com/ADOdb/ADOdb/pull/856#discussion_r953591183
2022-08-26New class constant ADORecordSet::DUMMY_QUERY_IDDamien Regad1-3/+13
Replace hardcoded '-1' value when creating dummy RecordSets. Issue #848
2022-05-09Bump version to 5.22.3-devDamien Regad1-1/+1
2022-05-08Bump version to 5.22.2v5.22.2Damien Regad1-1/+1
2022-04-03Bump version to 5.22.2-devDamien Regad1-1/+1
2022-03-30Bump version to 5.22.1v5.22.1Damien Regad1-1/+1
2022-03-30Improve PHPDoc for memcache properties in ADOConnectionDamien Regad1-15/+24
2022-03-20PHPDocDamien Regad1-0/+2
2022-02-20Remove mysql, mysqlpo and mysqlt driversDamien Regad1-6/+2
These legacy drivers are all based on the old mysql extension, which was deprecated in PHP 5.5 and removed in PHP 7.0. Fixes #804
2022-02-08Bump version to 5.22.0v5.22.0Damien Regad1-1/+1
2022-01-16Add ADOConnection::releaseStatement() methodDamien Regad1-0/+11
This allows Oracle users to avoid reaching the maximum open cursors limit by releasing the statement resource allocated by oci_parse(), and prevent occurrence of an ORA-01000 error. The resource is cleared (set to null) after freeing statement, to avoid keeping a resource of type Unknown in the statement. Fixes #770
2022-01-08No need to define $dsnType in ADODB_pdo anymoreDamien Regad1-3/+3
It is declared in ADOConnection since e3fa991cab89ceb9724bf8c19676a450ee62a1f8. Convert ADOConnection::$dsnType comment to PHPDoc. Issue #789
2022-01-08PHPDoc updateDamien Regad1-6/+6