Laravel Eloquent: Deeper Relationships with One Query

[@chengkangzai]

This will soon be the one of the most viewed video in this channel 😂 good work

[@muditgulgulia5350]

Correct 😂

[@aboodlibda7161]

Yes I think ❤

[@dibbyo456]

Yup

[@chengkangzai]

Yes, it's me in 8 month, revisiting this video 😂

[@tiagooliveira14]

This packages should be in the framework. They're really good.

[@LaravelDaily]

Anyone can add anything to the framework, it's open-source, so you can try.

[@KgfLikia]

Ι was about to say the same.

[@user-zg1pc6md6y]

Большое спасибо) смотрю каждый день. Всегда очень полезно

[@user-ld1gz1cr1j]

Реал, не сложно говорит. Прекрасно понятно

[@ARMONEY666]

Иногда такие вещи показывает что удивляешся

[@pankajbokdia]

I cannot thank you enough! Your channel is AMAZING! Thank you for doing what you do!

[@0x0456]

This is EXACTLY what I needed to see. Thank you so much!

[@auroraapps1853]

Superb Laravel specialized developer of all the time. I like you Sir

[@philipcook6191]

Soon to by membership this month. Your way of explaining wastes no time and you to the point and so knowledgeable, been watching for year but I need to get into your full courses. Thanks for this, a super help. From cape town, south africa.

[@worthsalive]

You just earned a new subscriber. Kudos to you. You just showed me exactly what I needed to see

[@abdalkhalekchamkha3622]

you are the best ,thanks you for improving my laravel knowledge, i was do stupid things before i see this video 😅

[@levieraf]

Dude! you are awesome, so so accurate! You are a good teacher! I love your channel! Great work!

[@salman-804]

I learnt a lot from this tutorial. Thanks a lot !!

[@bilaljan7659]

that is what i was searchingfor an hour, thanks alot sir !!!

[@MahmodurRahmanShihab]

Thanks for your laravel daily tips.

[@DennisBraga]

Life saving tip. Life saving package. Congrats to both.

[@glowiever]

finally the addon is mature enough to use! nice tutorial.

[@AldhiAlbadri]

Problem solving, thanks sir!

[@aineelzihnee9634]

First time seeing video on youtube without dislike button being tick.

[@demeja16]

Очень крутое видео, спасибо за улучшение наших знаний в Laravel:)

[@maxgoose4671]

ну я хз понял ли он)

[@shahosanandaji9894]

You are the best, Povilas!

[@ChangeYourLifeForever]

by this video you can understand the principle of has_many and belongs_to in other languages and frameworks also

[@msdeav]

Really helpful video. Thank you

[@ValeriyaPolovinkina]

Thank you for this video. In real life we need in one query some fields from first level, some from second level, third, etc. But it is another story =)

[@HadiHasanpur]

Many thanks You are best in yours job ... I cannot thank you enough! Thank you teacher for your trainings!

[@KasimSheyi]

Your videos are always wonderful.

[@vigneswarans13]

Excellent explanation 🎉

[@arashpirhadi1326]

great video thanks. :) but i think in some situation like this performance will drop after 2 joins and more. I mostly using DB facade for retrieving data from database.

[@LaravelDaily]

Yes, for complex queries raw queries are still the best.

[@azeroth5672]

This is what I need!!! Thankyou so muchh for this

[@user-rm4zo1mg5o]

Something done with few lines I have to do with complex sql queries with joins, to do the same on old projects running over laravel 5.2 in my main work. Thank for this video.

[@hamzaradouan4074]

I literally needed to know this, thank you so much 💓 keep up the great work 💪

[@shaadishtiaque2084]

Your tutorials help a lot... Thanks

[@AlexTheGreatish]

This is great thank you.. Could you do a video explaining the different type of relationships and how the database structures should be set up in terms of where foreign keys are, etc?

[@LaravelDaily]

I have an article: blog.quickadminpanel.com/eloquent-relationships-the-ultimate-guide/ Also, it's best to read the docs: laravel.com/docs/8.x/eloquent-relationships

[@biplobshaha2829]

Thank you so much. It's help me a lot.💝💝

[@Dinookys]

🎉 save the day, thanks a lot

[@jeanfrancois3605]

OMG, this is amazing thank you so much!

[@vbadheli]

Thank you.. this help me a lot..

[@JamesShisiah]

This is really great. Love it

[@Trizen321]

you always provide good content

[@md.robelahammed4763]

Amazing content. It helps me a lot. Thanks

[@Matheus708]

Wow! that`s really really awesome!

[@alexandergontsov6219]

Really good job. Thanks 🙏

[@bmtamim7818]

You are awesome 😍

[@afestacincome2224]

Can you please do a Short video on how to create nested comment and also a Short video on how to retweet a post ( Just like Twitter)

[@ikarahubs965]

Retweet feature will be nice

[@niffeydovie4906]

@@ikarahubs965 nested comment please

[@cethartest469]

awesome, thanks you, please more and more advanced eloquent

[@LaravelDaily]

I have a full course about advanced eloquent: laraveldaily.teachable.com/p/laravel-eloquent-expert-level

[@MUJAHIDKHAN]

Thank sir , one of the best video

[@hostname47]

very very very helpful package thanks !

[@codepilot2766]

This is awesome bro......It will help me a lot :)

[@nbqenglishvietsubstyle117]

You are a god to me, thank you so so much

[@kreatur_]

Great, now I just need to know how to access deeper relationships with a girl

[@lucasj.pereira4912]

To talk with her dad or grandad?

[@6BEEP9]

You would be fine with just BelongsTo

[@Raftor74]

Awesome!

[@poplach]

Very informative video, thanks.

[@amrqawasmeh]

Thx for the great content

[@QianZhiwei]

very well. thank you.

[@aryarizkysandi8351]

thank you very much for tutorial sir!!

[@g3n1kindra]

this help me a lot, thanks

[@AbdulMajeedShehzad]

Thank you for the great video, I've a question for this scenario. is it a good practice to use keys in deep relations ? for example in employees table we add country_id to avoid complex queries when working on reporting. I've been looking for this answer for quite a long time

[@kauandouglas]

Up

[@javieru5871]

Feel you bro, done the same: usign foreign keys to those deep deep relationships

[@tarekalhalabi8776]

Great video💙

[@newtonsefa5721]

Thank you

[@fylzero]

The BelongsToThrough query actually became less efficient, no? It reduced the queries and models used but memory and time to execute increased.

[@gethermedel3620]

exactly, it slowed it down but it did simplify the work, so if you're application doesn't require or need the small performance difference, it's a good choice though.

[@programadorweb8403]

good work!!!

[@claudiomenares4172]

Muchas gracias 🤯

[@insider-analyst]

composer require staudenmeir/belongs-to-through:"^2.5" not installing on laravel 8

[@joshbarros1995]

This is cool!!!

[@Ayvengo21]

All the time i see that orm magic like this I'm asking myself does it worth it or maybe some escaped sql would be way easier to read and write. Because sql knowledge could be transferred between projects while knowledge of specific orm might be problematic.

[@ivan.silicin]

Thank you!

[@my_religion]

Pretty helpful!

[@rdvr]

Brilliant!

[@amgadalwattar2863]

very helpfull thanks

[@ahmedsyam]

Good job!

[@rishabhandari2501]

Helpful 🙌🖤

[@erh4rdt]

great, thank you!

[@huynguyenduyit4441]

Amazing

[@fuhfaysal]

awesome!!

[@andriusgeciauskas3154]

@Laravel Daily Sveikas Povilai, niekaip negaliu issaikinti turiu panasia problema: character->quests->objectives->tasks turiu padaryti toki dalyka paspaudus mygtuka "track quest" uzsitrakina questas kaip betkokiam zaidime sone atsiranda lentele kad zaidejas matytu questa kuri trackina. man reiketu duomenu is visus modeliu quest, objectives, tasks kurios pajungsiu ant laravel websockets kad kai zaidejas progresuoja per savo questa jie butu automatiskai updatinami. klausimas butu toks: ar tai butu imanoma padaryti su hasMany ar hasManyThrough ar belongsToMany niekaip negaliu isspresti sitos bedos reikia uzloadinti questus su objectives ir tasks

[@LaravelDaily]

Žinok trumpame komentare negaliu atsakyti, reikia žaistis ir eksperimentuoti, deja nebeturiu laiko tokiam individualiam konsultavimui. Bandyk rašyti į Laracasts forumą.

[@mostafamahfouz1139]

thanks a lot

[@GabrielMoura32]

thanks

[@chibuikeumezinwa7827]

Lovely!

[@dApoTB]

Thanks for your videos! Could you please do one about constructing relationships between tables that are in different databases and connection names to those tables cannot be hard coded. E.g.: User table is in DB1, Post table is in DB2 and Comment table is in DB3. Can we construct a relationship here? Thanks!

[@SonsParaRelaxar]

It will work the same, the only thing you will have to do is overwrite the connection variable inside of the model.

[@muditgulgulia5350]

Best video. 👌

[@achmadimanfirmansyah663]

thank you

[@berthojoris]

The best....Thanks

[@developer_sagor]

thank you very much

[@devsun9063]

Thanks 🙏

[@sir_brian_d]

6:03 the query count went down but the time & memory usage went up, less performant 🤔maybe it is not using an index

[@GergelyCsermely]

Thanks

[@jimishukurow2286]

royal like from me!

[@RANJEETKUMAR-wz4dg]

amazing thanks

[@TechITWorld]

Could you make one video of belongstomany with three level deep query with where condition (with the last one)?

[@erikgratz5539]

@ 8:00 you are showing off the functionality of `hasManyDeep` to associate employees with their countries. Could this also be achieved with an additional `hasManyThrough` definition? Where it is defined as `hasManyThrough(Employee::class, Shop::class)` ? Or do those methods not chain well / is this strictly better for performance?

[@ekselyum34]

Thanks 👏

[@ts.subramanipaiduthaly2038]

Bro, if possible all your future video please make very big fonts and alsp zoom abit because when we use phone its hard to see. It cause not complete watch

[@akintandavid2500]

Thanks for this how can i learn more about eager loading

[@martinh4982]

Hi Povilas, In Eloquent is it possible to join to an arbitrary sql statement? For example, say I have a User model and I want to create a UserStats relationship. However UserStats is not a table, but a sql statement that computes stuff like last_login, number_of_posts, up_votes etc. The only way I've found to do this so far is with a database view that I manage with migrations, but was wondering if this could be done purely in Laravel.

[@shofada]

Thanks or putting this together. If you had a page that needs to display say for every employee, the country, city and shop, what might the query look like?

[@dacpuspadewi]

Hey,, thankyou for this tutorial. and i have question related to this. so, i have 4 models which connect 4 tables : 1st model (dupak table): public function activities() { return $this->belongsToMany(Activity::class, 'activity_dupaks', 'dupak_id', 'activity_id'); } 2nd model (activities table): public function dupak() { return $this->belongsToMany(Dupak::class, 'activity_dupaks', 'activity_id', 'dupak_id'); } public function productionType() { return $this->belongsTo(ProductionType::class, 'production_type_id'); } 3rd model (production_types table): public function activities() { return $this->hasMany(Activity::class); } public function resultUnit() { return $this->belongsTo(ResultUnit::class, 'result_unit_id'); } 4th model (result_unit table): public function productionTypes() { return $this->hasMany(ProductionType::class); } the questions is, how to get data from result_unit table, from dupak table collection(->get()) ? i want to foreach the $dupaks = Dupak::where(....)->get(); in blade, and show some data from result_unit table through $dupaks foreach. i really clueless for this case. i hope you answer my question :') thankyou^^

[@gloriaordiz5924]

Please make a video about this package belongstothrough

[@LaravelDaily]

That package has a very good documentation, not sure why the video is needed

[@ugayashan8659]

Great content, can you make a video on user referral system using laravel Eloquent

[@renwar]

Very helpful video. Why laravel framework does not have these kind of relationships yet?

[@LaravelDaily]

You're free to submit pull requests to the framework and add it.

[@johnerrolprincipe8992]

Hi, I watched your video about function's return type, is there any documentation about the full list of return types? Thank you!

[@LaravelDaily]

Any PHP variable type or PHP/Laravel class could be a return type. There's no list.

[@vovkko]

This all sounds good when you have less 1k records, but when you have 2m inner join with 14m table performance will die

[@MrFxJ]

Hmm what do you suggest? Because from my POV this is the best performance you will get and if you have 2m inner join with 14m table performance will die whatever you use

[@martinjones8231]

I follow all of your video u are great because the laravel path am on is just what u can teach so I need ur personal contact.