十、 模型创建及数据读取

1. 新建模型文件 /model/Article.php

<?php
namespace app\models;
use \yii\db\ActiveRecord;

class Article extends ActiveRecord{

}

2. 控制器中使用

//加载模型
use app\model\Article;
......2,

//使用模模型查询数据
$sql = "select * from article where id=1";
$res = Article::findBySql($sql)->all();
//占位符查询,防sql注入
$sql = "select * from article where id=:id";
$res = Article::findBySql($sql,[":id"=>1])->all();
//获取全部数据
$data = Article::find()->all();
//获取单条数据
$data = Article::find()->where(['id'=>1])->all();
//获取》3的数据
$data = Article::find()->wehre(['>','id',3])->all();
//获取5>=id>=2 的数据
$data = Article::find()->where(['between','id',2,5])->all();
//获取 title 含有 上晴下雪
$data = Article::find()->where(['like','title','上晴下雪'])-》all();

//快速查询一条数据,主键为4
$dataOne = Article::findOne(4);
//查询主键为3，5，6 的数据
$dataOne = Article::findAll([3,5,6]);