can't access variable in view from controller laravel

Question

I can't access $prospectus in the function show() but works well in the function store() in laravel version 5.6.27

public function store(Request $request) {

    $course = Course::create([
        'name' => $request['name'],
        'title' => $request['title'],
        'division_id' => $request['division_id'],
    ]);

    $prospectus = Prospectus::create([
        'years' => $request['years'],
        'name' => $course->name,
        'user_id' => null,
        'course_id' => $course->id,
    ]); 

    return view('courses.show', compact('course', 'prospectus'));
}

public function show(Course $course) {
    $prospectus = Prospectus::where('course_id', $course->id)->get();

    //return $prospectus;
    return view('courses.show', compact('course', 'prospectus'));
}

the data is passed when i use return $prospectus; but not in return view('courses.show', compact('course', 'prospectus'));

here are my routes

Route::resource('courses', 'CourseController');

Route::post('courses', 'CourseController@store')->name('courses.store');

Route::get('courses/{course}', 'CourseController@show')->name('courses.show');

i think your $prospectus is null, try to dd($prospectus); in show method; or return view('courses.show', ['course' => $course, '' => 'prospectus' => $prospectus]); — J. Doe
– J. Doe, Commented Jul 19, 2018 at 13:58
Do you get an error in your view? What exactly seems to be the problem? — Jerodev
– Jerodev, Commented Jul 19, 2018 at 14:00
$prospectus isn't null, data is returned with return $prospectus — Carloericksonrodrigo Brazil Va
– Carloericksonrodrigo Brazil Va, Commented Jul 19, 2018 at 14:05
i get an error Property [years] does not exist on this collection instance with {{ $prospectus->years }} — Carloericksonrodrigo Brazil Va
– Carloericksonrodrigo Brazil Va, Commented Jul 19, 2018 at 14:07

Jerodev · Accepted Answer · 2018-07-19 14:01:16Z

1

I supose you want a single Prospectus object, get() will give you a collection of objects.

Use the first() function to get only the first match from the database as a single object.

$prospectus = Prospectus::where('course_id', $course->id)->first();

answered Jul 19, 2018 at 14:01

Jerodev

33.3k11 gold badges96 silver badges113 bronze badges

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

Comments

dqureshiumar · Accepted Answer · 2021-04-12 06:13:22Z

0

Confirm that $prospectus query don't return NULL

Try this:

$prospectus = Prospectus::where('course_id', $course->id)->first();

edited Apr 12, 2021 at 6:13

dqureshiumar

9681 gold badge8 silver badges20 bronze badges

answered Jul 19, 2018 at 14:00

Thiago Natanael

1716 bronze badges

1 Comment

Carloericksonrodrigo Brazil Va Over a year ago

Worked well! Thank you!

Collectives™ on Stack Overflow

can't access variable in view from controller laravel

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related