douyuan1049 2014-11-24 20:04
浏览 50
已采纳

无法让Laravel的关系工作,新手

I started learning 2 days ago. I have made a simple user login and blog posting system.

Here is my code that will fetch all the blog posts, but should also join the tables together

public function index()
{
    $blog = new Blog;

    $view = View::make('blogs.index');
    $view->posts = $blog->get()->user;

    return $view;
}

Is this right? Looking at documentation and searching, it seems to be right but I keep getting the following error:

Undefined property: Illuminate\Database\Eloquent\Collection::$user

My blog table is structed like this: enter image description here

And user table like so enter image description here

Blog Model

class Blog extends Eloquent {

    public function user()
    {
        return $this->belongsTo('User', 'user_id', 'id');
    }
}

User Model

class User extends Eloquent implements UserInterface, RemindableInterface {

    use UserTrait, RemindableTrait;

    /**
     * The database table used by the model.
     *
     * @var string
     */
    protected $table = 'users';

    /**
     * The attributes excluded from the model's JSON form.
     *
     * @var array
     */
    protected $hidden = array('password', 'remember_token');


    public function blog()
    {
        return $this->hasMany('Blog', 'id', 'user_id');
    }
}
  • 写回答

2条回答 默认 最新

  • dongnuochen9449 2014-11-24 20:19
    关注

    In your index() function try this

    public function index()
    {
         $posts = Blog::all();
    
         return View::make('blogs.index', array('posts' => $posts));
    }
    

    And then in blogs.index you can access the relationship by (blade)

    {{ $posts->user->id }}, {{ $posts->user->email }} or any column in your DB

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错
  • ¥15 Matlab编程问题
  • ¥15 训练的多模态特征融合模型准确度很低怎么办
  • ¥15 kylin启动报错log4j类冲突
  • ¥15 超声波模块测距控制点灯,灯的闪烁很不稳定,经过调试发现测的距离偏大
  • ¥15 import arcpy出现importing _arcgisscripting 找不到相关程序
  • ¥15 onvif+openssl,vs2022编译openssl64
  • ¥15 iOS 自定义输入法-第三方输入法
  • ¥15 很想要一个很好的答案或提示