框架学习八：Model查询

 1 <?php
 2 
 3 class UserAction extends Action {
 4     public $height = 180;
 5 
 6     public function regok() {
 7 
 8         $userModel = D('User');
 9         
10         if($userModel->create() == false) {
11             echo $userModel->getError();
12             exit;
13         }
14 
15         if($userModel->add()) {
16             echo '注册成功';
17         } else {
18             echo '注册失败';
19         }
20     }
21 
22     public function userList() {
23         $userModel = D('User');
24         
25         // 所有行所有列
26         // print_r($userModel->select());
27 
28         // 指定取username,email列,所有行出来.
29         // print_r($userModel->field('username,email')->select());
30 
31         // 排除某一或几列,所有行.
32         ///print_r($userModel->field('passwd')->select());
33 
34         // 排除某一或几列,所有行.
35         // print_r($userModel->field('passwd',true)->select());
36 
37         // 根据id倒序排列
38         // print_r($userModel->order('id desc')->select());
39 
40         // 查询id>5的用户
41         // print_r($userModel->where('id>5')->select());
42         // 查询id > 5用户,并按id倒序排列
43         // print_r($userModel->where('id>5')->order('id desc')->select());
44 
45         // 查询最新的用户
46         // print_r($userModel->order('id desc')->limit(1)->select());
47 
48 
49         // 统计用户的平均年龄
50         // echo $userModel->avg('age');
51         // print_r($userModel->group('passwd')->avg(age));
52 
53         // sql语句
54         // $sql = 'select avg(age) from user group by passwd';
55         // $list = $userModel->query($sql);
56 
57         // sql语句
58         $list = $userModel->order('id desc')->field('passwd',true)->select();
59 
60         
61 
62         // TP模板的赋值
63         $this->assign('title','今天阴天闷热');
64 
65         // TP模板赋数组
66         $this->assign('info',array('username'=>'张三','age'=>22));
67 
68         // TP模板赋对象
69         $this->assign('me',$this);
70         
71         // 赋一个多维数组
72         $this->assign('list',$list);
73         $this->assign('abc',$list);
74         
75 
76         $this->display();
77     }
78 
79 }