增删改查、搜索、分页是每个项目的基础,这些功能的实现是入门的第一步!今天总结了一下增删改查、搜索、分页!效果图如下:
下面是实现的方法:
1)建数据库表
CREATE TABLE `think_contract_stock` (
`id` BIGINT(10) NOT NULL AUTO_INCREMENT,
`contracttype` VARCHAR(50) COLLATE utf8_bin NOT NULL,
`contractname` VARCHAR(50) COLLATE utf8_bin NOT NULL,
`contractnums` INT(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MYISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
2)在Action下新建ContractStockAction.class.php控制器,代码如下:
<?php
class ContractStockAction extends Action{
//显示列表
public function index(){
$ContractStock = M('ContractStock');
import("ORG.Util.Page");// 导入分页类
$count = $ContractStock->count();// 查询满足要求的总记录数
$Page = new Page($count,4);// 实例化分页类 传入总记录数和每页显示的记录数
$show = $Page->show();// 分页显示输出
$list = $ContractStock->order('id desc')->limit($Page->firstRow.','.$Page->listRows)->select();
$this->assign('list',$list);// 赋值数据集
$this->assign('page',$show);// 赋值分页输出
$this->display();
}
//增加 首先给它一个显示的模板 然后再提交到insert插入数据
public function add(){
$this->display();
}
public function insert(){
$ContractStock = D('ContractStock');
if($ContractStock->create()){
if($ContractStock->add()){
$this->success();
}else{
$this->error();
}
}else{
$this->error($ContractStock->getError());
}
}
//删除
public function del(){
$id = (int)$_GET['id'];
$ContractStock = M('ContractStock');
if($ContractStock->delete($id)){
$this->success();
}else{
$this->error();
}
}
public function batch_del(){
$ids =