实用小技能thinkphp文章增删改查

神秘码农

<?php
namespace Itc\Controller;
use Think\Controller;
class ArticleController extends CommonController {

public function article_list(){
    $article=D('article');
    
    //查询方法
    $where=1;
    if($kw=I('kw')){
        $where.=' ADN title LIKE "%'.$kw.'%" ';
    }
    
    //栏目查询
    
    if($cateid=I('cateid')){
        $where.=' ADN cateid =' .$cateid;
    }
    
    
    //分页的制作
    $count= $article->where($where)->count();// 查询满足要求的总记录数
    $Page= new \Think\Page($count,6);// 实例化分页类 传入总记录数和每页显示的记录数(25)
    $Page->setConfig('prev','上一页');
    $Page->setConfig('next','下一页');
    $show= $Page->show();// 分页显示输出
    // 进行分页数据查询 注意limit方法的参数要使用Page类的属性
    $list = $article->field('a.title,a.author,a.pic,a.rem,a.id,b.catename')->alias('a')->join('LEFT JOIN it_cate b ON a.cateid=b.id')->order('id desc')->limit($Page->firstRow.','.$Page->listRows)->where($where)->select();
    $this->assign('list',$list);// 赋值数据集
    $this->assign('page',$show);// 赋值分页输出
    $cate=D('cate');
    $cateres=$cate->catetree();
    $this->assign('cateres',$cateres);//分配出去
    $this->display();
}


public function article_del($id){

    $article = D('article');//实例化一个对象，把实例化好的对象赋值给$column
    //echo $id; die;//打印出来是不是删除当前的这个栏目id
    if($article->delete($id)){
         
        $this->success('删除成功',U(article_list),0);
         
    }else{
        $this->error('删除失败！');
    }
}
    
//添加
public function article_add(){
    $article=D('article');
    if(IS_POST){
      $data['title'] = I('title');//标题
        $data['author'] = I('author');//作者
        $data['keywords'] =I('keywords');//关键字
        $data['des'] = I('des');//描述
        $data['content'] = I('content');//内容
        $data['rem'] = I('rem');//推荐
        $data['cateid'] = I('cateid');//
        $data['time'] = date("Y-m-d");//时间
        if($_FILES['pic']['tmp_name'] !=''){
            $upload = new \Think\Upload();// 实例化上传类
            $upload->maxSize=3145728 ;// 设置附件上传大小
            $upload->exts=array('jpg', 'gif', 'png', 'jpeg');// 设置附件上传类型
            $upload->rootPath='./';
            $upload->savePath='./Public/Uploads/'; // 设置附件上传目录
            $info=$upload->uploadOne($_FILES['pic']);
            if(!$info) {// 上传错误提示错误信息
                $this->error($upload->getError());
            }else{// 上传成功 获取上传文件信息
                $data['pic']=$info['savepath'].$info['savename'];
            }   
        }
    if($article->create($data)){
            if($article->add($date)){
                $this->success('文章添加成功',U('article_list'),0);
            }else{
                $this->error('文章添加失败');
            }
        }else{
            $this->error($article->getError());
        }
        return ;
    }
    $cate=D('cate');
    $cateres=$cate->catetree();
    $this->assign('cateres',$cateres);//分配出去
    $this->display();
}

//文章修改
public function article_edit($id){
$article=D('article');
if(IS_POST){
$data['id'] = I('id');//标题
$data['title'] = I('title');//标题
$data['author'] = I('author');//作者
$data['keywords'] =I('keywords');//关键字
$data['des'] = I('des');//描述
$data['content'] = I('content');//内容
$data['rem'] = I('rem');//推荐
$data['cateid'] = I('cateid');//
$data['time'] = time();//时间
if($_FILES['pic']['tmp_name'] !=''){
$upload = new \Think\Upload();// 实例化上传类
$upload->maxSize=3145728 ;// 设置附件上传大小
$upload->exts=array('jpg', 'gif', 'png', 'jpeg');// 设置附件上传类型
$upload->rootPath='./';
$upload->savePath='./Public/Uploads/'; // 设置附件上传目录
$info=$upload->uploadOne($_FILES['pic']);
if(!$info) {// 上传错误提示错误信息
$this->error($upload->getError());
}else{// 上传成功 获取上传文件信息
$data['pic']=$info['savepath'].$info['savename'];
}
}
if($article->create($data)){
if($article->save($date)){
$this->success('文章编辑成功',U('article_list'),0);
}else{
$this->error('文章编辑失败');
}
}else{
$this->error($article->getError());
}
return ;
}
$id=I('id');
$articles=$article->find($id);
$this->assign('articles',$articles);
$cate=D('cate');
$cateres=$cate->catetree();
$this->assign('cateres',$cateres);//分配出去
$this->display();
}
}
?>