yii分页
来源:互联网 发布:vb应用程序 传入参数 编辑:程序博客网 时间:2024/06/06 10:55
<?php
namespace app\models;
use yii;
use yii\base\Model;
use yii\web\UploadedFile;
//M层
/**
* UploadForm is the model behind the upload form.
*/
class Brand extends Model
{
public $table='brand';//$table 是表名
public function selectPage($p){
$size=4;
$page=($p-1)*$size;
$command = Yii::$app->db->createCommand('SELECT count(*) as num FROM '.$this->table);
$posts = $command->queryAll();
$num=$posts[0]['num'];
$end=ceil($num/$size);
$xia=$p+1>=$end?$end:$p+1;
$shang=$p-1<=1?1:$p-1;
$comm= Yii::$app->db->createCommand('SELECT * FROM '.$this->table." limit $page,$size");
$pos = $comm->queryAll();
$arr['xia']=$xia;
$arr['end']=$end;
$arr['shang']=$shang;
$data['info']=$pos;
$data['page']=$arr;
return $data;
}
namespace app\models;
use yii;
use yii\base\Model;
use yii\web\UploadedFile;
//M层
/**
* UploadForm is the model behind the upload form.
*/
class Brand extends Model
{
public $table='brand';//$table 是表名
public function selectPage($p){
$size=4;
$page=($p-1)*$size;
$command = Yii::$app->db->createCommand('SELECT count(*) as num FROM '.$this->table);
$posts = $command->queryAll();
$num=$posts[0]['num'];
$end=ceil($num/$size);
$xia=$p+1>=$end?$end:$p+1;
$shang=$p-1<=1?1:$p-1;
$comm= Yii::$app->db->createCommand('SELECT * FROM '.$this->table." limit $page,$size");
$pos = $comm->queryAll();
$arr['xia']=$xia;
$arr['end']=$end;
$arr['shang']=$shang;
$data['info']=$pos;
$data['page']=$arr;
return $data;
}
}
//C层
public function actionBrand_list(){
$p=isset($_GET['p'])?$_GET['p']:"1";
$model=new Brand;
$data=$model->selectPage($p);
return $this->render('brand_list',['info'=>$data['info'],'page'=>$data['page']]);
}
//视图层
<a href="../index.php?r=brand/brand_list&p=1">首页</a>
<a href="../index.php?r=brand/brand_list&p=<?php echo $page['shang']?>">上一页</a>
<a href="../index.php?r=brand/brand_list&p=<?php echo $page['xia']?>">下一页</a>
<a href="../index.php?r=brand/brand_list&p=<?php echo $page['end']?>">最末页</a>
阅读全文
0 0
- yii分页
- yii分页
- yii 分页
- yii分页
- YII 分页
- YII分页
- yii 分页
- Yii---分页
- yii分页
- yii 分页
- yii分页
- yii分页
- 【Yii框架】YII分页组件
- Yii 分页方法总结
- yii ajax分页
- Yii 分页方法总结
- Yii 分页方法总结
- yii CListView分页器
- Java基础部分第二十二节
- 利用Python模拟淘宝自动登录
- STL常用算法: max_element,min_element, distance以及手动实现.
- Sublime Text3 快捷键
- git上的.idea文件如何删除
- yii分页
- WorkerMan学习篇:简单多人聊天
- 滚动条
- java-反射机制
- ubuntu配置tenslflow
- Java基础部分第二十三节
- bzoj 2216 [Poi2011]Lightning Conductor 决策单调性
- Oracle:PL*Plus编程(四)
- 1108链表