Posted By

brownrl on 08/23/13

Tagged

Versions (?)

Last Edited at 08/23/13 07:59pm

Statistics

Viewed 582 times

Favorited by 0 user(s)

Related snippets

Sublime Snippet: pageit

/ Published in: PHP

This is a quick sublime snippet to quickly setup a DB table for pagination. Ideally from here you will be into a smarty template.

Highlighted TextExpand

<snippet>
  <content><![CDATA[

\$offset = 0;
\$page = 1;
\$pp = 6;
\$table = "users";
\$field = "user_created_timestamp";
\$dir = "DESC";

if( isset( \$_GET['p'] ) ) {
  \$page = intval( \$_GET['p'] );
  \$offset = ( \$page - 1 ) * \$pp;
}

// get the total
\$q = "SELECT COUNT( * ) AS total FROM \$table";
\$qr = dbQuery( \$q );
\$qrow = dbFetchArray( \$qr );
\$total = \$qrow['total'];

// Do the real select
\$q = "SELECT * FROM ".\$table." ORDER BY ".\$field." ".\$dir." LIMIT ".\$pp." OFFSET ".\$offset;
\$qr = dbQuery( \$q );

\$assigns['total'] = \$total;
\$totalpages = ceil( \$total / \$pp );
\$assigns['totalpages'] = \$totalpages;
\$assigns['items'] = dbFetchAllArray( \$qr );

\$prev = false;
\$first = false;
\$next = true;
\$last = true;

if( \$offset != 0 ) {
  \$prev = true;
  \$first = true;
}

if( \$page == \$totalpages ) {
  \$next = false;
  \$last = false;
}

\$assigns['prevpage'] = \$page - 1;
\$assigns['nextpage'] = \$page + 1;
\$assigns['first'] = \$first;
\$assigns['prev'] = \$prev;
\$assigns['next'] = \$next;
\$assigns['last'] = \$last;

]]></content>
  
  <tabTrigger>pageit</tabTrigger>
  
  
</snippet>

URL: http://www.itsgotto.be/cv.php

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.