php smarty分頁原理與分頁程式碼分享

include_once("smarty.class.php");
class smartyproject extendmartssy
 >函數__construct()
 {
 $this->config_dir="smarty/smarty/config_file.class.php";
 $this->caching=false;
 $this->template_dir = "smarty/templates/";
 $this->cache_dir = "smarty/smarty_cache/";
 $ this->left_delimiter = "{";
 $this-🎜> $this- >right_delimiter = "}";
 }
}
?>

複製程式碼

class conndb
{
var $dbtype;
var $host;
var $user
var $🎜>var $ pwd;
var $dbname;
var $debug;//false 不顯示偵錯訊息，反之，顯示
var $conn;
function __construct($dbtype,$host,$user, $pwd,$dbname,$debug=false)
{
 $this->dbtype = $dbtype;
 $this->host = $host;
 $this->user = $user ;
 $this->pwd = $pwd;
 $this->dbname = $dbname;
 $this->debug = $debug;
}
 // 實作資料庫的連接並且回傳連接物件(個人理解可以說回傳adodb物件)
function getconnid()
{
 include_once('adodb5/adodb.inc.php');
 if ($this->dbtype == "mysql" || $this->dbtype == "mssql")
 {
if($this->dbtype == "mysql")
 {
 $this->conn = newadoconnection("mysql");//建立adodb對象，資料庫宣告類型為mysql
}
else
{
 $this->conn = newadoconnection("mssql");
 $this->conn = newadoconnection("mssql");
 }
$this->conn->connect($this->host,$this->user,$this->pwd,$this- >dbname);

 }
 else if ($this->dbtype == "access")
 {
$this->conn = newadoconnection("access") ;
$this->conn->connect("driver={microsoft access driver (*.mdb)};dbq=".$this->dbname.";uid=".$this-> ;user.";pwd=".$this->pwd.";");
 }

 $this->conn->execute("設定名稱utf-8") ;

 if($this->dbtype == "mysql")
 {
$this->conn->debug = $this->debug;
 }
 return $this->conn;

}
function closeconnid()//關機與資料庫的連接
{

複製程式碼

3，資料庫操作類：





class admindb
{
 var $sqlstr;
 var $conn;
 var $sqltype;
 var $ rs;
 var $array;
 function execsql($sqlstr,$conn)
 {
$rs = $conn->execute($sqlstr);
$sqltype = strtolower( substrtolower( substr (修剪($sqlstr),0,6)); //strtolower() 函數把字串轉換為小寫。
if($sqltype = "select")
{
 $array = $rs->getrows(); // 類似mysql_fetch_array函數傳回的吞吐量
 if(count($array) = = 0 || $rs == false)
 {
return false;
 }
 else
 {
return $array;
 }
}
return $array;
 }
}
}
 else if($sqltype = "更新"||$sqltype = "插入"||$sqltype = "刪除")
{
 if($rs)

{回傳false; }} } } 複製程式碼 複製程式碼 複製程式碼 複製碼🎜>

4，分頁類：

類間隔
{
var $rs;
var $pagesize;
var $ nowpage ;
var $array;
var $conn;
var $sqlstr;
function showdate($sqlstr,$conn,$pagesize,$nowpage)
{
 if( ! isset($nowpage)||$nowpage=="")
 {
$nowpage = 1 ;
 }
 else
 {
$this->nowpage = $ nowpage;
 }
 $this->pagesize = $pagesize;
 $this->conn = $conn;
 $this->sqlstr = $sqlstr;
 $this ->rs = $ this->conn->pageexecute($this->sqlstr,$this->pagesize,$this->nowpage);
 //pageexecute($sql, $nrows) , $page, $inputarr=false) 使用資料集的頁碼功能，參數$page 為1 為啟使值
$this->array = $this->rs->getrows();
if(count($this->array) == 0 || $this->rs == false)
{
 return false;
}
else
 {
 return $this->array;
}

}
function showpage($contentname,$utits,$anothersearchstr,$class)
{
 $allrs=$this- >conn->execute($this->sqlstr);
 $record=count($allrs->getrows());
 $pagecount=ceil($record/$this->pagesize); p>

 $str.="共有".$contentname." "。 $record." ".$utits." 每頁顯示 ".$this->pagesize." ".$utits." 第 ".$this->rs ->absolutepage()." 頁/共 ".$pagecount ." 頁";
 $str.="    ";
 if(!$this->rs->atfirstpage())
 {
$str.="首頁";
 }
 else
 {
$str.="首頁";
 }
 $str.=" ";
 if(!$this->rs->atfirstpage())
 {
$str.="rs->absolutepage()-1).$anothersearchstr." class=".$ class.">上一頁";
 }
 else
 {
$str.="上一頁" ;
 }
 $str.=" "; p>
 if(!$this->rs->atlastpage())
 {
$str.= "rs->absolutepage() 1).$anothersearchstr." class=".$class.">下一頁";
 }
 else
 {
$str.="下一頁";
 }
 $str.=" ";

 if(!$this->rs->atlastpage())
 {
$str.="尾頁";
 }
 else
 {
$str.="尾頁";
 }
 if(count($this->array)==0 | | $this->rs==false)
 {
 return "";
 }
 else
 {
 return $str;
 }
 }
 return $str;
 }

複製程式碼

5，文章字元轉換處理的類別：

class usefun
{

 function unhtml($text)
 {
 content=(nl2br(htmlspecialchars($text)));//htmlspecialchars() 函數把一些預先定義的字元轉換為html 實體,nl2br() 函數在字串中的每個新行(/n) 之前插入html換行符()。
$content=str_replace("[strong]","",$content);
$content=str_replace("[/strong]","
$content=str_replace("[em]","",$content);
$content=str_replace("[/em]","
$content=str_replace("[u]","",$content);
$content=str_replace("[/u]","


$content=str_replace("[font color=#ff0000]","",$content);
$content =str_replace("[font color=#00ff00]","",$content);
$content=str_replace("[font color=#0000ff]","",$content);

將以上四個類別全部放到一個類別檔案system.class.inc.php裡.

另外幾個文件： 1、system.inc.php:

 session_start();
 include_once("smarty_inc.php");
 include_once("smarty_inc.php"); ("system.class.inc.php");
 //資料庫連線類別實例化
 $connobj = new conndb("mysql","localhost","root","vertrigo","db_fenye" ,false);
 $conn = $connobj->getconnid();
 //資料庫操作類別實例化
 $admindb = new admindb();
 //分割頁類別實例化
 $seppage=new seppage();
 //使用常用函數類別實例化
 $usefun=new usefun();
 //呼叫smarty模板
 $smarty=new smartyproject();
 function unhtml($params)
 {
 extract($params);
 $text=$content;
 global $usefun;
 return $usefun->unhtml($text global $usefun;
 return $usefun->unhtml($text );
 }
 $smarty->register_function("unhtml","unhtml");
?>

2、執行文件，index.php:

include_once("system.inc.php");
$arraybbstell = $admindb->e​​.php");
$arraybbstell = $admindb->e​​.php xecsql( " select * from tb_bookinfo",$conn);
if(!$arraybbstell)
{
 $smarty->assign("isbbstell","t");
}
else
{
 $smarty->assign("isbbstell",t);
 $smarty->assign("arraybbstell",$arraybbstell);
}
$arraybbs = $arraybbs = $ seppage- >showdate("select * from tb_bookinfo",$conn,1,$_get["page"]);
if(!$arraybbs)
{
 $smarty->assign( "isbbs ", f);

}
else
{
 $smarty->分配("isbbs",t);
 $smarty->分配(" showpage",$ seppage- >showpage("帖子","條","","a1"));
 $smarty->assign("arraybbs",$arraybbs);
}
$smarty-> display( "index.html");

3、解析文件,index.html:

椤垫ā







 

{if $isbbs=="t"}