默默分页+smarty+adodb实现分页

复制PHP内容到剪贴板

PHP代码:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
include ("smarty/Smarty.class.php"); 
include("adodb/adodb.inc.php"); 
include("config.php"); 
require_once("include/JSON.php");

$db = NewADOConnection('mysql');
$db->Connect($dbhost,$dbuser,$dbpass, $dbname)or die("C FAILED");
mysql_query('set names "utf8"');
$data=$db->Execute("select * from wenzhang WHERE `tai` LIKE '精品宝典'") or die("q FAILED"); 

$total = $data->RecordCount();
$page=isset($_GET['page'])?intval($_GET['page']):1;       
$num=2;    
$pagenum=ceil($total/$num);  
If($page>$pagenum || $page == 0){
       Echo "Error : Can Not Found The page .";
       Exit;}
$offset=($page-1)*$num;                                     
$info=$db->Execute("select * from wenzhang WHERE `tai` LIKE '精品宝典' limit $offset,$num");   
While(!$info->EOF){
       $it[]=$info->fields;
      // echo $it."<br>";
       $info->MoveNext();
}                                                            
For($i=1;$i<=$pagenum;$i++){       
       $show[]=($i!=$page)?"<a href='jing.php?page=".$i."'>$i</a>":"<b>$i</b>";
       //Echo $show." ";
}


while(!$data->EOF){
//$id[]=$dataReturned->fields['id'];
$t[]=$data->fields;
$data->MoveNext();
}


//print_r($ttt);
$template  =  new Smarty;
$template->assign('it',$it);
$template->assign('show',$show);
$template->display('hot.tpl');
?>

复制PHP内容到剪贴板

PHP代码:

//.....
  <table width="90%" height="10" border="0" align="center" id="table1"> 
    <tr align="right"><td>页数：{foreach from=$show key=k item=v} {$v}{/foreach}</td></tr>
   {foreach from=$it key=k item=v} <tr align="center"><td><a href="show.php?id={$v.id}">{$v.title}</a></td></tr>{/foreach}

  </table>
//.....