1. #1
    Sencha Premium Member
    Join Date
    Jan 2012
    Posts
    10
    Vote Rating
    0
    nizhelya is on a distinguished road

      0  

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

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


    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):
    PHP Code:
    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) ?

  2. #2
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    36,784
    Vote Rating
    833
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default


    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.
    Mitchell Simoens @SenchaMitch
    Sencha Inc, Senior Forum Manager
    ________________
    Check out my GitHub, lots of nice things for Ext JS 4 and Sencha Touch 2
    https://github.com/mitchellsimoens

    Think my support is good? Get more personalized support via a support subscription. https://www.sencha.com/store/

    Need more help with your app? Hire Sencha Services services@sencha.com

    Want to learn Sencha Touch 2? Check out Sencha Touch in Action that is in print!

    When posting code, please use BBCode's CODE tags.

  3. #3
    Sencha Premium Member
    Join Date
    Jan 2012
    Posts
    10
    Vote Rating
    0
    nizhelya is on a distinguished road

      0  

    Default


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

  4. #4
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    36,784
    Vote Rating
    833
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default


    If you are doing paging then on the server
    Mitchell Simoens @SenchaMitch
    Sencha Inc, Senior Forum Manager
    ________________
    Check out my GitHub, lots of nice things for Ext JS 4 and Sencha Touch 2
    https://github.com/mitchellsimoens

    Think my support is good? Get more personalized support via a support subscription. https://www.sencha.com/store/

    Need more help with your app? Hire Sencha Services services@sencha.com

    Want to learn Sencha Touch 2? Check out Sencha Touch in Action that is in print!

    When posting code, please use BBCode's CODE tags.

Thread Participants: 1

Tags for this Thread

Turkiyenin en sevilen filmlerinin yer aldigi xnxx internet sitemiz olan ve porn sex tarzi bir site olan mobil porno izle sitemiz gercekten dillere destan bir durumda herkesin sevdigi bir site olarak tarihe gececege benziyor. Sitenin en belirgin ozelliklerinden birisi de Turkiyede gercekten kaliteli ve muntazam, duzenli porno izle siteleri olmamasidir. Bu yuzden iste. Ayrica en net goruntu kalitesine sahip adresinde yayinlanmaktadir. Mesela diğer sitelerimizden bahsedecek olursak, en iyi hd porno video arşivine sahip bir siteyiz. "The Best anal porn videos and slut anus, big asses movies set..." hd porno faketaxi