Smarty Paginate Example - Smarty Pagination with PHP :: PHP Form.net

HomeSaturday, August 18, 2018, 20:18:46

Smarty Paginate Example - Smarty Pagination with PHP

Monday, February 9, 15, 02:08:43, 4 Yaers Ago Via wain, Hits: 7520

Smarty Paginate Example, Smarty Pagination with PHP. SmartyPaginate: a class/plugin for data set pagination within the Smarty template environment

Resource Smarty Paginate:

search.php

Code:

function get_db_results()

  {

      $id = $_GET['id'];

      $_query = sprintf("SELECT SQL_CALC_FOUND_ROWS * FROM links WHERE linkname LIKE '%%$id%%' LIMIT %d,%d", SmartyPaginate::getCurrentIndex(), SmartyPaginate::getLimit());

      $_result = mysql_query($_query);

      while ($_row = mysql_fetch_array($_result, MYSQL_ASSOC)) {

          $_data[] = $_row;

      }

      $_query = "SELECT FOUND_ROWS() as total";

      $_result = mysql_query($_query);

      $_row = mysql_fetch_array($_result, MYSQL_ASSOC);

      SmartyPaginate::setTotal($_row['total']);

      mysql_free_result($_result);

      return @$_data;

  }

require ('libs/SmartyPaginate.class.php');

SmartyPaginate::connect();

SmartyPaginate::setLimit(10);

SmartyPaginate::setUrl('search.php');

$smarty->assign('results', get_db_results());

SmartyPaginate::assign($smarty);

$smarty->display('search.php');

search.php(template)

Code:

{section name="results" loop=$results}

{$results[results].linkname}<br />

{/section}

Links {$paginate.first}-{$paginate.last} of {$paginate.total}. 

{paginate_prev} {paginate_next}