PHP中模板分页的处理_PHP技巧

}

}

return $this->hPearDB;

}

//获取书籍总数

function getBookTotal($TypeId)

{

$db = $this->_getDBClass();

$sql = "SELECT COUNT(*) AS total FROM ...";

$rs = $db->getOne($sql);

if (DB::isError($rs))

return $rs->getMessage();

else

return $rs;

}

//获取所有书籍

function getBookFromType($TypeId, $start, $offset)

{

$db = $this->_getDBClass();

$sql = "SELECT * FROM ... LIMIT $start,$offset";

$rs = $db->getAll($sql);

if (DB::isError($rs))

return $rs->getMessage();

else

return $rs;

}

}

?>

--------------------------------------------------------------------------------

最后再让我们看一下这个Type.html模板是如何处理的：

--------------------------------------------------------------------------------

{* 插入头部文件 *}

{include file="Cendar/head.html"}

<div id="side">

<ul>

<li>书籍总数：{$BookTotal}</li>

</ul>

</div>

<div id="Book">

<h2 class="cata">书籍具体内容</h2>

<ul>

{section name=Book loop=$allBook}

<li><a href="show_Book.php?tid={$allBook[Book].id}">{$allBook[Book].title}</a></li>

{sectionelse}

<li class="warning">目前没有书籍</li>

{/section}

</ul>

</div>