关联查询一致报错，不得已来sf麻烦各位大神帮我解答。
报错内容
errorexception in 777fb9d9b961f2b2453d93297ba8a847 line 15:trying to get property of non-object (view: /home/millyn/www/x.x/resources/views/newhome.blade.php)

我的对应文件如下
avatar.php
hasmany('app\article'); }}

article.php
belongsto('app\avatar'); }}

controller.php
public function index() { $articles = article::with('avatar')->latest()->paginate(8); return view('newhome', compact('articles')); }

newhome.blade.php
@foreach ($articles as $page) title }} href=%7b%7b%20url('news/'.%24page->id)%20%7d%7d> {{ $page->title }}
title }} href=%7b%7b%20url('news/'.%24page->id)%20%7d%7d>avatars_id->url%7d%7d alt= width=180px>
@endforeach
{!!$articles->render()!!}


article_table.php
public function up() { schema::create('articles', function(blueprint $table) { $table->increments('id'); $table->string('title'); $table->text('body')->nullable(); $table->string('site')->nullable(); $table->integer('avatars_id')->unsigned();; $table->integer('user_id'); $table->string('nike')->nullable(); $table->timestamps(); $table->foreign('avatars_id') ->references('id') ->on('avatars') ->ondelete('cascade'); }); }

avatars_table.php
public function up() { schema::create('avatars', function(blueprint $table) { $table->increments('id'); $table->string('title'); $table->string('url'); $table->text('path'); $table->timestamps(); }); }

我不知道是哪里有问题,不管怎么弄都是报错..希望大神帮忙看看.谢谢了.
回复内容： 关联查询一致报错，不得已来sf麻烦各位大神帮我解答。
报错内容
errorexception in 777fb9d9b961f2b2453d93297ba8a847 line 15:trying to get property of non-object (view: /home/millyn/www/x.x/resources/views/newhome.blade.php)

我的对应文件如下
avatar.php
hasmany('app\article'); }}

article.php
belongsto('app\avatar'); }}

controller.php
public function index() { $articles = article::with('avatar')->latest()->paginate(8); return view('newhome', compact('articles')); }

newhome.blade.php
@foreach ($articles as $page) title }} href=%7b%7b%20url('news/'.%24page->id)%20%7d%7d> {{ $page->title }}
title }} href=%7b%7b%20url('news/'.%24page->id)%20%7d%7d>avatars_id->url%7d%7d alt= width=180px>
@endforeach
{!!$articles->render()!!}


article_table.php
public function up() { schema::create('articles', function(blueprint $table) { $table->increments('id'); $table->string('title'); $table->text('body')->nullable(); $table->string('site')->nullable(); $table->integer('avatars_id')->unsigned();; $table->integer('user_id'); $table->string('nike')->nullable(); $table->timestamps(); $table->foreign('avatars_id') ->references('id') ->on('avatars') ->ondelete('cascade'); }); }

avatars_table.php
public function up() { schema::create('avatars', function(blueprint $table) { $table->increments('id'); $table->string('title'); $table->string('url'); $table->text('path'); $table->timestamps(); }); }

我不知道是哪里有问题,不管怎么弄都是报错..希望大神帮忙看看.谢谢了.
php//打印下你查询的sql语句看看 public function article() { return $this -> hasmany('app\avatar','id','avatars_id'); } public function avatar() { return $this -> belongsto('app\app\article','avatars_id','id'); }
你可以dd($articles)来看看，相信在relations这一个上面会是null，总感觉你的relationship声明好奇怪
看第15行输出的是哪个变量，然后dd打印变量，根据问题再逐步排解。
应该是你的调用关联用错了
avatars_id->url%7d%7d alt= width=180px>
这里应该用
{{$page->avatar->url}}
因为你这里用的是
$articles = article::with('avatar')->latest()->paginate(8);
如果你要改变映射的名字，需要
$articles = article::with(array('avatars_id'=>function(){/*映射的关系*/}))->latest()->paginate(8);
这之后你要改变很多
谢谢各位的答案,但我是最后自己解决的.
我的解决方案和我挑选的答案是一个方法.
我在
acticle.php里把内容改成了
public function avatar() { return $this -> belongsto('app\avatar','avatars_id'); }
就行了,关于关联到模板上面的内容是
{{$page->avatar->url}
模型 关联方法 对应字段
非常感谢各位,我也贴出正确解决我问题的方法.
希望可以给以后遇到此类问题的朋友一个解决方案.
其实你只要一路跟 convention 走乖乖地建表就用 avatar_id 就不会出这些问题了。
另外建议你 hasmany() 关系的时候也用复数
public function articles() { return $this->hasmany('app\article');}
这样写的时候自己也清楚了~