Paging Grid with PHP backend

[stbeli]

Hm, try default name

"total":1000,

Work for me.

Try to analyse code from this link
http://extdirectspring.ralscha.ch/demo/simple/

[stbeli]

I think that I found. Move your total one position above like this

{
"type":"rpc",
"tid":1,
"action":"QueryEmployee",
"method":"readEmployee",
"result":{"total":1000,"records":[{"id":"13",  <-- put total in result array

[danielleng]

stbeli: THANK YOU SO MUCH. I got it to work! Damn I actually thought of putting the total inside the 'result' array yesterday too.... but I had to take a break from coding for a while and forgot about it. Many thanks to you guys. This clears up a lot of my questions regarding Ext.direct.

[danielleng]

So to summarize, I did not need to change my router.php at all. I just needed to change my server-side PHP method to return the results in the correct format like so:

            
            $results = array();
             $results['total'] = $totalResults;
            
            $temp_array = array();
            $result = $stmt->get_result();
            while ($row = $result->fetch_array (MYSQL_ASSOC))
            {
                array_push($temp_array, $row);
            }
            $results['records'] = $temp_array;

            return $results;

I also had to declare a reader in my store's proxy to tell it the root key of the array containing my results.

        reader:{
            type: 'json',
            root: 'records'
        }

[Erikvip]

Oh nevermind, I missed the fix.