Smarty paging example

@session_start();
require_once("smarty.php");//Load smarty template class
require_once("adodb/adodb.inc.php");/ /Load adodb database
//Connect to database
$dbhost = 'localhost'; // Database server
$dbuser = 'root'; // Database user name
$dbpwd= 'root' ; // Database password
$dbname='hejia'; //Database name
$conn = NewAdoConnection('mysql'); // Create connection object
$conn->Connect( $dbhost, $dbuser, $dbpwd, $dbname); //Connect to the database
$conn->Query("Set Names 'gb2312'"); //Sourced from mysql_query("SET NAMES GBK");
date_default_timezone_set( PRC); //The solution for PHP to obtain the time difference of 8 hours, you can also modify the date.timezone in php.ini to PRC
?>

Homepage index.php:

require_once("const.php");
$sql1="select id,hits,title,add_date from oa_art order by id desc"; //SQL statement
 $pageSize=4; //Set the number of records per page
$sql=$sql1." limit ".($pageSize * ((empty($_REQUEST['page']) ? 1 : $_REQUEST['page']) -1)).", ".$pageSize;
$news_array=$conn->getall($sql);
$news_array1=$conn->getall($sql1);
$page_url="index.php "; //Page url address
$totalnumber=count($news_array1); //Get the total number of records
$midPage=5; //Number of digital navigation links
page();// Call the paging function
for ($i = 0; $i <=ceil($totalnumber/$pageSize); $i++) $page_option[] = $i;//Generate a paginated drop-down list array
$smarty-> assign("page_option",$page_option);
$smarty->assign("news_data",$news_array);
$smarty->assign("mytitle","Corporate website Home page");
$smarty->display("tpl.htm",$page);
?>

Paging function:

function page()
{
 global $smarty,$start,$page_url,$pageSize,$midPage,$totalnumber;
 $total = $totalnumber ; / /Get the total number of records
 $totalPage = ceil($total/$pageSize); //Get the total number of pages
 $currentPage=@$_REQUEST['page']+0; //Current page
 if(!is_numeric($ currentPage) || $currentPage < 1 || empty($currentPage) || $currentPage > $totalPage)
 $currentPage=1; //Initialize the current page
 $url = preg_replace(array("!(([& ]|^)(page)[=]?([^&]+)?)|((([&]){2,})|(^[&])|([&]$))!" ,),array(""),$_SERVER["QUERY_STRING"]); // Set the address and replace it with regular
 $url.=($url?"&":"").'page'; // Append
 $start = ($currentPage-1)*$pageSize;
 $back = $currentPage > 1?"<<n":"";
 $next = $currentPage < $totalPage ?">>n":"";
 $first = $ currentPage > 1?"Homepagen":"";
 $last = $currentPage < $ totalPage?"Last pagen":"";
 // Navigation link
 $midPages = '';
 $num = $currentPage-floor($midPage/2);
 if($num > 0)
 {
 if(($totalPage-$num) < $ midPage)
 {
 $tmp = $totalPage - $midPage;
 $num = $tmp< 0 ? 1 : ++$tmp;
 }
 }else $num = 1;
 for($i=1; $i< ;=$midPage;$i++,$num++)
 {
 if($num > $totalPage) break;
 $midPages .= ($num == $currentPage) ? '['.$num.'] ' : "".$num." ";
 }
 $ smarty->assign("page_total",$total); // Total
 $smarty->assign("page_currentPage",$currentPage); // Current page number
 $smarty->assign("page_totalPage",$ totalPage); // Total number of pages
 $smarty->assign("page_back",$back); // Previous page
 $smarty->assign("page_next",$next); // Next page
 $smarty->assign("page_first",$first); // Homepage
 $smarty->assign("page_last",$last); // Last page
 $smarty->assign("page_midPages" ,$midPages); // Middle page
 $smarty->assign("page_url",$page_url); // Current page address
 }
?>

模板页 tpl.htm:

<{$mytitle}>



                <{section name=nloop loop=$news_data}>  ">              <{sectionelse}><{/section}>

标题
发布日期
点击次数



<{$news_data[nloop].title}>
<{$news_data[nloop].add_date|date_format:"%Y-%m-%d"}>
<{$news_data[nloop].hits}>


对不起，没有任何新闻输入！






共<{$page_total}>条　
第<{$page_currentPage}>/<{$page_totalPage}>页　
<{$page_first}>
<{$page_back}>
<{$page_midPages}>
<{$page_next}>
<{$page_last}>


转到
 
<{html_options options=$page_option selected=$page_currentPage}>
<{include file="bottom.htm"}>