Laravel Database Query Error

Question

I`m new to the laravel 5.4 and um developing trainee management system.what i need is when i press see details button on right side green color.all the datas under the that Trainee id need to be shown.see the image,

for an example if i want to see ID MOB/TR/1739.i need to press see details on right side.hope you got it.in additionally here is the database related to that.

Here is i developed controller for that.

public function user_details($traninee_id)
{
    $trainee_details= registerdetails::where('traninee_id','=',$traninee_id)->get()->first();
     return view('registeredusers.seedetails', compact('trainee_details'));
}

Here is the error um getting.

Can anyone suggest me the suggestions to complete it?

Please show the route you're trying to use and how do you generate link to this route. — Alexey Mezenin
– Alexey Mezenin, Commented Jun 17, 2017 at 15:53
Route::get('Seedetails', 'UserRegisterController@user_details'); — Dasun
– Dasun, Commented Jun 17, 2017 at 15:54
Try this: Route::get('Seedetails/{id}', 'UserRegisterController@user_details'); — Zayn Ali
– Zayn Ali, Commented Jun 17, 2017 at 15:55

Zayn Ali · Accepted Answer · 2017-06-17 16:27:13Z

1

You're not passing the traninee_id in your route so to fix this update your route to this

Route::get('Seedetails/{id}', 'UserRegisterController@user_details');

And assuming that you're using $traninee to display the content of table so update your See Here button with this

<a href="Seedetails/{{ $traninee->traninee_id }}">See Here</a>

edited Jun 17, 2017 at 16:27

answered Jun 17, 2017 at 16:18

Zayn Ali

4,9351 gold badge32 silver badges41 bronze badges

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

3 Comments

Dasun Over a year ago

Sir i change the code but it give error again route error.that means route is not going to work

Zayn Ali Over a year ago

@Dasun please show me your seedetails.blade.php and also which error?

Dasun Over a year ago

Sir i`m place it as a new question rather than editing this question.i ll mention you their.

Alexey Mezenin · Accepted Answer · 2017-06-17 15:58:35Z

0

The error says there is a problem with the route you use. So add an ID to the route:

Route::get('Seedetails/{traineeId}', 'UserRegisterController@user_details');

And pass the ID when you create a link to this route:

url('Seedetails/'.$traineeId)

answered Jun 17, 2017 at 15:58

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

4 Comments

Dasun Over a year ago

Sir i change the route but i dont understand how to create a link passing ID.can you please explain bit?

Alexey Mezenin Over a year ago

@Dasun I've shown how in my answer (the url() helper). You also can name your route and use route() helper like <a href="{{ route('your.route.name', ['traineeId' => $traineeId]) }}"></a>

Dasun Over a year ago

sir as um new to laravel i didnt get what you are saying.sorry

Alexey Mezenin Over a year ago

Then you should really read the routing docs laravel.com/docs/5.4/routing

Collectives™ on Stack Overflow

Laravel Database Query Error

2 Answers 2

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related