i'm using groceryCRUD with postgresql and it works fine for me but if i search something with the exact same character as the word i have to search, it works(key sensitive search). if i perform a key insensitive search it doesn't work. i tried to replace LIKE with ILIKE , which in postgresql stand for key insensitive search, and it works with some fields (like name and surname) but it throws error 500 for other fields (like country and city).
I replaced LIKE in /DB_query_builder.php.
the error looks like this:
jquery-1.11.1.min.js:4 POST http://127.0.0.1/my_.../ajax_list_info 500 (Internal Server Error)
Can somebody help me?
Thanks a lot