site/application/index/controller/Index.php

<?php
namespace app\index\controller;


class Index extends Base
{

    public function index()//主页
    {
        $articles =db('article')
                ->alias('a')
                ->field('a.*,b.catename')
                ->join('column b','a.column_id=b.id')
                ->paginate(20);//文章表
        $this->assign([
            'articles'=>$articles,
        ]);

        return view();

    }

     public function articlelb()//列表页
    {
        //接收当前栏目别名
        $columnid = input('al');
        //查询当前栏目名称
        $cates=db('column')->where('alias',$columnid)->find();
        //查询当前栏目下的文章
        $articleres=db('article')
            ->alias('a')
            ->field('a.*,b.catename')
            ->join('column b','a.column_id=b.id')
            ->where('column_id',$cates['id'])
            ->paginate(20);
        $this->assign([
            'articleres'=>$articleres,
            'cates'=>$cates,
        ]);

        return view();

    }


     public function articlexq()//文章详情页
    {
        $arid=input();
        $articles=db('article')
            ->alias('a')
            ->field('a.*,b.catename,b.alias')
            ->join('column b','a.column_id=b.id')
            ->find($arid);
        db('article')->where('id','=',$articles['id'])->setInc('click');
        $cates=db('column')->find($articles['column_id']);
        $recres=db('article')->where(array('column_id'=>$cates['id'],'state'=>0))->limit(8)->select();

        $this->assign(array(
            'articles'=>$articles,
            'cates'=>$cates,
            'recres'=>$recres,
        ));
        return view();
    }








    
        
        
}