Kumar Gaurav asked 10 years ago
I am evaluating demo mode… same problem, not understood how to use ignorecase thorugh php_grid. Please guide asap
Abu Ghufran answered 10 years ago
You can switch column settings to use begins with search instead of contains.
beginswith is case insensitive using LOWER() function.
$col["searchoptions"]["sopt"] = array("bw");
Abu Ghufran answered 10 years ago
Hi Kumar,
You can review demo online, and code is same as 'demos/editing/index.php'
http://www.phpgrid.org/demo/demos/editing/index.php
Which database are you using? Above demo is using mysql.
Kumar Gaurav answered 10 years ago
Oracle.
Also, problem is that the component has no configuration for simulating ignorecase : true of jqGrid.
Please help.
Abu Ghufran answered 10 years ago
For oracle, your need to replace default 'contains' search with 'beginswith'.
Search following line in jqgrid_dist.php, and edit
stringResult: true,searchOnEnter : false, defaultSearch:'cn'
to
stringResult: true,searchOnEnter : false, defaultSearch:'bw'
