NAME
Teng::Plugin::Pager::MySQLFoundRows - Paginate with SQL_CALC_FOUND_ROWS
SYNOPSIS
DESCRIPTION
This is a helper class for pagination. This helper only supports MySQL. Since this plugin uses SQL_CALC_FOUND_ROWS for calculate total entries.
METHODS
- my (\@rows, $pager) = $db->search_with_pager($table, \%where, \%opts);
-
Select from database with pagination.
The arguments are mostly same as
$db-
search()>. But two additional options are available.This method returns ArrayRef[Teng::Row] and instance of Teng::Plugin::Pager::Page.
AUTHOR
Tokuhiro Matsuno