Retrieving data from junction table via foreign key - Laravel

Question

I'm trying to get data from a junction table and display it, so I have a users table and my junction table prescription_user. Prescription_user table has a user_id and prescription_id.

So what I'm trying to do is on this userdetails page, show all of this users prescriptions and access the prescription name and description etc, however when I try any of this I get "Trying to get property of non-object"

The models are set up to eager load correctly I think, the user model has a hasMany relation with the prescription_user model, and the prescription_user model has a belongsTo the user model.

Controller

function viewUserDetails($userId)
    {
        $logged_user_id = Auth::user()->id;
        $user = User::find($logged_user_id);
        $prescriptions = Auth::user()->prescription_user;

        $fullname = $user->firstname ." ". $user->surname;
        $email = $user->email;
        $address = $user->address;
        $postcode = $user->postcode;
        $dob = $user->dateofbirth;
        $uniquepatientnumber = $user->uniquepatientnumber;





        $data = [];
        $data['fullname'] = $fullname;
        $data['email'] = $email;
        $data['address'] = $address;
        $data['postcode'] = $postcode;
        $data['dateofbirth'] = $dob;
        $data['uniquenumber'] = $uniquepatientnumber;
        $data['prescriptions'] = $prescriptions;


        return view('user/userdetails')->withData($data);`

userdetails blade

@extends('layouts.master')
@section('title', 'My Details')
@section('content')
<h1>My Details </h1>
<ul>


<li>Name: {{ $data['fullname'] }}</li>
<li>Email: {{ $data['email'] }}</li>
<li>Address: {{ $data['address'] }}</li>
<li>Postcode: {{ $data['postcode'] }}</li>
<li>Date of Birth: {{ $data['dateofbirth'] }}</li>
<li>Your Unique number is: {{ $data['uniquenumber'] }}</li>


<li>Your are currently prescribed {{$data['prescriptions']}}</li>

<p>Note: If you believe any of these are incorrect please contact a receptionist</p>

</ul>



@endsection``

EddyTheDove EddyTheDove · Accepted Answer · 2017-04-29T18:03:18

There are some design flaws in what you have explained. You have a User model and a Prescription model. That means prescription_user is your pivot table (not junction table). If so far I'm correct, it means User and Prescription have a Many to many relationship. To prove my point, you said

Prescription_user table has a user_id and prescription_id.

That means prescription_user is the pivot table.

In your user model, define a many to many relationship with prescription. And vice versa.

User model

public function prescriptions() {
    return $this->belongsToMany(Prescription::class, 'prescription_user', 'user_id', 'prescription_id');
}

Then you can change your controller function like this

public function viewUserDetails()
{
    $user = Auth::user();
    $prescriptions = $user->prescriptions;

    return view('user/userdetails', compact('user', 'prescriptions'));
}

And your view

@extends('layouts.master')
@section('title', 'My Details')
@section('content')
    <h1>My Details </h1>

    <ul>
        <li>Name: {{ $user->firstname }} {{ $user->surname }}</li>
        <li>Email: {{ $user->email }}</li>
        <li>Address: {{ $user->address }}</li>
        <li>Postcode: {{ $user->postcode }}</li>
        <li>Date of Birth: {{ $user->dateofbirth }}</li>
        <li>Your Unique number is: {{ $user->uniquepatientnumber }}</li>
    </ul>

    Your are currently prescribed
    <ul>
        @foreach($prescriptions as $prescription)
            <li>{{ $prescription->name }}
        @endforeach
    </ul>

    <p>Note: If you believe any of these are incorrect please contact a receptionist</p>

@endsection

Your code would be neater and working great

Update

Getting data from the pivot table is relatively simple. Define those columns in the relationship

public function prescriptions() {
    return $this->belongsToMany(Prescription::class, 'prescription_user', 'user_id', 'prescription_id')->withPivot('column1', 'column2');
}

In your view, you display it like this

{{ $prescription->pivot->column1 }} {{ $prescription->pivot->column2 }}

Retrieving data from junction table via foreign key - Laravel

2 Answers