Hachimaki

Hachimaki

Member Since 1 Year Ago

Experience Points 180
Experience Level 1

4,820 experience to go until the next level!

In case you were wondering, you earn Laracasts experience when you:

  • Complete a lesson — 100pts
  • Create a forum thread — 50pts
  • Reply to a thread — 10pts
  • Leave a reply that is liked — 50pts
  • Receive a "Best Reply" award — 500pts
Lessons Completed 0
Lessons
Completed
Best Reply Awards 0
Best Reply
Awards
  • start-engines Created with Sketch.

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • first-thousand Created with Sketch.

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • 1-year Created with Sketch.

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • 2-years Created with Sketch.

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • 3-years Created with Sketch.

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • 4-years Created with Sketch.

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • 5-years Created with Sketch.

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • school-session Created with Sketch.

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • welcome-newcomer Created with Sketch.

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • full-time-student Created with Sketch.

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • pay-it-forward Created with Sketch.

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • subscriber-token Created with Sketch.

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • lifer-token Created with Sketch.

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • lara-evanghelist Created with Sketch.

    Laracasts Evangelist

    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.

  • chatty-cathy Created with Sketch.

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • lara-veteran Created with Sketch.

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • 10k-strong Created with Sketch.

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • lara-master Created with Sketch.

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • laracasts-tutor Created with Sketch.

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • laracasts-sensei Created with Sketch.

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • top-50 Created with Sketch.

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

13 Jul
1 week ago

Hachimaki left a reply on Doubt On How To Define Model For Team-Athletes-Sports Relationsships

@martinbean i did all and it almost work.

Starting from 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()

The teams function is the same you suggested to me before, with withPivot .

Do you have a suggestion?

Thanks

12 Jul
1 week ago

Hachimaki left a reply on Doubt On How To Define Model For Team-Athletes-Sports Relationsships

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.

Hachimaki left a reply on Doubt On How To Define Model For Team-Athletes-Sports Relationsships

@martinbean @mstrauss unfortunately no. A team can play more sports with more athetes.

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

https://pasteboard.co/InwJ3dI.png

11 Jul
1 week ago

Hachimaki left a reply on Doubt On How To Define Model For Team-Athletes-Sports Relationsships

Thanks @martinbean . Will I also be able to see, starting from the team view, which athletes play for it and in which sports?

10 Jul
1 week ago

Hachimaki left a reply on Doubt On How To Define Model For Team-Athletes-Sports Relationsships

Thanks David. Can you give me some more hints, considering my current Model is this: https://pasteboard.co/InkfW9h.png ? Thanks regards

Hachimaki 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

thanks regards

Simon

07 Sep
1 year ago

Hachimaki left a reply on Mix Sql Query Results Within A Variable For Each Record Getted With Sql Field

Hello jlrdw, thanks. So you mean to:

  1. retrieve query sql inside Controller
  2. loop sql records, always inside Controller, and save every record inside an array by adding also image link
  3. pass array to view controller instead of sql result and looping array to draw table ?

If so do you have a link with examples or similar to study them? Thanks

Hachimaki started a new conversation Mix Sql Query Results Within A Variable For Each Record Getted With Sql Field

I have a controller with index function that retrieve sql query. SELECT command pass PART, COLOR, QUANTITY fields and i show results inside a simple table with a blade file. Inside table i need to show also the image of every PART.

To retrieve PART image i use an http request to an external website via API and i have to use part and color fields inside query recordset.

I used the GuzzleHttp to learn and try http request to get image url and it works with a single explicit request.

Now i would like to integrate the retrieved images urls of each records inside table so:

  1. can i mix recordset, by adding another field with image url during the retrieving of query recordset?
  2. or can i retrieve via API image url during the creation of the table inside blade file?
  3. or i can save files the first time and then use them locally saved?

Can you give me an hand?

Thanks