ThinkPHP3.1 CURD实例

<?php
//www.ios100.com ios100-知识库 分享代码
class IndexAction extends Action {
    public function index(){
	$this->show('<style type="text/css">*{ padding: 0; margin: 0; } div{ padding: 4px 48px;} body{ background: #fff; font-family: "微软雅黑"; color: #333;} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.8em; font-size: 36px }</style><div style="padding: 24px 48px;"> <h1>:)</h1><p>欢迎使用 <b>ThinkPHP</b>！</p></div><script type="text/javascript" src="http://tajs.qq.com/stats?sId=9347272" charset="UTF-8"></script>','utf-8');
    }
	public function insert(){
		$User=M('User');
		$data['uid']='';
		$data['uname']='admin5';
		$data['password']=md5('123456');
		$User->data($data)->add();
		echo $User->getlastSql();
	}
	public function select(){
		$User=M('User');
		$list=$User->order('uid desc')->limit(5)->select();
		echo '<pre>';
		print_r($list);
		echo '</pre>';
	}
	public function find(){
		$User=M('User');
		$list=$User->find();
		echo '<pre>';
		print_r($list);
		echo '</pre>';
	}
	public function getField(){
		$User=M('User');
		$uname=$User->where('uid=1')->getField('uname');
		//echo $uname;
		$this->assign('uname',$uname);
		$this->display();
	}
	public function getField_list(){
		$User=M('User');
		$list=$User->getField('uid,uname,password');
		echo '<pre>';
		print_r($list);
		echo '</pre>';
	}
	public function save(){
		$User=M('User');
		$data['uname']='ThinkPHP';
		$data['password']=md5('654321');
		$User->where('uid=1')->save($data);
	}
	public function setField(){
		$User=M('User');
		$User->where('uid=1')->setField('uname','yii');
	}
	public function setField_arr(){
		$User=M('User');
		$data=array('uname'=>'ci','password'=>md5('123456'));
		$User->where('uid=1')->setField($data);
	}
	public function setDec(){
		$User=M('User');
		$User->where('uid=1')->setDec('score',10);
	}
	Public function setInc(){
		$User=M('User');
		$User->where('uid=1')->setInc('score',10);
	}
	Public function delete(){
		$User=M('User');
		$User->where('uid=6')->delete();
	}
}