Take care of variable _serach it is true or false. Download the exmples to

chack how to configure this in PHP.

Regards

Tony

i use datatype 'Json'

search works well, but when i pressed reset button, i haven't got correct results. Editbox "searchString" cleaned off, but grid hasn't reloaded

How solve this problem?

<?php
$page = $_GET['page'];
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];
$sField = $_GET['searchField'];
$sValue = $_GET['searchString'];
$sOper = $_GET['searchOper'];

switch ($sOper) { 
  - // -

}
if(!$sidx) $sidx =1;
$db = mysql_connect("localhost", $user, $pass) or die("Connection Error: " . mysql_error());
mysql_select_db("base") or die("Error conecting to db.");
$result = mysql_query("SELECT COUNT(*) AS count FROM table");
$row = mysql_fetch_array($result,MYSQL_ASSOC);       
$count = $row['count'];
if( $count >0 ) {
 $total_pages = ceil($count/$limit);
} else {
 $total_pages = 0;
}
if ($page > $total_pages) $page=$total_pages;
$start = $limit*$page - $limit;
if($start <0) $start = 0;
$SQL = "SELECT * FROM table ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i=0;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
    $responce->rows[$i]['id']=$i;
    $responce->rows[$i]['cell']=array($row[a],$row[b],$row[c],$row[d],$row[e]);
 $i++;
}
echo json_encode($responce);
?>