Level 24
Here u go.
Route::get(/category/{slug});
public function postCategory($slug)
{
$posts = Post::where('slug', $slug)->get();
return view('front.posts.category', compact('posts'));
}
Is this what you want?
Apr 16, 2017
7
Level 1
How to use category {slug} wildcard in categories table when retrieving a post by category.
I have two(2) tables;
Posts: id, title, slug, category_id, body, is_published, created_at, updated_at
Categories: id, name, slug, created_at, updated_at
And here's my Post & Category model;
Post:
public function category()
{
return $this->belongsTo(Category::class);
}
Category:
public function posts()
{
return $this->hasMany(Post::class);
}
And here's my controller to retrieve a posts by category. (But for now, I retrieve the category directly via category_id in posts table itself)
public function postCategory($id)
{
$posts = Post::where('category_id', $id)->get();
return view('front.posts.category', compact('posts'));
}
Finally my route;
Route::get('/category/{id}', 'PostController@postCategory')->name('post.category');
The question is, how can I use slug wildcard in categories table to replace the category_id I currently use.
I want my route to be like this:
Route::get(/category/{slug}); // http://example.com/category/laravel
Level 1
Thank you for your prompt reply @edoc but that doesn't solve the problem.
If you write the query like the above
$posts = Post::where('slug', $slug)->get();
It will look for the slug field in the posts table where it doesn't exist.
My category slug was in the categories table.
When I dd your above code, it returns an empty array.
Level 24
I thought it's there cause your first post says so.
$posts = Category::where('slug', $slug)->first()->posts;
Can you try this?
Level 1
Level 24
if you do this $posts = Category::where('slug', $slug)->with('posts')->get();
It returns a collection of categories with posts eager-loaded.
And if you do this $posts = Category::where('slug', $slug)->with('posts')->first();
It returns a category model with posts eager-loaded. This might be a good read for u
http://stackoverflow.com/questions/27598603/the-difference-of-find-and-get-in-eloquent
Level 1
Thanks @edoc. Your assistance in this matter is greatly appreciated.
1 like
Level 10
@larangah You could also opt for Route model binding on other keys than ID if you're interested.
The following code snippet is from the docs:
/**
* Get the route key for the model.
*
* @return string
*/
public function getRouteKeyName()
{
return 'slug';
}
https://laravel.com/docs/5.4/routing#implicit-binding
As for the 'with' part this is also possible in eloquent, there is a $with attribute in your model you can inherit and specify default relations to load
Please or to participate in this conversation.