summaryrefslogtreecommitdiff
path: root/adodb-lib.inc.php
AgeCommit message (Collapse)AuthorFilesLines
2015-11-28Bump version to 5.20.0v5.20.0Damien Regad1-1/+1
2015-11-26Adjust header comment blocksDamien Regad1-1/+3
- running SED script - manual adjustments for files not processed by regex
2015-08-12Coding guidelines, wrap long linesDamien Regad1-19/+39
2015-08-12Query pagination optimizationmike.benoit1-25/+45
Optimize query pagination when row counting is disabled. Rather than issue 3+ separate queries, it simply uses just one in most cases, resulting in huge performance increases especially on large tables. Fixes #110 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2015-04-20Add support for pagination with complex queriesMike Benoit1-2/+5
There are cases where ADODB is not be able to figure out the proper count(*) queries for PageExecute() on its own. To work around this problem, ADOdb now handles a new keyword "_ADODB_COUNT" that can be wrapped around the parts of the SQL query that should be replaced with "COUNT(*)"; the code will remove everything between and including the _ADODB_COUNT keywords and replace it with COUNT(*). The _ADODB_COUNT tags are of course removed when COUNT(*) is not needed. Example usage: SELECT _ADODB_COUNT col1, col2, col3, ( select col4 from table2 where col1=col2 ) col4, _ADODB_COUNT FROM table1 LEFT JOIN ( select col5 from table3 where col3=col4 ) AS tmp; Original 2012 bug report: http://phplens.com/lens/lensforum/msgs.php?id=19058 The fix has been in use since that time in hundreds of thousands of production installations. Fixes #88 Signed-off-by: Damien Regad <dregad@mantisbt.org>
2014-09-09Fix adodb_strip_order_by() for subqueries with order/limitMikeB1-2/+2
The original regex was causing sub-query with ORDER BY and LIMIT clauses to be stripped out, resulting in multiple rows being returned and causing a SQL error. Example queries that were failing: * SELECT name, ( SELECT id FROM tmp_table LIMIT 1 ) FROM table; * SELECT id FROM ( SELECT id FROM tmp_table LIMIT 1 ) AS table; Signed-off-by: Damien Regad <dregad@mantisbt.org>
2014-08-07Convert files from ISO-8859-1 encoding to UTF-8Damien Regad1-1/+1
Fixes #32
2014-04-30Bump version to 5.20devDamien Regad1-1/+1
2014-04-23Bump version to 5.19v5.19Damien Regad1-1/+1
2014-02-24Remove closing php tagDamien Regad1-2/+0
http://php.net/manual/en/language.basic-syntax.phptags.php
2014-02-24Remove obsolete commentDamien Regad1-2/+0
2014-02-24adodb-lib: Fix columns quoting bugDamien Regad1-3/+3
See https://sourceforge.net/p/adodb/bugs/127/
2014-01-21Fix 'LIMIT 1' clause in subquery gets stripped offDamien Regad1-5/+6
Implementing the patch submitted by Mike in http://phplens.com/lens/lensforum/msgs.php?id=17813
2014-01-21Bump version to 5.19devDamien Regad1-1/+1
Bumped 'dev' version allows users who rely on source code downloaded from the git repository rather than an official release tarball to reliably determine that they are running a development version of the library.
2013-08-05Reorg: ADOdb5 (master) branchDamien Regad1-0/+1209
- Move all files in adodb5/ to root - Remove adodb-for-php4/ directory