框架学习八：Model查询

<?php

class UserAction extends Action {
    public $height = 180;

    public function regok() {

        $userModel = D('User');
        
        if($userModel->create() == false) {
            echo $userModel->getError();
            exit;
        }

        if($userModel->add()) {
            echo '注册成功';
        } else {
            echo '注册失败';
        }
    }

    public function userList() {
        $userModel = D('User');
        
        // 所有行所有列
        // print_r($userModel->select());

        // 指定取username,email列,所有行出来.
        // print_r($userModel->field('username,email')->select());

        // 排除某一或几列,所有行.
        ///print_r($userModel->field('passwd')->select());

        // 排除某一或几列,所有行.
        // print_r($userModel->field('passwd',true)->select());

        // 根据id倒序排列
        // print_r($userModel->order('id desc')->select());

        // 查询id>5的用户
        // print_r($userModel->where('id>5')->select());
        // 查询id > 5用户,并按id倒序排列
        // print_r($userModel->where('id>5')->order('id desc')->select());

        // 查询最新的用户
        // print_r($userModel->order('id desc')->limit(1)->select());


        // 统计用户的平均年龄
        // echo $userModel->avg('age');
        // print_r($userModel->group('passwd')->avg(age));

        // sql语句
        // $sql = 'select avg(age) from user group by passwd';
        // $list = $userModel->query($sql);

        // sql语句
        $list = $userModel->order('id desc')->field('passwd',true)->select();

        

        // TP模板的赋值
        $this->assign('title','今天阴天闷热');

        // TP模板赋数组
        $this->assign('info',array('username'=>'张三','age'=>22));

        // TP模板赋对象
        $this->assign('me',$this);
        
        // 赋一个多维数组
        $this->assign('list',$list);
        $this->assign('abc',$list);
        

        $this->display();
    }

}