Issue with get_where and where methods in query builder.

I just "answered" a Stack Overflow question that seems to point out a bug in get_where and where methods in the query builder:

https://stackoverflow.com/questions/48507219

This is using the current version of CodeIgniter, 3.1.7.

Basically, if a string is used as the where condition that contains " and x between x and ", then the query builder is inserting a bunch of backticks.

The query bindings feature doesn't have this problem.

I don't have a good enough understanding of the DB classes to help fix this, or know if it can be fixed.

Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3

That's what happens when we try to make everybody happy ...

https://github.com/bcit-ci/CodeIgniter/c...79117bda42

I'm hoping this is the 1% case where a fix to the QB doesn't cause another bug.

That's what happens when we try to make everybody happy ...

https://github.com/bcit-ci/CodeIgniter/c...79117bda42

I'm hoping this is the 1% case where a fix to the QB doesn't cause another bug.

I was a little worried about that. Seems like it would be super rare that somebody would build up a query like that. Fingers crossed!

Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3

Hope died pretty quickly on this one: https://github.com/bcit-ci/CodeIgniter/issues/5448