作者：mobiledu2502863807 | 来源：互联网 | 2023-08-06 14:26
1.1(备注：具体配置和运行情况参考上一篇Ubuntu10.10ZendFrameWork配置及helloworld显示)二、创建数据库表CREATEDATABASEIFNOTEX
1.1
(备注：具体配置和运行情况参考上一篇Ubuntu10.10 Zend FrameWork配置及helloworld显示)
二、创建数据库表
CREATEDATABASEIFNOTEXISTS test;
USE test;
DROPTABLEIFEXISTS `test`.`userinfo`;
CREATETABLE `test`.`userinfo` (
`user_autoid` int(11) NOTNULL AUTO_INCREMENT,
`user_name` varchar(20) NOTNULL,
`user_pwd` varchar(10) NOTNULL,
PRIMARYKEY (`user_autoid`)
) ENGINE=MyISAM AUTO_INCREMENT=15DEFAULT CHARSET=utf8;
INSERTINTO `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
php
class IndexController extends Zend_Controller_Action
{
private$_numPerPage=5;
private$_pageRange=5;
publicfunction init ()
{
/* Initialize action controller here */
}
publicfunction 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);
} else
if ($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;
}
}
publicfunction 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="echo $this->url(array('controller' => 'index', 'action' => 'index'));
?>"
method="post"><input type="text" name="txt"/><input
type="submit" value="搜索"><input type="button" value="刷新"
onclick="location.href='echo $this->baseUrl()?>/index/index'">
form>
<table>
<tr>
<th>用户名th>
<th>密 码th>
tr>
php
foreach ($this->userinfo as$key=>$value) {
?>
<tr>
<td>
php
echo$value['user_name']?>
td>
<td>
php
echo$value['user_pwd']?>
td>
tr>
php
}
?>
table>
php
echo$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="url(array('page'=>$this->first));?>">首页a>
php else: ?>
<span class="disabled">首页span>
php endif;?>
php if( isset($this->previous) ):?>
<a href="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="url(array('page'=>$page));?>">php echo $page;?>a>|
php else :?>
php echo $page;?>|
php endif;?>
php endforeach;?>
php if(isset($this->next)):?>
<a href="url(array('page'=>$this->next));?>">下一页a>
php else:?>
<span class="disabled">下一页span>
php endif;?>
php if( isset($this->last) ):?>
<a href="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下一般没有安装），到“新立德软件中心”安装
php
class Bootstrap extends Zend_Application_Bootstrap_Bootstrap
{
protectedfunction _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
七、源代码下载
源代码下载：https://files.cnblogs.com/yongfeng/pager.zip
京公网安备 11010802041100号