您好,欢迎访问一九零五行业门户网

YII数据库查询

$usermodel = user::model(); $usermodel-count(); $usermodel-count($condition); $usermodel-count($condition, $params); $usermodel-countbyattributes($attributes); $usermodel-countbyattributes($attributes, $condition); $usermodel-countbyattrib
$usermodel = user::model();
$usermodel->count(); $usermodel->count($condition); $usermodel->count($condition, $params); $usermodel->countbyattributes($attributes); $usermodel->countbyattributes($attributes, $condition); $usermodel->countbyattributes($attributes, $condition, $params); $usermodel->countbysql($sql); $usermodel->countbysql($sql, $params); // $usermodel = user::model(); $usermodel->find(); $usermodel->find($condition); $usermodel->find($condition, $params); $usermodel->findbypk($pk); $usermodel->findbypk($pk, $condition); $usermodel->findbypk($pk, $condition, $params); $usermodel->findbyattributes($attributes); $usermodel->findbyattributes($attributes, $usermodel); $usermodel->findbyattributes($attributes, $usermodel, $params); $usermodel->findbysql($sql); $usermodel->findbysql($sql, $params); //返回值为对象数组,若为空则返回null,为一条记录 $findresult = $usermodel->find('islock = :islock and phone_status=:phone_status',array(':islock' => 1,':phone_status'=>1)); echo $findresult -> phone_status.
; var_dump($findresult->attributes); if($usermodel->find('user_id=260')){ echo 'find'; }else{ echo 'no find'; }
参数解释:上面均返回一条记录 如果要返回多条数据findall类似的
$condition 是一般sql里面where子句,一个字符窜
$params 是一个数组,为占位符赋值
查询出来所有数据:
$userinfo= $usermodel->findallbyattributes(array('islock'=>1,'phone_status' => 0)); foreach($userinfo as $k => $v){ echo $v->user_id. . $userinfo[$k][user_id].
; }
可见,结果是一个二维数组。
讲cdbcriteria和model对象进行结合
$criteria = new cdbcriteria; if($condition) $criteria->condition = $condition; $criteria->offset = $offset; if($order) $criteria->order = $order; if($limit!=all) $criteria->limit = $limit; if(!empty($more_criteria)){ $criteria->mergewith($more_criteria); } $model = new $modelname; if(!empty($with_array)){ $result = $model->with($with_array)->findallbyattributes($attributes,$criteria); }else{ $result = $model->findallbyattributes($attributes,$criteria); }
其它类似信息

推荐信息