summaryrefslogtreecommitdiffstats
path: root/system/database/DB_query_builder.php
AgeCommit message (Collapse)AuthorFilesLines
2022-07-24fixes #6149László Bóra1-3/+3
remove deprecated variable variables / string interpolation in variable names
2022-03-03Merge branch '3.1-stable' into developAndrey Andreev1-1/+2
2022-03-02[ci skip] Update copyright noticesAndrey Andreev1-1/+2
2021-01-05[ci skip] Close #5973Andrey Andreev1-1/+1
2021-01-05[ci skip] Close #5973Andrey Andreev1-1/+1
2020-07-09[ci skip] Merge pull request #5970 from sapics/fix/user-guide-urlAndrey Andreev1-1/+1
Fix user guide url
2020-06-24Fix user guide urlsapics1-1/+1
Replace from https://codeigniter.com/user_guide/* to https://codeigniter.com/userguide3/*
2020-01-27[ci skip] Merge pull request #5881 from InSitu-Software/query_builder_full_joinAndrey Andreev1-1/+1
Added FULL OUTER JOIN to QueryBuilder
2020-01-02Added FULL [OUTER] JOIN to CI_DB_query_builderChristian Mohr1-1/+1
2019-09-22Merge pull request #5834 from najdanovicivan/qb-count-having-fixAndrey Andreev1-1/+1
Fix count_all_result if QB query contains HAVING clause
2019-09-13Fix count_all_result if QB query contains HavingNajdanovic Ivan1-1/+1
Signed-off-by: Najdanovic Ivan <najdanovicivan@gmail.com>
2019-02-14[ci skip] More on #4186Andrey Andreev1-2/+7
2019-02-14Close #4186, #5631, #5668Andrey Andreev1-15/+10
2019-01-02Merge pull request #5662 from jim-parry/copyright2019Instructor, BCIT1-3/+3
Update copyright date to 2019
2018-12-27Update copyright date to 2019Jim Parry1-2/+2
2018-05-18http:// to https://Mehdi Bounya1-2/+2
2018-04-24Merge branch '3.1-stable' into developAndrey Andreev1-1/+1
2018-04-23[ci skip] Merge pull request #5471 from toonitw/patch-1Andrey Andreev1-2/+2
The value of limit can be zero
2018-04-23[ci skip] Merge pull request #5471 from toonitw/patch-1Andrey Andreev1-2/+2
The value of limit can be zero
2018-04-18Remove the extra parenthesesJehong Ahn1-1/+1
2018-04-14Merge pull request #5464 from ytetsuro/fix/#5462/like-before-bugAndrey Andreev1-1/+1
Fixed issue #5462 Query Builder LIKE BEFORE doesnt work
2018-04-13Fix #5448Andrey Andreev1-1/+1
2018-04-12qb_limit can be zeroJehong Ahn1-2/+2
2018-04-03fix: It does not work properly when like is beforeytetsuro1-1/+1
2018-03-22Merge branch '3.1-stable' into developAndrey Andreev1-23/+28
Conflicts resolved: system/core/CodeIgniter.php system/core/Security.php system/database/DB_query_builder.php system/libraries/Email.php user_guide_src/source/changelog.rst user_guide_src/source/conf.py user_guide_src/source/installation/downloads.rst user_guide_src/source/installation/upgrading.rst
2018-01-30Fix a QB bug where where(), having() treated values passed to them as ↵Andrey Andreev1-23/+28
arbitrary SQL
2018-01-09[ci skip] Merge pull request #5376 from jim-parry/copyright-updateAndrey Andreev1-2/+2
Annual copyright update Conflicts resolved: system/libraries/Cache/drivers/Cache_apcu.php
2018-01-09Annual copyright updateMaster Yoda1-2/+2
2017-10-16Merge branch '3.1-stable' into developAndrey Andreev1-1/+1
2017-10-03Update DB_query_builder.phppgee701-1/+1
recent changes broke query ordering giving a warning in line 1238 = '$this->qb_cache_orderby = array_merge($this->qb_cache_orderby, $qb_orderby);' this was because on subsequent re-queries, the qb_cache_orderby was set to NULL not Array() as it is should be (and is instantiated originally .
2017-09-25Merge branch '3.1-stable' into developAndrey Andreev1-8/+6
2017-08-29Optimize the join() type regexp and remove the extra leading space when no ↵Andrey Andreev1-3/+3
special join-type is used
2017-08-29Polish changes from & add changelog entry for PR #5242Andrey Andreev1-29/+8
Also, further simplified the join() logic
2017-08-29remove unnecessary empty linesShang Ning1-2/+0
2017-08-29add NATURAL JOIN types to fix #5240Shang Ning1-4/+20
2017-07-10[ci skip] Fix #5178 (regression caused by #5168)Andrey Andreev1-1/+1
2017-07-03[ci skip] Fix #5168Andrey Andreev1-8/+6
2017-06-15Merge pull request #5155 from tianhe1986/develop_count_ignore_limitAndrey Andreev1-1/+1
Fix CI_DB_query_builder::count_all_results() returning wrong count with LIMIT/OFFSET
2017-06-15Getting right num of rows with LIMIT usage.tianhe19861-1/+1
Signed-off-by: tianhe1986 <w1s2j3229@163.com>
2017-06-15Revert "Ignore LIMIT when using CI_DB_query_builder::count_all_results"tianhe19861-21/+3
This reverts commit 9f6da3c2f11535fee09dd306ae6b884168e4623b. Signed-off-by: tianhe1986 <w1s2j3229@163.com>
2017-06-15Ignore LIMIT when using CI_DB_query_builder::count_all_resultstianhe19861-3/+21
Signed-off-by: tianhe1986 <w1s2j3229@163.com>
2017-03-24Merge branch '3.1-stable' into developAndrey Andreev1-13/+14
Conflicts resolved: system/core/CodeIgniter.php system/core/Common.php system/core/Input.php system/helpers/cookie_helper.php tests/codeigniter/helpers/html_helper_test.php user_guide_src/source/changelog.rst user_guide_src/source/conf.py user_guide_src/source/installation/downloads.rst user_guide_src/source/installation/upgrading.rst user_guide_src/source/libraries/input.rst
2017-02-13Adding having_in(), or_having_in(), having_not_in() and or_having_not_in().tianhe19861-0/+72
Signed-off-by: tianhe1986 <w1s2j3229@163.com>
2017-02-13Using _wh_in() instead of _where_in().tianhe19861-15/+22
Signed-off-by: tianhe1986 <w1s2j3229@163.com>
2017-01-17Merge pull request #4987 from tianhe1986/develop_qb_alias_table_cacheAndrey Andreev1-9/+15
Add aliased tables cache in query_builder.
2017-01-17Merge pull request #4987 from tianhe1986/develop_qb_alias_table_cacheAndrey Andreev1-9/+15
Add aliased tables cache in query_builder.
2017-01-17Format fix。tianhe19861-2/+2
Signed-off-by: tianhe1986 <w1s2j3229@163.com>
2017-01-171 Keep just 'list'.tianhe19861-13/+13
2 Using strict mode with in_array(). 3 Do not re-align. Signed-off-by: tianhe1986 <w1s2j3229@163.com>
2017-01-17[ci skip] Merge pull request #4986 from ka7/feature/spellingAndrey Andreev1-2/+2
Spelling fixes in comment blocks and docs
2017-01-17Address #4980Andrey Andreev1-13/+14