How to show post using another column than ID

$post = Post::where('post_id', $id)->first();

@topvillas Sorry i updated my question. Anchor was not showing before. I removed "" from href. Theres the original question now.

It's probably something to do with model binding.

Show us your route and controller.

Here is my controller:

public function displayAll(){

        $posts = Post::all()->where('user_id', '=', Auth::user()->id);

        return view('/user-dashboard/post/all-post', compact('posts'));


    }

Here is the route:

Route::get('/dashboard/posts/show/{post_id}', 'UserPostController@show')->name('post.show');

and the above question is blade.

On show method i am simply returning a testing string for now.

The signature of the show method is important, please show us it,

This is the show method:

public function show($id)
    {
        return view('/user-dashboard/post/show');
    }

Hmm!

You need to pass an array as the second parameter of the route helper.

route(route('post.show', ['id' => $post->post_id])

Sorry but is it suppose to be like this?

route(route('post.show', ['id' => $post->post_id])

['id' -> $post->post_id] to ['id' => $post->post_id]

Because it is giving me error on that part and also closing bracket

You can figure out the syntax. The important part is passing an array as the second parameter.

Route [http://test.io/dashboard/posts/show] not defined

Why so?

Updated version:

<a href="{{route(route('post.show', ['id' => $post->post_id]))}}">{{$post->name}}</a>

I just want to know why its displaying when i give the id on the url. but it does not work when i give post_id on url. why is that

Just out of curiosity why do you have a post_id and an id on post? What is the difference?

They both are uuid

I want the id to be able to update post and post_id to show a post

I'm still confused, why do you need two ids? The method you're using shouldn't make any difference, both should identify the post by the same field. It sounds like you're over complicating things because there's something you're not quite understanding.

Anyway, maybe this will help.

https://medium.com/@steveazz/setting-up-uuids-in-laravel-5-552412db2088

I want to show the post using post_id because if i show the post using uuid, a user might copy the uuid and go to inspect element and paste it on the form action and update some other post. If this is not the right way to achieve this, could you please suggest the right method.

The UUID is accessible on the client either way.

You can make things much simpler by checking if the logged in user is the owner of the resource when they try and update it.

How to achieve this? Could you link me to the right direction

In your update method check the logged in user vs the post owner. For example if your post has a user_id you could do something like this

if( Auth::user()->id === $post->user_id ) {
 //Do your update code here
} else {
  //Return some error here
}

Will this prevent from updating using the inspect element action? I mean if someone goes to inspect element and change the /{uuid} to some other posts uuid which does not belong to that user?

Yes, because they won't own the post, this is done in the update method, how that method gets the data, even if they just sent a direct post request makes no difference.

Thanks this is exactly what i needed