Yii学习笔记二

一些sql查询的方法：

$infos=$model->findAll("goods_name like :name and goods_price>:price",array(':name'=>'诺%',':price'=>500));


$infos=$model->findAll(
	[
		'select'=>'goods_name,goods_price',
		'condition'=>'goods_name like "诺%"',
		'order'=>'goods_price desc',
		'limit'=>3,
		'offset'=>6
	];
);

中间类 CDbCriteria.php
//通过criteria 实现信息查询

$criteria=new CDbCriteria();

$criteria->select='goods_name,goods_price';
$criteria->order="goods_price";
$infos=$model->findAll($criteria);

$requres=\Yii::$app->requres();
$id=$requres->get('id',1);
<?=Html::encode($user->name)?>
<?=HtmlPurifier::process($post->text)?>

echo \yii\helpers\Html::encode($str);

<?php
uses \yii\helpers\Html;
use \yii\helpers\HtmlPurifier;
?>

<?=Html::encode($str);?>
<?=Html::Purifier::process($str);?>

return $this->render('index');
return $this->renderPatial('index',$data);


select * from article where id=1;drop table user;
$sql="select * from article where id=:id"
$r=Article::findBySql($sql,[':id'=>$id])->all();

foreach(Article::find()->batch(2) as $article){
	$data[]=$article;
}

添加数据

$article=new Article();
$article->title="sdfsfsd";
$article->num=2;

$data=$article->save();  //insert
$id=$article->attributes['id'];  添加数据库的id

修改数据

$artile=Article::findOne(10);
$article->title="手动阀手动阀";
$data=$article->update(); //save

修改某个字段
$data=Article::updateAllCounters(['num'=>1],['id'=>8]);

//删除
$article=Article::findOne(11);
$data=$article->delete();

删除所有
Article::deleteAll();

$data=Article::deleteAll('id>:id',[':id'=>12]);
$data=Artile::deleteAll('id>:id and num<:num',[':id'=>13,':num'=>100]);

关联模型

$category=Category::findOne();
$articles=Artile::find()->where(['cate_id'=>$category->attributes['id']])->all();

//方法2
$article=$category->hasMany('\app\models\Article',['cate_id'=>'id'])->all()
$article=$category->hasMany(Article::className,['cate_id'=>'id'])->all()

定义模型
class Category extends ActiveRecord{
	public function getArticles(){
		$articles=$this->hasMany(Article::className(),['cate_id'=>'id'])->all();
		return $articles;
	}
}


$category->articles;



一对一模型

class Article extends ActiveRecord{
	public function getCategory(){
		$category=$this->hasOne(Category::className(),['id'=>'cate_id'])->asArray();
		return $category;
	}

}

$article=new Article();
$category=$article->category;

$article=Article::find()->with('category')->asArray()->all();