无废话，看代码
PHP代码
- <?php
- header("Content-type:text/html;charset=utf-8");
- include_once("tbs_class_php4.php");
- include_once("tbs_plugin_bypage.php");
- include_once("tbs_plugin_navbar.php");
- $conn = mysql_connect("localhost","root","root");
- mysql_select_db("test",$conn);
- mysql_query("SET NAMES 'utf8'");
- // Default value
- if (!isset($_GET)) $_GET=&$HTTP_GET_VARS ;
- if (isset($_GET['PageNum'])) {
- $PageNum = $_GET['PageNum'];
- } else {
- $PageNum = 1;
- }
- // Default value
- if (isset($_GET['RecCnt'])) {
- $RecCnt = intval($_GET['RecCnt']);
- } else {
- $RecCnt = -1;
- }
- $PageSize = 5;
- $query = "Select * from test";
- $tbs = new clsTinyButStrong;
- $tbs->LoadTemplate("tests.html");
- $tbs->PlugIn(TBS_BYPAGE,$PageSize,$PageNum,$RecCnt);
- $tbs->MergeBlock("blk1","mysql",$query);
- $tbs->PlugIn(TBS_NAVBAR,'nv','',$PageNum,$RecCnt,$PageSize);
- $tbs->Show();
- ?>
注意，代码中的解析顺序。
- 先是PlugIn(TBS_BYPAGE,$PageSize,$PageNum,$RecCnt); 确认分页的各个参数
- 再是MergeBlock("blk1","mysql",$query);合并查询的块
- 最后PlugIn(TBS_NAVBAR,'nv','',$PageNum,$RecCnt,$PageSize);解析分页链接导航。
html模板：
XML/HTML代码
- <table border="1" cellpadding="2" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
- <tr>
- <td width="33%" bgcolor="#DDDDDD"><b><font size="1" face="Verdana">No.</font></b></td>
- <td width="33%" bgcolor="#DDDDDD"><b><font size="1" face="Verdana"> Name</font></b></td>
- <td width="34%" bgcolor="#DDDDDD"><b><font size="1" face="Verdana">Title</font></b></td>
- </tr>
- <row>
- <tr>
- <td width="33%"><font size="2" face="宋体">[blk1.id;block=row]</font></td>
- <td width="33%"><font size="2" face="宋体">[blk1.name]</font></td>
- <td width="34%"><font size="2" face="宋体">[blk1.title]</font></td>
- </tr>
- </row>
- <row>
- <tr>
- <td width="33%" bgcolor="#CCCCFF"><font size="2" face="宋体">[blk1.id;block=row]</font></td>
- <td width="33%" bgcolor="#CCCCFF"><font size="2" face="宋体">[blk1.name]</font></td>
- <td width="34%" bgcolor="#CCCCFF"><font size="2" face="宋体">[blk1.title]</font></td>
- </tr>
- </row>
- </table>
- <table border="1" align="center" cellpadding="2" cellspacing="0">
- <tr align="center">
- <td width="16"><a href="[var..script_name]?PageNum=[nv.first;endpoint;magnet=a;mtype=m+m]">|<</a></td>
- <td width="16"><a href="[var..script_name]?PageNum=[nv.prev;endpoint;magnet=a;mtype=m+m]"><</a></td>
- <td width="16"><a href="[var..script_name]?PageNum=[nv.page;block=td;navsize=8;navpos=centred]">[nv.page]</a></td>
- <td width="16" bgcolor="#C4E1E1"><strong>[nv.page;block=td;currpage]</strong></td>
- <td width="16"><a href="[var..script_name]?PageNum=[nv.next;endpoint;magnet=a;mtype=m+m]">></a></td>
- <td width="16"><a href="[var..script_name]?PageNum=[nv.last;endpoint;magnet=a;mtype=m+m]">>|</a></td>
- </tr>
- </table>
mysql表
SQL代码
- CREATE TABLE `test` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(50) NOT NULL,
- `title` varchar(50) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
结果：
bypage和nabar的php文件：bypagenavbar.rar
