Zend Framework使用Zend_Paginator进行数据库交互和分页

来源：互联网发布：mac大型游戏推荐编辑：程序博客网时间：2024/04/28 01:31

一、大概思路

1.1

(备注：具体配置和运行情况参考上一篇Ubuntu10.10 Zend FrameWork配置及helloworld显示)

二、创建数据库表

CREATE DATABASE IF NOT EXISTS test;USE test;DROP TABLE IF EXISTS `test`.`userinfo`;CREATE TABLE `test`.`userinfo` (`user_autoid` int(11) NOT NULL AUTO_INCREMENT,`user_name` varchar(20) NOT NULL,`user_pwd` varchar(10) NOT NULL,PRIMARY KEY (`user_autoid`)) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;INSERT INTO `test`.`userinfo` VALUES (1,'summer','123'),(2,'1/'','1'),(3,'s','s'),(4,'ups','happy'),(5,'sdfsdfsd','sfdsdf'),(6,'s/'','ssssss'),(7,'sssssss','sssssss'),(8,'swyma','summerdir'),(9,'djb','ddd'),(10,'sss','sss'),(12,'CC','112'),(13,'c1','123'),(14,'s1','234');UNLOCK TABLES;

三、创建项目zf create project pager

3.1、将application/configs/application.ini下的

phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1

resources.frontController.params.displayExceptions = 1

设置为1，Zend Framework可以提供调试错误信息的显示。

四、创建控制器、视图

4.１、indexController

<?phpclass IndexController extends Zend_Controller_Action{private $_numPerPage = 5;private $_pageRange = 5;public function init (){/* Initialize action controller here */}public function indexAction (){$parm = $this->_request->getParam('parm');if (strtolower($_SERVER['REQUEST_METHOD']) == 'post') {//取得前台得传过来的值$text = '%' . $this->_request->getPost('txt') . '%';$db = Zend_Registry::get('db');//搜索$sql = $db->quoteInto("SELECT * FROM userinfo where user_name like ? or user_pwd like ?",$text);//分页$numPerPage = $this->_numPerPage;$pageRange = $this->_pageRange;$page = $this->_request->getParam('page', 1);$offset = $numPerPage * $page;$db = new Application_Model_DbTable_UserInfo();$select = $db->getAllUserInfo($sql)->fetchAll();$paginator = Zend_Paginator::factory($select);$paginator->setCurrentPageNumber($page)->setItemCountPerPage($numPerPage)->setPageRange($pageRange);$this->view->userinfo = $paginator;$params = array('parm' => $this->_request->getPost('txt'));$this->_helper->redirector('index', 'index', null,$params);} elseif ($this->_request->getParam('parm') != "") {$text = '%' . $this->_request->getParam('parm') . '%';$db = Zend_Registry::get('db');//搜索$sql = $db->quoteInto("SELECT * FROM userinfo where user_name like ? or user_pwd like ?",$text);//分页$numPerPage = $this->_numPerPage;$pageRange = $this->_pageRange;$page = $this->_request->getParam('page', 1);$offset = $numPerPage * $page;$db = new Application_Model_DbTable_UserInfo();$select = $db->getAllUserInfo($sql)->fetchAll();$paginator = Zend_Paginator::factory($select);$paginator->setCurrentPageNumber($page)->setItemCountPerPage($numPerPage)->setPageRange($pageRange);$this->view->userinfo = $paginator;} else {$db = new Application_Model_DbTable_UserInfo();$sql = "SELECT * FROM userinfo";//分页$numPerPage = $this->_numPerPage;$pageRange = $this->_pageRange;$page = $this->_request->getParam('page', 1);$offset = $numPerPage * $page;$db = new Application_Model_DbTable_Userinfo();$select = $db->getAllUserInfo($sql)->fetchAll();$paginator = Zend_Paginator::factory($select);$paginator->setCurrentPageNumber($page)->setItemCountPerPage($numPerPage)->setPageRange($pageRange);$this->view->userinfo = $paginator;}}public function pagelistAction (){// action body}}

4.2、index.phtml视图

<!DOCTYPE unspecified PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><form name="login"action="<?phpecho $this->url(array('controller' => 'index', 'action' => 'index'));?>"method="post"><input type="text" name="txt" /><inputtype="submit" value="搜索"> <input type="button" value="刷新"onclick="location.href='<?phpecho $this->baseUrl()?>/index/index'"></form><table><tr><th>用户名</th><th>密码</th></tr><?phpforeach ($this->userinfo as $key => $value) {?><tr><td><?phpecho $value['user_name']?></td><td><?phpecho $value['user_pwd']?></td></tr><?php}?></table><?phpecho $this->paginationControl($this->userinfo, 'Sliding','/index/pagelist.phtml');?>

4.3、pagelist.phtml

<?php if($this->pageCount):?><div class="paginationControl"><?php if( isset($this->first) ):?><a href="<?php echo $this->url(array('page'=>$this->first));?>">首页</a><?php else: ?><span class="disabled">首页</span><?php endif;?><?php if( isset($this->previous) ):?><a href="<?php echo $this->url(array('page'=>$this->previous));?>">上一页</a><?php else: ?><span class="disabled">上一页</span><?php endif;?><?php foreach ($this->pagesInRange as $page):?><?php if($page !=$this->current):?><a href="<?php echo $this->url(array('page'=>$page));?>"><?php echo $page;?></a>|<?php else :?><?php echo $page;?>|<?php endif;?><?php endforeach;?><?php if(isset($this->next)):?><a href="<?php echo $this->url(array('page'=>$this->next));?>">下一页</a><?php else:?><span class="disabled" >下一页</span><?php endif;?><?php if( isset($this->last) ):?><a href="<?php echo $this->url(array('page'=>$this->last));?>">尾页</a><?php else: ?><span class="disabled">尾页</span><?php endif;?><span>第<?php echo $this->current;?>页</span><span>共<?php echo $this->pageCount;?>页</span><span>共<?php echo $this->totalItemCount;?>条</span></div><?php endif;?>

4.４、Bootstrap.php（数据库连接)

如果连接出现mysql drivers not found，请检查是否安装了php5-mysql（在ubuntu下一般没有安装），到“新立德软件中心”安装

<?phpclass Bootstrap extends Zend_Application_Bootstrap_Bootstrap{protected function _initDBConnection (){//数据库连接$params = array('host' => 'localhost', 'username' => 'root','password' => '123', 'dbname' => 'test','charset'=>'utf8');$db = Zend_Db::factory('PDO_MYSQL', $params);Zend_Db_Table::setDefaultAdapter($db);Zend_Registry::set('db', $db);}}

五、运行效果

六、总结

Zend_Paginator还算是个不错的工具，挺方便的。

运行环境：ubuntu 10.10、zend framework

七、源代码下载

源代码下载：http://files.cnblogs.com/yongfeng/pager.zip

知识共享许可协议

本作品采用知识共享署名-非商业性使用 2.5 中国大陆许可协议进行许可。