Laravel Tip - Format Multilevel Categories With Single Query

[@eatsfunk]

Just discovered this channel. What a gift!

[@awaidus]

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

[@itcforyou]

Thanks!

[@Laratips]

Thank you so much Mohamed for your support :)

[@md.anwarhossain1179]

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

[@unlavab]

This is awesome!! Thanks mate

[@Z0dlk]

Amazing video bro ty for share the knowledge .♥

[@mahbubhasan5905]

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 ?

[@cultureofnepal2024]

Very useful tips bro. 👍👍👍

[@julienSibille]

Wow really useful ! Many thanks !

[@nishanthanr605]

Very much Helpful

[@aboozark6307]

thanks a lot . it is very good.

[@opahprincewill4103]

Thank you bro,. great tutorial. can on easily perform crud on these category?

[@Laratips]

Yes, its not that difficult

[@learnwithhabiburrahman]

Super excellent bro

[@programar-tk6tb]

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

[@Laratips]

Yes, soon

[@programar-tk6tb]

@@Laratips thank you you are the best :)

[@donatusbrainokwe4350]

@@Laratips Thanks please, soon 😊

[@programar-tk6tb]

@@Laratips :)

[@programar-tk6tb]

@@Laratips hi Boss

[@irfanakram]

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.

[@Laratips]

Yes, I agree. For that you can use the first method with recursive relation. I have made a video about that before this one.

[@GergelyCsermely]

Thanks nice solution!

[@Laratips]

You're welcome!

[@davidsonzed]

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

[@Laratips]

I have created this video about showing it in blade part: kzbin.info/www/bejne/qpbafZeGl8aSa8k

[@relicverse]

plz name of intro music

[@debjit21]

Please share the blade function/ CRUD example.

[@meetvaghasia6653]

Amazing...🔥🔥 Can you make one more video for shown this categories in front end side with pagination with orderBy name in each categories and their subcategory of available A AA AAA AAAA AAB AB AC B C D.... Like that... I am able to show this like tree structure without pagination, but how to do with pagination?

[@cdma2723]

How to add products_count foreach category level

[@Laratips]

When getting all the categories in the beginning, you can add withCount(["products"]) in the query. For this to work you need to have products relation method defined in the category model.

[@cdma2723]

@@Laratips how to get sum of products_count in parent level

[@donatusbrainokwe4350]

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

[@Laratips]

Yes, you have to write withCount("children") when getting the categories in the begining in the query builder. Then you will be able to get the children count.

[@robyortega6147]

can make crud example sir please this i need

[@Laratips]

You can check this video from my e-commerce series. I have done crud here. You will get nice idea from this video. kzbin.info/www/bejne/m3naeqtmjal4i8k

[@ColantAlan]

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...

[@Laratips]

Thanks for the comment. I have already made a video about that as well. This video is 2nd part of that video.

[@ciprianserban]

How can this be accessed in blade ?

[@ColantAlan]

@@ciprianserban You can use Model::getThree(); or Model::find(id)->children->children->children->...

[@hammadmohd8336]

where is jquery

[@turkialharbi9234]

how to get all ids of children using find method not get ? example: $cat = Category::Find( $id ); and then get all children ids of this category

[@Laratips]

You can do $cat->children()->pluck("id")

[@turkialharbi9234]

@@Laratips it didn't work it will get one level of children can you tell how to do that with the same example in this video

[@MetriWahyudi]

when we have millions of categories, it will be long processing. need more efficient algorithm. maybe add "path" column

[@Laratips]

Yes, it's impractical to get all the records if there are millions of categories. Can you explain a little bit more on it? How can we benefit from the "path" column?

[@MetriWahyudi]

@@Laratips | id | name | path | parent_id ___________________________________________________ | 1 | cat A | null | null | 2 | cat B | 1/ | 1 | 3 | cat C | 1/2/ | 2 | 4 | cat D | 1/2/3/ | 3 | 5 | cat E | 1/2/ | 2 when you want to retrieve id=1 with all its descendants: SELECT * FROM table WHERE id = 1 or path regxp '(1\/)'; laravel way: $result = DB::table('table')->where('id',1)-orWhere('path','regexp','(1\/)')->get(); then convert the $result to tree structure like what you made in this video. using all() is very heavy when dealing with lot of data.

[@stojankukrika7242]

Can you make some gist or something it will be much useful then write from the video ;)

[@Laratips]

I forgot to add the link of the github repo in the description. Here it is github.com/Laratipsofficial/tips-and-tricks/tree/multilevel-category-with-one-query

[@VinayakSoni98]

thanks

[@aidarark5558]

quality!

[@bugszone6098]

great

[@Tekel-Upharsin]

I'm so used to seeing crap tech tutorials on KZbin by people with Asian accents that I almost immediately closed this. I'm glad I didn't. I was being prejudice without realizing, and for that I apologize.

[@Laratips]

You don't have to apologize for this. Also glad that you liked the video. And also I am very happy that I became the one who made you change your mind on this 😉. I just want to bring what I have learned (from basic to advanced) to all people who want to learn.

[@mohamadcheaib]

Why you dont use eloquent relation hasMany and repeat the relation instead of function recursive. Try: public function children() { return $this→hasMany(Category::class, "parent_id")→with(["children"=› function($query){ return $query-›with("children"); }]) } Thats it! Few lines

[@Laratips]

I have already made a video related to that. Here's the link: kzbin.info/www/bejne/aHe8lGWCbLeIhas But the problem with this is that, if we have 4 levels of categories, it will make 5 queries.

[@nickamenthomson8874]

Performance issue if N - 1 number of queries for N numbers of children

[@ArshKhan-te9sz]

How to create three categories in this like category ->sub Category ->sub child category -> services/product

[@محمدفرج-ث7ذ3د]

Oh what the bad code.

[@Laratips]

Thanks for the feedback. Can you plz send me good code for this?

[@SEOng-gs7lj]

i think you have many subqueries, so it is technically not a single query... use MPTT for a single query

[@vladimirbudkin1872]

Look at code better. He gets all records at first, then uses collection.

[@SEOng-gs7lj]

@@vladimirbudkin1872 ic... ok thanks!

[@xmaxh]

very poor, very slow and consumes too many resources, not functional