Laravel 模型关系:一对多
一对多:一篇文章可以有多个评论,一个评论只属于一篇文章
表结构
# articles: id, title, content
# comments: id, content, article_id
模型配置
// App\Article
第一个参数是关联模型的类名,第二个参数是关联模型类所属表的外键第三个参数是关联表的外键关联到当前模型所属表的哪个字段,
public function comments(){
return $this->hasMany('App\Comment');
}
// App\Comment
//其中第一个参数是关联模型的类名。第二个参数是当前模型类所属表的外键,//第三个参数是关联模型类所属表的主键:
public function article(){
return $this->belongsTo('App\Article');
}
使用
增
$article = App\Article::find(1);
$article->comments()->create(['content' => '上海在哪儿']);
删
$article = AppArticle::find(1);
$article->comments()->delete();
改
$comment = App\Comment::find(11);
$article = App\Article::find(1);
$comment->article()->associate($article);
$comment->save();
$comment = App\Comment::find(1);
$comment->article()->update(['title' => '广州在哪儿']);
查
$comments = App\Article::find(1)->comments;
$comments = App\Article::find(1)->comments()->where('content', 'like', '%教学%')->get();
$article = App\Comment::find(1)->article;
// 延迟加载
App\Ariticle::with('comments')->find([1,2])
http://onlinecasinouse.com/# online slot games http://onlinecasinouse.com/# - play online casino online casino gambling