Smarty Examples of pagination

@session_start (); Require_once ("smarty.php");//load Smarty template class Require_once ("adodb/adodb.inc.php");//Load ADODB Database Connecting to a database $dbhost = ' localhost '; Database server $dbuser = ' root '; Database user Name $dbpwd = ' root '; Database Password $dbname = ' Hejia '; Database name $conn = newadoconnection (' mysql '); Establish a Connection object $conn->connect ($dbhost, $dbuser, $dbpwd, $dbname); Connecting to a database $conn->query ("Set Names ' gb2312 '");//derived from mysql_query ("Set Names GBK"); Date_default_timezone_set (PRC); PHP get a 8-hour time difference solution, can also be modified in php.ini Date.timezone for PRC ?> Copy Code Home index.php: !--? require_once ("const.php"); $sql 1= "Select Id,hits,title,add_date from Oa_art ORDER by id DESC";//sql statement $pageSize = 4;//set number of records per page $sql = $sql 1. "Limit". ($pageSize * ($_request[' page ')? 1: $_request[' page '])-1). ",". $pageSize; $news _array= $conn->getall ($sql); $news _array1= $conn->getall ($sql 1); $page _url= "index.php";//page URL address $totalnumber =count ($news _array1);//Get the total number of records $midPage = 5;//number of navigation links page ();//Call paging function for ($i = 0; $i <=ceil ($totalnumber/$pageSize); $i + +) $page _option[] = $i;//Generate pagination drop-down list array $smarty->assign ("Page_option", $page _option); $smarty->assign ("News_data", $news _array); $smarty->assign ("MyTitle", "corporate website Home"); $smarty->display ("tpl.htm", $page); ? Copy Code Paging functions: Function page () { Global $smarty, $start, $page _url, $pageSize, $midPage, $totalnumber; $total = $totalnumber; Get Total Record Count $totalPage = Ceil ($total/$pageSize); Get Total 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, replace the regular $url. = ($url? ") & ":" "). ' Page '; Additional $start = ($currentPage-1) * $pageSize; $back = $currentPage > 1? " <<\ n ":" "; $next = $currentPage < $totalPage? " >>\ n ":" "; $first = $currentPage > 1? " home \ n ":"; $last = $currentPage < $totalPage? " last \ n ":"; Navigation links $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 pages $smarty->assign ("Page_back", $back); Previous page $smarty->assign ("Page_next", $next); Next page $smarty->assign ("Page_first", $first); Home $smarty->assign ("Page_last", $last); Last $smarty->assign ("Page_midpages", $midPages); Middle Page $smarty->assign ("Page_url", $page _url); Current page address } ?> Copy Code Template page tpl.htm: <{$mytitle}> <{section name=nloop loop= $news _data}> <{sectionelse}> <{/section}> "> Title Release date Click Count . htm "><{$news _data[nloop].title}> <{$news _data[nloop].add_date|date_format: "%y-%m-%d"}> <{$news _data[nloop].hits}> Sorry, there is no news input! <{include file= "Bottom.htm"}> Copy Code

