Comments (4)
I have the same issue using postgre driver... please fix this one this a major bug !
from codeigniter.
Tim, thanks for addressing this issue. I think it might need some tweaking, or I am not implementing correctly. Using the above query as an example.
$this->db->join('tasks', 'projects.id = tasks.project_id AND tasks.deleted=0', 'left')
will create a query string like
LEFT JOIN `tasks` ON `projects`.`id` = `tasks`.`project_id` AND `tasks`.`deleted`=`0`
Protecting 0 causes a MySQL error. I'm not even sure if this type of case should be automatically handled in the join method. I would of course like it to be, but it might break some other case. For now, I'm just protecting identifiers long hand in the active record query itself, kind of like this post.
http://codeigniter.com/forums/viewthread/119846/#737096
from codeigniter.
This issue is related to #758 and if properly fixed may replace the solution given on #759.
Line 331 should match breaklines and tabs too.
from codeigniter.
This is being handled in #759.
from codeigniter.
Related Issues (20)
- PHP 8.2 - Optional parameter declared before required parameter HOT 1
- Is Codeigniter version 3.1.10 is support for php 8.0 or php 8.1 ? HOT 13
- Deprecated Deprecations of Expected Exceptions HOT 1
- CodeIgniter + Session usage with Redis is slow HOT 4
- mysqli_driver version_compare issue CI 3.1.13
- Controller classes must exist as files (why??)
- Drop support for PHP < 8.1 HOT 10
- Crazy error, php-api/system/database/DB_driver.php --------> function escape($str) error HOT 4
- Email library does not send email through SMTP on PHP 8.2
- Upcoming deprecations in PHP 8.3 HOT 2
- Codeigniter 3.1.4 and PHP 8.1 HOT 4
- mysqli num_rows always return 0 HOT 1
- Session Lost for CI 3.1.13 on Page Refresh HOT 4
- Misleading docblock of the file_get_info function
- xss_clean % error HOT 1
- Bug: inconsistent behavior of Query Builder limit 0 HOT 8
- bug: codeigniter3 db->or_where_not_in(...) HOT 1
- Are there plans for CodeIgniter 3.1.14? HOT 2
- XSS when data is passed on to the web application via an API HOT 3
- only laravel HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from codeigniter.