Member Since 2 Years Ago
4,820 experience to go until the next level!
In case you were wondering, you earn Laracasts experience when you:
Earned once you have completed your first Laracasts lesson.
Earned once you have earned your first 1000 experience points.
Earned when you have been with Laracasts for 1 year.
Earned when you have been with Laracasts for 2 years.
Earned when you have been with Laracasts for 3 years.
Earned when you have been with Laracasts for 4 years.
Earned when you have been with Laracasts for 5 years.
Earned when at least one Laracasts series has been fully completed.
Earned after your first post on the Laracasts forum.
Earned once 100 Laracasts lessons have been completed.
Earned once you receive your first "Best Reply" award on the Laracasts forum.
Earned if you are a paying Laracasts subscriber.
Earned if you have a lifetime subscription to Laracasts.
Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.
Earned once you have achieved 500 forum replies.
Earned once your experience points passes 100,000.
Earned once your experience points hits 10,000.
Earned once 1000 Laracasts lessons have been completed.
Earned once your "Best Reply" award count is 100 or more.
Earned once your experience points passes 1 million.
Earned once your experience points ranks in the top 50 of all Laracasts users.
@martinbean i did all and it almost work.
athlete view i can retrieve all athletes, with each company they play in and sport_id from the pivot table.
Now, sport_id is the link to access to the sport table where i have the name of the sport. I tried and retried a lot of tutorials but I understood i'm doing something wrong because i cannot find a way to access to the name of the sport.
Into Athlete Controller, for index function I do:
$athlete = Athlete::with('teams')->get()
teams function is the same you suggested to me before, with
Do you have a suggestion?
Thanks for suggestion. i've already tried some models and no one worked as hoped. That's why i asked here after 1 month of try. I also searched for examples online but all of them provide standard models for that type of relationship while my situation, as you see above, foresees (according to my idea) a non-standard model linked to the type of subjects involved.
I think the keystone here is: an athlete can play a specific sport only for a specific team.
John cannot play soccer with team A and also team B.
So i suppose this model should be good
Thanks @martinbean . Will I also be able to see, starting from the team view, which athletes play for it and in which sports?
Hello David, could it be something like this:
Thanks David. Can you give me some more hints, considering my current Model is this: https://pasteboard.co/InkfW9h.png ?
Started a new Conversation Doubt On How To Define Model For Team-Athletes-Sports Relationsships
Hello i'm trying to define a good Model to manage Teams, athletes and practiced sports. Here is the situation: One team can have multiple athletes and an athlete can play in different teams. So i setup a Many to Many relationship
An athlete can play different sports and a sport can be played by different athletes. So i setup a Many to Many relationship
This was easy.
Now the doubt:
Andrew plays soccer for the "A" Team
Andrew plays tennis for the "B" Team
John plays soccer for the "A" Team
John plays basket for the "C" Team
With the first relationships i'm not able to understand what team Andrew play soccer with.
So , can you help me on how defining the relationship between tables to manage that type of information? I am also available to modify the first three relationships between Team Sports Athletes tables