gitpan / dbix-pager Goto Github PK
View Code? Open in Web Editor NEWRead-only release history for DBIx-Pager
Home Page: http://metacpan.org/release/DBIx-Pager
Read-only release history for DBIx-Pager
Home Page: http://metacpan.org/release/DBIx-Pager
NAME DBIx::Pager - SQL paging helper. SYNOPSIS use DBIx::Pager; my $pager = DBIx::Pager->new( dsn => 'dbi:mysql:test', user => 'root', table => 'table', offset => 0, limit => 20 ); if($pager->has_next) { # ... } DESCRIPTION DBIx::Pager supports calculation about paging when SELECT a lot of data. this module is suitable for Web application using MySQL and Template- Toolkit. METHODS $pager = DBIx::Pager->new(%args) construct DBIx::Pager object. the optios are below. dsn DBI datasource. user DBI username password DBI password dbh connected database handle. table setup table name. (require) limit limit of data per page. (require) offset offset of page. (default 0) where_clause SQL where clause. my $pager = DBIx::Pager->new( dbh => $dbh table => 'table', offset => 0, limit => 20, where_clause => 'WHERE id < 1000' ); # with place holder. my $pager = DBIx::Pager->new( dbh => $dbh table => 'table', offset => 0, limit => 20, where_clause => [ 'WHERE id < ?', $id ] ); $total = $pager->total total count of rows. $pager->has_next return true when pager has next pages. $pager->has_prev return true when pager has previous pages. $pager->next_offset return next offset. $pager->prev_offset return previous offset. $pager->page_count return total "page" count. $page->current_page reutrn current page number. first is 1. AUTHOR IKEBE Tomohiro <[email protected]> This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. SEE ALSO the Data::Page manpage the DBI manpage
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.