cakephp的分页排序

栏目: php语言 / 发布于: / 人气:7.72K

在PHP学习过程中你是否感到困惑?以下是本站小编精心为大家整理的PHP教程，希望对大家有所帮助!更多内容请关注应届毕业生网!

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

1 数据表

123456789 CREATETABLEIFNOTEXISTS`users`(`id`int(11)NOTNULLAUTO_INCREMENT,`firstname`varchar(32)NOTNULL,`lastname`varchar(32)NOTNULL,`email`varchar(32)NOTNULL,`username`varchar(32)NOTNULL,`password`varchar(32)NOTNULL,PRIMARYKEY(`id`))

2 在app/models/ 中,代码为:

1234	`<?phpclassUserextendsAppModel{var$name='User';?>`

3 app/controllers/users_中

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

4 页面模版文件中

app/views/users/view_

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273 <?phpecho"<pclass='page-title'>Users</p>";//title//this'addnewuser'buttonwillbeusedforthenexttutorialecho"<pstyle='float:right;'>";$url="add/";echo$form->button('AddNewUser',array('onclick'=>"='".$this->Html->url($url)."'"));echo"</p>";echo"<pstyle='clear:both;'></p>";if(sizeOf($users)>0){//checkifthereareuserrecordsreturned?><table><tr><thstyle='text-align:left;'><?phpecho$paginator->sort('Firstname','firstname');?></th><th><?phpecho$paginator->sort('Lastname','lastname');?></th><th><?phpecho$paginator->sort('Email','email');?></th><th><?phpecho$paginator->sort('Username','username');?></th><th>Action</th></tr><tr><?phpforeach($usersas$user){//wewilloopthroughtherecordstoDISPLAYDATAecho"<tr>";echo"<td>";echo"{$user['User']['firstname']}";echo"</td>";echo"<td>{$user['User']['lastname']}</td>";echo"<td>{$user['User']['email']}</td>";echo"<td>{$user['User']['username']}</td>";echo"<tdstyle='text-align:center;'>";//'Edit'and'Delete'linkherewillbeusedforournexttutorialsecho$html->link('Edit',array('action'=>'edit/'.$user['User']['id']),null,null);echo"/";echo$html->link('Delete',array('action'=>'delete/'.$user['User']['id']),null,'Areyousureyouwanttodeletethisrecord?');echo"</td>";echo"</tr>";}?></tr></table><?php//分页开始echo"<pclass='paging'>";//第一页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"</p>";}else{//iftherearenorecordsfound,displaythisecho"<pclass='no-records-found'>NoUsersfound.</p>";}?>

Tags：cakephp 分页