Change

to:

ans this works for me at least with the initial testing in FF

searchstr variable is set to: 

{"groupOp":"AND","rules":[{"field":"lname","op":"bw","data":"s"
}]}

but json_decode returns empty.

When I use FireBug to look at the parameters I see that filters is set to:

Are the "" the problem why json_decode is not working and if so where did they come from??

Just thought I would share with the group:

<CODE>

$where = "";
$searchOn = $_REQUEST['_search'];
if($searchOn=='true') {
        $searchstr = $_REQUEST['filters'];
        $where = constructWhere($searchstr);
}
function constructWhere($s){
    $qwery = "";
        //['eq','ne','lt','le','gt','ge','bw','bn','in','ni','ew','en','cn','nc']
    $qopers = array(
                  'eq'=>" = ",
                  'ne'=>" <> ",
                  'lt'=>" < ",
                  'le'=>" <= ",
                  'gt'=>" > ",
                  'ge'=>" >= ",
                  'bw'=>" LIKE ",
                  'bn'=>" NOT LIKE ",
                  'in'=>" IN ",
                  'ni'=>" NOT IN ",
                  'ew'=>" LIKE ",
                  'en'=>" NOT LIKE ",
                  'cn'=>" LIKE " ,
                  'nc'=>" NOT LIKE " );
    if ($s) {
        $jsona = json_decode($s,true);
        if(is_array($jsona)){
                $gopr = $jsona['groupOp'];
                $rules = $jsona['rules'];
            $i =0;
            foreach($rules as $key=>$val) {
                $field = $val['field'];
                $op = $val['op'];
                $v = $val['data'];
                if($v && $op) {
                  $i++;
                  // ToSql in this case is absolutley needed
                  $v = ToSql($field,$op,$v);
                  if ($i == 1) {
                     $qwery = "WHERE ";
                  } else {
                     $qwery .= " " .$gopr." ";
                  }
                                        switch ($op) {
                                                // in need other thing
                                            case 'in' :
                                            case 'ni' :
                                                $qwery .= $field.$qopers[$op]." (".$v.")";
                                                break;

                                            default:
                                                $qwery .= $field.$qopers[$op].$v;
                                        }
                                }
            }
        }
    }
    return $qwery;
}
function ToSql ($field, $oper, $val) {
        // we need here more advanced checking using the type of the field - i.e. integer, string, float
        switch ($field) {
                case 'id':
                        return intval($val);
                        break;
                case 'amount':
                case 'tax':
                case 'total':
                        return floatval($val);
                        break;
                default :
                        //mysql_real_escape_string is better
                        if($oper=='bw' || $oper=='bn') return "'" . addslashes($val) . "%'";
                        else if ($oper=='ew' || $oper=='en') return "'%" . addcslashes($val) . "'";
                        else if ($oper=='cn' || $oper=='nc') return "'%" . addslashes($val) . "%'";
                        else return "'" . addslashes($val) . "'";
        }
}

I am just getting started and I have a couple things.

In the examples (/blog/jqgrid/jqgrid.html), under New in version 3.7 is Toolbar Search.

It is spelt "Tooolbar search" - small thing I know.

More importantly, the PHP code shows a reference to a "$where" variable, but this variable is never declared or calculated. How do you get the filter information into the "$where" variable?

The code for the Virtual scrolling looks exactly the same...it doesn't explain the "$where" variable either.

I don't suppose there is anywhere to download examples from to run on my own server? It would sure help to have a few working examples (I am using PHP and MySQL).

Jim