phptp框架 基本操作

//model================里面增删查改================<?phpnamespaceHome\Controller;useThink\Controller;classGoodsControlleextendsController{//商品列表functionshowlist(){//使用GoodsModel//实例化普通model对象$goods=new\Model\GoodsModel;//命名空间实例化对象var_dump($goods);//实例化父类model对象$model=D();var_dump($model);//用于执行原生sql语句普通model也可以//实例化父类model对象，同时操作指定的数据表$goods=D('goods');//实例化父类model对象，操作goods表var_dump($goods);//数据查询操作$goods=new\Model\GoodsModel();//查询所有数据$info=$goods->select();//根据主键id查询$info=$goods->select(9);//主键id值在某个范围$info=$goods->select("20,23,25,59");//输出查询信息//show_bug($info);//dump($info);=================把获得的信息传递给模板使用==========$this->assign('info',$info);$goods=D('goods');//where使用//$goods->where('goods_price>1000andgoods_namelike"ok%"');//$info=$goods->select();//filed()限制查询的字段//$goods->filed('goodid,goods_name');//$info=$goods->select();//limit(数字) 限制查询的条数//limit(偏移量，长度)偏移量=（页码-1）*长度，分页效果//$goods->limit(5,5);//$info=$goods->select();//order(=orderbyc//$info=$good->select();//group分组查询//$good->gruop('goods_id');//$good->filed('goods_id,max(goods_price)');//$info=$good->select();//dump($info);//having()havigwhere方法可以设置查询条件//where//having条:件字段必须是"结果集”存在的字段$goods->having('goods_price>1000');$info=$good->select();$this->display();==============连贯操作数据库==============$info=$good->filed('goods_name')->where('goods_price>1000')->limit(10)->select();$good->order('goods_pricedesc');=================数据添加操作====================数组方式$数组=array（元素（元素（）AR$model->属性（字段）=值；$model->add()一个model模型类与一个数据表对应model模型类实例化的对象对应一条记录model对象的属性与记录的字段对应//====================$goods=new\Model\GoodsModel();//操作goods数据表的对象//数据修改save()必须设置条件，主键id或者where$arr=array('goods_id'=166;'goods_name'=>'samsung6S','goods_price'=>5600,'goods_weight'=>130,);dump($z);//AR方式$goods->goods_name="asd";$goods->goods_price="54";$z=$goods->save();dump($z);$this->display();}functiontianjia(){$this->display();}functionxiugai(){$this->display();}}?>=====================添加数据=============================functiontianjia(){//数据添加，数组方式$goods=new\Model\GoodsModel();//操作goods数据表的对象//收集HTML里面的数据,展示表单if(!empt($_POST)){$Z=$goods->add($_POST);//收集表单信息，写入数据库if($z){//跳转页面$this->redirect('showlist',array('name'=>'tom','age'=>21),3,添加商品成功);}else{$this->redirect('showlist',,3,添加商品失败);}}else{$this->display();}====================修改数据=================================修改按<ahref="{$smarty.const. CONTROLLER }/xiugai/goos_id/{$v.goods_id}">修改</a>functionxiugai($goods_id){$goods=D('Goods');//获取数据表if(!empty($_POST)){$z=$goods->save($_POST);if($z){//跳转页面$this->redirect('showlist',array(),3,'修改商品成功');}else{$this->redirect('xuigai',array('goods_id'=>$goods_id),3,'修改商品失败');}}else{//根据$goods_id获得被修改的信息，给模板展示//find()方法只负责返回一条记录结果$info=$goods->find($goods_id);$this->diaplay();}}