Here is my server side code
PHP Code:
<?php
include('../settings.php');
$arr = array();
$db = mysql_connect ($DB_HOST,$DB_USER,$DB_PASS) or die("Database error");;
mysql_select_db($DB_NAME, $db);
mysql_query("SET NAMES 'utf8'");
$start = ($_REQUEST['start'] != '') ? $_REQUEST['start'] : 0;
$limit = ($_REQUEST['$limit'] != '') ? $_REQUEST['$limit'] : 9;
if (!empty($_REQUEST['fields']) && !empty($_REQUEST['query'])){
$campos = substr(stripcslashes($_REQUEST['fields']),2,-2);
$prewhere = split('\",\"', $campos);
foreach ($prewhere as $index=>$value){
$where[$index] = $value." LIKE '%".$_REQUEST['query']."%' ";
}
$endwhere = " AND ".implode(" OR ",$where);
$count_sql = "SELECT id,name,code,city,address,description FROM shops WHERE group_id = ".$_REQUEST['group_id']." ".$endwhere;
} else {
$count_sql = "SELECT id,name,code,city,address,description FROM shops WHERE group_id = ".$_REQUEST['group_id'];
}
$sql = $count_sql." LIMIT ".$start.", ".$limit;
If (!$rs = mysql_query($sql)) {
Echo '{success:false}';
}else{
$rs_count = mysql_query($count_sql);
$results = mysql_num_rows($rs_count);
while($obj = mysql_fetch_object($rs)){
$arr[] = $obj;
}
Echo '{success:true,results:'.$results.',rows:'.json_encode($arr).'}';
}
?>