Laravel - Comparing a database value with a variable

Question

I have a basic appointment system set up, however everybody logged in can see all appointments, so what I'm trying to do is make it so users can only see their appointments. To do this I'm trying to get the logged in users Id then display all the appointments that have this user_id value (Appointments is a junction table)

I know my code is probably awful but any help is appreciated, thanks

function index()
    {
        $logged_user_id = Auth::user()->id;
        $user = User::find($logged_user_id);

        $appointments = Appointment::where('user_id', '=' $user)->get();

        return view ('appointment/userappointments',['appointments' => $appointments]);
//      $appointments = Appointment::all();
    }

You should read about relations in the (Laravel documentation)[laravel.com/docs/5.4/eloquent-relationships]. Then you could do auth()->user()->appointments — mazedlx
– mazedlx, Commented Apr 28, 2017 at 19:13

Jeff · Accepted Answer · 2017-04-28 19:12:16Z

3

Set up your model relations and you can just do this

function index()
{
    $appointments = Auth::user()->appointments;
    return view ('appointment/userappointments',['appointments' => $appointments]);
}

answered Apr 28, 2017 at 19:12

Jeff

25.3k4 gold badges73 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

manian · Accepted Answer · 2017-04-28 19:14:51Z

0

You already have the user id, dont have to fetch User info.

function index()
{
    $logged_user_id = Auth::user()->id;
    $appointments = Appointment::where('user_id', '=' $logged_user_id)->get();

    return view ('appointment/userappointments',['appointments' => $appointments]);
    //$appointments = Appointment::all();
}

answered Apr 28, 2017 at 19:14

manian

1,4482 gold badges18 silver badges34 bronze badges

Collectives™ on Stack Overflow

Laravel - Comparing a database value with a variable

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related