目录
目录
新手模式
用上次的查询结果,作为本次的查询条件
//关联查询
public function actionRelatesearch(){
//新手模式
$category = Category::findOne(2); //查分类表里的数据 abj
$categoryarr = $category->attributes; //获取某一行的分类结果里的对象属性,array
dump($categoryarr);
//查文章里的cid等于2的 拿上面的结果 $categoryarr['cid']=2 作为本次查询的条件
$article = Article::find()->asArray()->where(['cid'=>$categoryarr['cid']])->all();
dump($article); //返回的是二维数组arr
}
结果:
Array
(
[cid] => 2
[c_name] => 娱乐
)
Array
(
[0] => Array
(
[article_id] => 6
[article_title] => php的发展前景怎样
[num] => 8
[cid] => 2
)
[1] => Array
(
[article_id] => 7
[article_title] => 67岁宋春丽与聂远出新戏，满头花发让人心疼，面容慈祥豪爽依旧！
[num] => 12
[cid] => 2
)
[2] => Array
(
[article_id] => 8
[article_title] => 知微又涨粉啦！《天盛长歌》小衣衣、楚王和金狮王子你会选谁？
[num] => 18
[cid] => 2
)
[3] => Array
(
[article_id] => 9
[article_title] => 刘亦菲穿旗袍带仙气，赵丽颖穿旗袍优雅，她穿旗袍最有民国范
[num] => 14
[cid] => 2
)
)
hasMany关联模式查询
思路
1.用category表里查一行,查出某一个分类下的所有字段 结果是一维数组下的值是obj
2.查出来的结果,用hasMany()去关联查询article表里的关联字段cate_id查询出属于该分类下的所有数据,用all()方法查多行
新建mode层Article.php
<?php
namespace app\models;
use yii\db\ActiveRecord;
class Article extends ActiveRecord
{
}
新建mode层Category.php
<?php
namespace app\models;
use yii\db\ActiveRecord;
class Category extends ActiveRecord
{
}
新建控制器HomeController.php
public function actionRelatesearch(){
//关联查询
//查询方法一(查一行) 一维数组下的值是obj
// $category = Category::findOne(1); //查分类表里的数据 abj
//// vp($category);
// $articles = $category->hasMany(Article::className(),['cate_id'=>'cid'])->asArray()->all();
// dd($articles);
//查询方法二(查多行,结果需要提出一行来使用):
//查分类表里的数据要是一维数组下的值是obj 不能用asArray()转为数组,不然hasMany会报错
$category = Category::find()->where(['cid'=>2])->all();
vp($category);
//关联查询 用hasMany方法前提要满足二个条件
//1.如果查出来是二维数组需要用角标提成一维数组
//2.主表category 表查出来的结果要是一维数组下的值是obj 不能用asArray转成数组
//第一个参数是string article的命名空间app/models/Article == Article::className()
vp(Article::className()); //打印结果app/models/Article
//第二个参数是array key是article表里的关联字段 value是category里的主键
$articles = $category[0]->hasMany(Article::className(),['cate_id'=>'cid'])->asArray()->all();
dd($articles);
}
打印结果
D:\xampp\htdocs\yii\helper\function.php:19:
array (size=1)
0 =>
object(app\models\Category)[78]
private '_attributes' (yii\db\BaseActiveRecord) =>
array (size=2)
'cid' => string '2' (length=1)
'c_name' => string '娱乐' (length=6)
private '_oldAttributes' (yii\db\BaseActiveRecord) =>
array (size=2)
'cid' => string '2' (length=1)
'c_name' => string '娱乐' (length=6)
private '_related' (yii\db\BaseActiveRecord) =>
array (size=0)
empty
private '_relationsDependencies' (yii\db\BaseActiveRecord) =>
array (size=0)
empty
private '_errors' (yii\base\Model) => null
private '_validators' (yii\base\Model) => null
private '_scenario' (yii\base\Model) => string 'default' (length=7)
private '_events' (yii\base\Component) =>
array (size=0)
empty
private '_eventWildcards' (yii\base\Component) =>
array (size=0)
empty
private '_behaviors' (yii\base\Component) =>
array (size=0)
empty
D:\xampp\htdocs\yii\helper\function.php:19:string 'app\models\Article' (length=18)
D:\xampp\htdocs\yii\helper\function.php:26:
array (size=4)
0 =>
array (size=4)
'article_id' => string '6' (length=1)
'article_title' => string 'php的发展前景怎样' (length=24)
'num' => string '8' (length=1)
'cate_id' => string '2' (length=1)
1 =>
array (size=4)
'article_id' => string '7' (length=1)
'article_title' => string '67岁宋春丽与聂远出新戏，满头花发让人心疼，面容慈祥豪爽依旧！' (length=89)
'num' => string '12' (length=2)
'cate_id' => string '2' (length=1)
2 =>
array (size=4)
'article_id' => string '8' (length=1)
'article_title' => string '知微又涨粉啦！《天盛长歌》小衣衣、楚王和金狮王子你会选谁？' (length=87)
'num' => string '18' (length=2)
'cate_id' => string '2' (length=1)
3 =>
array (size=4)
'article_id' => string '9' (length=1)
'article_title' => string '刘亦菲穿旗袍带仙气，赵丽颖穿旗袍优雅，她穿旗袍最有民国范' (length=84)
'num' => string '14' (length=2)
'cate_id' => string '2' (length=1)