Laravel Tip - Format Multilevel Categories With Single Query

Super excellent bro

So this query is not dynamic? What happens when n depth level? You assume there is certain depth because you are not using recursion???

plz name of intro music

Fantastic. That's what i'm looking for days. Thank you/

Thanks a lot from Bangladesh for this more essential video❤️

thanks a lot . it is very good.

where is jquery

Oh what the bad code.

Thanks!

can make crud example sir please this i need

If we are in a child catagory. We like to go back in parent category then how we can show ? Like i am in 4 number sub catagory.. the how i can show 4》3》2》1》0 ?

Hi, can you show the blade part of this query to show how it will be working on a navigation of a website?

great

Very much Helpful

quality!

This is very good but i have one problem in this way, like orderBy or paginate is not working in this way, if you have another way to implement paginate.

You can use nested with on your relation like this:

public function children(): HasMany
{
return $this->hasMany(Category::class, 'parent_id', 'id')->with('children');
}

public static function getThree(): array
{
return Category::whereNull('parent_id')->with('children')->get()->toArray();
}

This solution avoid the n+1 query problem. If you have 3 nested, only 3 sql requests...

Please sir, how can we get the count of each category items with their subcategories. Anyone please

Thanks nice solution!

thank you very much ... could you plz make video for showing the tree in blade :)