Ext.Direct and Grid with Paging Toolbar (Need Help!)

[nizhelya]

I'm learning tutorial (Mapping a Grid to a MySQL table using Direct and PHP Part 2) and trying to connect a Paging Toolbar to a Grid. But using the following QueryDatabase.php function I get all 1000 records from Database (it is a PhP code from zip provided by Sencha for that tutorial):

public function getResults(stdClass $params)
    {
        
        $_db = $this->__construct();
   
        $_result = $_db->query('SELECT id, name, address, state FROM owners');
        
        $results = array();
       
        while ($row = $_result->fetch_assoc()) {
            array_push($results, $row);
        }
        
        return $results;
    } 

Click on Paging Toolbar Next Page button sends data with the following parameters to server: {"action":"QueryDatabase","method":"getResults","data":[{"page":3,"start":50,"limit":25}],"type":"rpc","tid":3}

But this function does not process(provide) those parameters.

I can remake PhP code and make it process the Query using "start" and "limit" post variables in SQL query. Also I can get a total table records amount ($total). But I need to send $total to Reader (through return function array $results).

How I can do that?
Is there any working solution for this function where all params included (sort, filter, total) ?

[mitchellsimoens]

This would be up to your implementation. It would be as easy as checking for a param in the request and adding the needed SQL bits to the query.

[nizhelya]

Thanks. Where is better to do sorting: in SQL query or in grid?

[mitchellsimoens]

If you are doing paging then on the server