/**
* The default function
*
* Set up some variables and add them to the view file data
*/
public function index()
{
/**
* This part is the same as the previous example. For brevity comments are removed.
*/
$content = '';
TINA_MVC\include_helper('pagination');
global $wpdb;
$base_sql = 'SELECT ID AS `Database ID`, user_login AS `User Login`, display_name AS `Display Name` FROM ' . $wpdb->users;
$count_sql = 'SELECT COUNT(ID) FROM ' . $wpdb->users;
$P = new TINA_MVC\pagination('my_paginator');
$P->set_count_from_sql($count_sql);
/**
* OK, not quite the same. The base url is obviously different!
*/
$P->set_base_url(TINA_MVC\get_controller_url('page-test-2'));
$P->filter_box_on_fields(array('User Login' => 'user_login', 'Display Name' => 'display_name', 'user_email' => 'user_email'));
$P->set_base_sql($base_sql);
$P->set_mid_range(9)->set_items_per_page(10)->set_default_sort_by('User Login')->set_default_sort_order('desc');
/**
* We will get the results and format custom HTML rows rather than allow
* the pagination helper to give us a generic table. You should use escaped
* HTML here.
*/
$rows = $P->get_sql_rows();
// TINA_MVC\prd( $rows );
/**
* Iterate throught the results and build some HTML
*/
foreach ($rows as $i => &$r) {
//echo $r->{'User Login'};
/**
* We'll use this is the view file to produce the alternating row styles
*/
$this->add_var('i', $i);
/**
* The row of data
*
* You need to be careful here if your array keys (or object variables) require escaping.
*/
$this->add_var_e('r', $r);
/**
* The view file here is only a HTML snippet. It renders only one row.
*
* It is the first example of using a view snippet to produce output.
*
* In this case, the view file is used to render headings or rows based on the value of $view_file_part
*/
$this->add_var('view_file_part', 'rows');
$r = $this->load_view('page_test_2');
}
/**
* Set the rows, overriding the use of the html table helper.
*
* This will also supress the table headings.
*/
$P->set_html_rows($rows);
/**
* Set the table headings. This is optional.
*
* In this case, the view file is used to render headings or rows based on the value of $view_file_part
*/
$this->add_var('view_file_part', 'headings');
$P->set_html_headings($this->load_view('page_test_2'));
/**
* Grab the html.
*/
$content = $P->get_html();
/**
* Sets the post title
*/
$this->set_post_title('Testing Pagination 2');
/**
* Sets the post content. Note we are not using a view file for this example
*/
$this->set_post_content($content);
}
