SQL操作及分页.doc

Find
classbrandControlextendsSystemControl
$model_brand=Model();
$v=intval($v);
$brand_array=$model_brand->table('brand')->where(array('brand_id'=>$v))->find();

$condition['gname']=$_GET['gname'];
$info=Model('gadmin')->where($condition)->find();

$attr_info =$model->table('attribute')->where('attr_id='.$attr_id)->find();

$attr_value_list=$model->table('attribute_value')->where('attr_id='.$attr_id)->order('attr_value_sortasc,attr_value_idasc')->select();

$model=Model('voucher');
//查询模板信息
$param=array();
$param['voucher_t_id']=$t_id;
$t_info=$model->table('voucher_template')->where($param)->find();

$this->cm_info=Model()->table('circle_member')->where(array('circle_id'=>$this->c_id,'member_id'=>$_SESSION['member_id']))->find();

$class_info=Model()->table('circle_class')->find($this->circle_info['class_id']);
Tpl::output('class_info',$class_info);

Update

$model=Model();
//更新过期套餐的状态
$time=time();
$model->table('voucher_quota')->where(array('quota_endtime'=>array('lt',$time),'quota_state'=>"{$this->quotastate_arr['activity'][0]}"))->update(array('quota_state'=>$this->quotastate_arr['expire'][0]));

publicfunctionset($key,$value,$type='',$ttl=SESSION_EXPIRE){
$info=$this->model->where(array('pid'=>$key))->find();
if($info){
$this->model->where(array('pid'=>$key))->update(array('pvalue'=>$value,'expiretime'=>TIMESTAMP+$ttl));
}else{
$this->model->insert(array('pid'=>$key,'pvalue'=>$value,'expiretime'=>TIMESTAMP+$ttl));
}
}

/***更新信息**@paramarray$param更新数据*@returnbool布尔类型的返回结果*/publicfunctionupdate($param){if(empty($param)){returnfalse;}if(is_array($param)){$tmp=array();foreach($paramas$k=>$v){$tmp[$k]=$v;}$where="sc_id='".$param['sc_id']."'";$result=Db::update('store_class',$tmp,$where);return$result;}else{returnfalse;}}

Select
/**
*套餐管理
**/
publicfunctionquotalistOp(){
$model=Model();
//更新过期套餐的状态
$time=time();
$model->table('voucher_quota')->where(array('quota_endtime'=>array('lt',$time),'quota_state'=>"{$this->quotastate_arr['activity