⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Flexigrid no result search with uppercase in a word



Milfriosc

Milfriosc
  • profile picture
  • Member

Posted 29 July 2016 - 09:13 AM

Hello,

 

I'm french (thank's google traduction and sorry for my poor language) and newbie ... so this is my question :

I use the theme flexigrid but when i search "sport" there is no result because this word has a uppercase ("Sport")  in my database.

Have you a idea to solve this problem ?

 

Thank's a lot


Amit Shah

Amit Shah
  • profile picture
  • Member

Posted 01 August 2016 - 06:05 AM

Hi Milfriosc,

 

There is a hax around the same. What you can do is just replace $_REQUEST['keyword'] = strtolower($_REQUEST['keyword']) 

 

i just gave the example - this might not be correct.. variable .. but clears the concept

Also dont do it blindly.. understand when u need to do it..!! so it wont give error... .probably - check if the parameter exists .. if it dose - change it ... !


Milfriosc

Milfriosc
  • profile picture
  • Member

Posted 03 August 2016 - 09:15 AM

Hi Amit Shah,

 

I use postgresql with this files http://www.geotests.net/blog/article/grocerycrud-developper-rapidement-une-application-web-en-php

After some tests, i've to change the function "protected function _like" of DB_query_builder.php : replace (4x) the LIKE by ILIKE the case insensitive variant for postgres and it's OK  :)

 

thank's for your help


matteo94s

matteo94s
  • profile picture
  • Member

Posted 25 October 2018 - 12:59 PM

Hi! i can't get the postgresql files..... however ILIKE doesn't work