php+smarty分页原理与分页代码分享

3. include_once("smarty.class.php");

4. class smartyproject extendssmarty
5. {
6. function __construct()
7. {

8. $this->config_dir="smarty/smarty/config_file.class.php";

9. $this->caching=false;
10. $this->template_dir = "smarty/templates/";
11. $this->cache_dir = "smarty/smarty_cache/";
12. $this->left_delimiter = "{";
13. $this->right_delimiter = "}";
14. }
15. }
16. ?>

2，adodb，连接数据库类：

2. class conndb
3. {
4. var $dbtype;
5. var $host;
6. var $user;
7. var $pwd;
8. var $dbname;
9. var $debug;//false不显示侦错信息，反之，显示
10. var $conn;
11. function __construct($dbtype,$host,$user,$pwd,$dbname,$debug=false)
12. {
13. $this->dbtype = $dbtype;
14. $this->host = $host;
15. $this->user = $user;
16. $this->pwd = $pwd;
17. $this->dbname = $dbname;
18. $this->debug = $debug;
19. }
20. //实现数据库的连接并返回连接对象(个人理解可以说返回adodb对象)
21. function getconnid()
22. {
23. include_once('adodb5/adodb.inc.php');
24. if($this->dbtype == "mysql" || $this->dbtype == "mssql")
25. {
26. if($this->dbtype == "mysql")
27. {
28. $this->conn = newadoconnection("mysql");//创建adodb对象，声明数据库类型为mysql
29. }
30. else
31. {
32. $this->conn = newadoconnection("mssql");
33. }
34. $this->conn->connect($this->host,$this->user,$this->pwd,$this->dbname);
36. }
37. else if($this->dbtype == "access")
38. {
39. $this->conn = newadoconnection("access");
40. $this->conn->connect("driver={microsoft access driver (*.mdb)};dbq=".$this->dbname.";uid=".$this->user.";pwd=".$this->pwd.";");
41. }
43. $this->conn->execute("set names utf-8");
45. if($this->dbtype == "mysql")
46. {
47. $this->conn->debug = $this->debug;
48. }
49. return $this->conn;
51. }
52. function closeconnid()//关闭与数据库的连接
53. {
54. $this->conn->disconnection();
55. }
56. }

3，数据库操作类：

2. class admindb
3. {
4. var $sqlstr;
5. var $conn;
6. var $sqltype;
7. var $rs;
8. var $array;
9. function execsql($sqlstr,$conn)
10. {
11. $rs = $conn->execute($sqlstr);
12. $sqltype = strtolower(substr(trim($sqlstr),0,6)); //strtolower() 函数把字符串转换为小写。
13. if($sqltype = "select")
14. {
15. $array = $rs->getrows(); // 类似mysql_fetch_array函数返回的数组
16. if(count($array) == 0 || $rs == false)
17. {
18. return false;
19. }
20. else
21. {
22. return $array;
23. }
24. }
25. else if($sqltype = "update"||$sqltype = "insert"||$sqltype = "delete")
26. {
27. if($rs)
28. {
29. return true;
30. }
31. else
32. {
33. return false;
34. }
35. }
36. }
37. }

4，分页类：

3. class seppage

4. {
5. var $rs;
6. var $pagesize;
7. var $nowpage;
8. var $array;
9. var $conn;
10. var $sqlstr;
11. function showdate($sqlstr,$conn,$pagesize,$nowpage)
12. {
13. if(!isset($nowpage)||$nowpage=="")
14. {
15. $nowpage = 1 ;
16. }
17. else
18. {
19. $this->nowpage = $nowpage;
20. }
21. $this->pagesize = $pagesize;
22. $this->conn = $conn;
23. $this->sqlstr = $sqlstr;
24. $this->rs = $this->conn->pageexecute($this->sqlstr,$this->pagesize,$this->nowpage);
25. //pageexecute($sql, $nrows, $page, $inputarr=false) 使用资料集的页码功能，叁数 $page 是以 1 为启使值
26. $this->array = $this->rs->getrows();
27. if(count($this->array) == 0 || $this->rs == false)
28. {
29. return false;
30. }
31. else
32. {
33. return $this->array;
34. }
36. }

37. function showpage($contentname,$utits,$anothersearchstr,$class)

38. {

39. $allrs=$this->conn->execute($this->sqlstr);

40. $record=count($allrs->getrows());
41. $pagecount=ceil($record/$this->pagesize);

43. $str.="共有".$contentname." ".$record." ".$utits." 每页显示 ".$this->pagesize." ".$utits." 第 ".$this->rs->absolutepage()." 页/共 ".$pagecount." 页";

44. $str.=" ";

45. if(!$this->rs->atfirstpage())

46. {
47. $str.="首页";
48. }
49. else
50. {
51. $str.="首页";
52. }
53. $str.=" ";

54. if(!$this->rs->atfirstpage())

55. {
56. $str.="rs->absolutepage()-1).$anothersearchstr." class=".$class.">上一页";
57. }
58. else
59. {
60. $str.="上一页";
61. }
62. $str.=" ";

63. if(!$this->rs->atlastpage())

64. {
65. $str.="rs->absolutepage()+1).$anothersearchstr." class=".$class.">下一页";
66. }
67. else
68. {
69. $str.="下一页";
70. }
71. $str.=" ";

73. if(!$this->rs->atlastpage())

74. {
75. $str.="尾页";
76. }
77. else
78. {
79. $str.="尾页";
80. }
81. if(count($this->array)==0 || $this->rs==false)
82. {
83. return "";
84. }
85. else
86. {
87. return $str;
88. }
89. }
90. }

5，文章字符转换处理的类：

3. class usefun

4. {
6. function unhtml($text)
7. {
8. $content=(nl2br(htmlspecialchars($text)));//htmlspecialchars() 函数把一些预定义的字符转换为 html 实体,nl2br() 函数在字符串中的每个新行 (/n) 之前插入 html 换行符 (
   )。

9. $content=str_replace("[strong]","",$content);

10. $content=str_replace("[/strong]","",$content);
11. $content=str_replace("[em]","",$content);
12. $content=str_replace("[/em]","",$content);
13. $content=str_replace("[u]","",$content);
14. $content=str_replace("[/u]","",$content);
17. $content=str_replace("[font color=#ff0000]","",$content);
18. $content=str_replace("[font color=#00ff00]","",$content);
19. $content=str_replace("[font color=#0000ff]","",$content);
21. $content=str_replace("[font face=楷体_gb2312]","",$content);
22. $content=str_replace("[font face=宋体]","",$content);
23. $content=str_replace("[font face=隶书]","",$content);
24. $content=str_replace("[/font]","",$content);
25. //$content=str_replace(chr(32)," ",$content);
26. $content=str_replace("[font size=1]","",$content);
27. $content=str_replace("[font size=2]","",$content);
28. $content=str_replace("[font size=3]","",$content);
29. $content=str_replace("[font size=4]","",$content);
30. $content=str_replace("[font size=5]","",$content);
31. $content=str_replace("[font size=6]","",$content);

32. $content=str_replace("[fieldset][legend]","

    ",$content);

    $content=str_replace("[/legend]","",$content);

    $content=str_replace("[/fieldset]","
    ",$content);
33. return $content;
34. }
35. }