SeeIT Consult

 
        /**
         * Include the helper
         */
        tina_mvc_include_helper('tina_mvc_pagination_helper');
 
        /**
         * We are using custom SQL here to demonstrate the use of the pager.
         *
         * The $base_sql is a properly escaped statement that will get you all the rows you want. ORDER BY and LIMIT clauses
         * are not set - they will be set automatically.
         */
        $base_sql = 'SELECT ID AS `Database ID`, user_login AS `User Login`, display_name AS `Display Name` FROM '.$wpdb->users;
 
        /**
         * A SQL statement to get the total number of rows returned in the above statement.
         */
        $count_sql = 'SELECT COUNT(ID) FROM '.$wpdb->users;
 
        /**
         * The HTML table ID is set from the parameter you pass to the constructor
         */
        $P = new tina_mvc_pagination_helper( 'user_list' );
 
        $P->set_count_from_sql( $count_sql );
 
        /**
         * The url required to get to the default table view
         * 
         * Extra strings will be appended to this to support pagination and sorting
         */
        $P->set_base_url( tina_mvc_make_controller_url('sample-pagination') );
 
        $P->set_base_sql( $base_sql );
 
        /**
         * For the pagination links
         * 
         * This will likely be changed to an object method in the future
         */
        $P->mid_range = 9;
 
        $P->set_items_per_page( 10 );
 
        /**
         * Optional, but you probably don't want data sorted by an ID field
         */
        $P->set_default_sort_by( 'User Login' );
        $P->set_default_sort_order( 'desc' );
 
        /**
         * Grab the HTML. This is all ready to pass to your view file
         */
        $this->set_post_content( $P->get_html() );
 
        $this->set_post_title('Pagination');

 
        /**
         * Include the helper
         */
        tina_mvc_include_helper('tina_mvc_table_helper');
 
        /**
         * The parameter is used to create a unique ID tag for the html table element.
         */
        $table = new tina_mvc_table_helper( 'my_table_table' );
 
        /**
         * $table_data is an array or an object
         */
        $table->set_data( $table_data );
 
        /**
         * If you have proper pre-escaped HTML in the headers, you will want to prevent double escaping
         */
        // $table->do_not_esc_th( TRUE );
 
        /**
         * And grab your HTML
         */
        $html = $table->get_html();

        $rows = $P->get_sql_rows();
 
        /**
         * Want a look? ;-)
         */
        //echo "<pre>"; var_dump( $rows ); die;
 
        /**
         * Iterate throught the results and build some HTML. Note we are assigning $r by reference
         */
        foreach( $rows AS $i => & $r ) {
 
            if( $i % 2 ) {
                $bg = '#333';
                $fg = '#ccc';
            }
            else {
                $bg = '#ccc';
                $fg = '#333';
            }
 
            $r->{'Database ID'} = '<span style="color:'.$fg.';background:'.$bg.'">'.$wpdb->escape($r->{'Database ID'}).'</span>';
            $r->{'User Login'} = '<span style="color:'.$fg.';background:'.$bg.'"><a href="#" title="'.$wpdb->escape($r->{'Display Name'}).'">'.$r->{'User Login'}.'</a></span>';
 
            /**
             * You can also unset() an entry here. This has the effect of removing a row from final output.
             * You will still be able to filter results on the field though.
             */
            unset( $r->{'Display Name'} );
 
            /**
             * Add a made up field.
             */
            $r->{'A number between 1 and 10'} = rand( 1, 10);
 
        }
 
        /**
         * Set the rows, overriding the use of the html table helper
         */
        $P->set_html_rows( $rows );

        /**
         * This will prevent the helper from adding sortable column HTML to the
         * column heading 'A number between 1 and 10'.
         *
         * You cannot sort on columns that do not come directly from the database.
         */
        $P->suppress_sort( array('A number between 1 and 10') );

        /**
         * Set up the filter.
         *
         * This allows a user to search on various fields (even if they are not
         * selected for display). This will output a form at the top of the table
         * of results.
         * 
         * Parameter is array ( 'Display Name' => 'mysql_field_name' )
         */
 
        $P->filter_box_on_fields( array(
                                        'Login' => 'user_login',
                                        'Display Name' => 'display_name',
                                        'Email' => 'user_email'
                                        )
                                 );