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 }