cakephp的分页排序-php教程-PHP中文网

cakephp中的分页还是很简单的,下面例子复习下

1 数据表

CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `firstname` varchar(32) NOT NULL, `lastname` varchar(32) NOT NULL, `email` varchar(32) NOT NULL, `username` varchar(32) NOT NULL, `password` varchar(32) NOT NULL, PRIMARY KEY (`id`) )

登录后复制

2 在app/models/user.php 中,代码为:

登录后复制

3 app/controllers/users_controller.php中

function view_users(){ $this->paginate = array( 'limit' => 2 ); //users用于在前端页面中显示 $this->set('users', $this->paginate('User')); }

登录后复制

4 页面模版文件中
app/views/users/view_users.ctp

Users

"; //title //this 'add new user' button will be used for the next tutorial echo "

"; $url = "add/"; echo $form->button('Add New User', array('onclick' => "location.href='".$this->Html->url($url)."'")); echo "

"; echo "

"; if( sizeOf( $users ) > 0 ){ //check if there are user records returned ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

sort('Firstname', 'firstname'); ?>	sort('Lastname', 'lastname'); ?>	sort('Email', 'email'); ?>	sort('Username', 'username'); ?>	Action
"; echo "{$user['User']['firstname']}"; echo "	{$user['User']['lastname']}	{$user['User']['email']}	{$user['User']['username']}	"; //'Edit' and 'Delete' link here will be used for our next tutorials echo $html->link('Edit', array('action'=>'edit/'.$user['User']['id']), null, null); echo " / "; echo $html->link('Delete', array('action'=>'delete/'.$user['User']['id']), null, 'Are you sure you want to delete this record?'); echo "

"; //第一页 echo $paginator->first('First'); echo " "; //前一页 if($paginator->hasPrev()){ echo $paginator->prev('<<'); } echo " "; //指定页数 echo $paginator->numbers(array('modulus' => 2)); echo " "; if($paginator->hasNext()){ echo $paginator->next('>>'); } echo " "; //最后一页 echo $paginator->last('Last'); echo "