halcyon

halcyon

Member Since 3 Years Ago

Experience Points 11,080
Experience
Level
Lessons Completed 152
Lessons
Completed
Best Reply Awards 0
Best Answer
Awards
  • Start Your Engines Achievement

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • First Thousand Achievement

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • One Year Member Achievement

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • Two Year Member Achievement

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • Three Year Member Achievement

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • Four Year Member Achievement

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • Five Year Member Achievement

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • School In Session Achievement

    School In Session

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

  • Welcome To The Community Achievement

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • Full Time Learner Achievement

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • Pay It Forward Achievement

    Pay It Forward

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

  • Subscriber Achievement

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • Lifer Achievement

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • Laracasts Evangelist Achievement

    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 Achievement

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • Laracasts Veteran Achievement

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • Ten Thousand Strong Achievement

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • Laracasts Master Achievement

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • Laracasts Tutor Achievement

    Laracasts Tutor

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

  • Laracasts Sensei Achievement

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • Top 50 Achievement

    Top 50

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

27 Sep
2 years ago

halcyon left a reply on Saving An Intervention Image Instance Into Amazon S3

thank you for the answer @Thatdoorsajar

i am using intervention/image 2.3.8 and your method is the one that works for me too

05 May
2 years ago

halcyon left a reply on Many To Many Filters Checkboxes

oh well, managed to solve it myself =)

here is my solution, in case someone needs

$filters = $request->filters;

$query = \App\Restaurant::query();
$query->select(\DB::raw('id, name, address'));
$query->join('filter_restaurant', 'restaurants.id', '=', 'filter_restaurant.restaurant_id');
$query->where(function($query) use($filters)
{
    $query->whereIn('filter_id', $filters);
});
$query->groupBy('restaurants.id');
$query->havingRaw('count(*) = '.count($filters));

$restaurants = $query->get();
return $restaurants;
03 May
2 years ago

halcyon started a new conversation Many To Many Filters Checkboxes

Hi everyone, i got stuck doing this many to many filters.

TABLE : restaurants id name address

TABLE: filters id name

TABLE : filter_restaurant restaurant_id filter_id

On my HTML page, i have a list of filters[] checkboxes for users to select filters. For example, if user tick 2 checkboxes and submit, i do this in my controller to get the array $filters = $request->filters; let's say my $filters = [5, 7];

Current Situation - i wanted to filter restaurants that has both filters 5 and 7 but my current query is giving me restaurants that has either filter 5 or 7.

$query->select(\DB::raw('id, name, address'));
$query->whereHas('filters', function($query) use($filters)
{
    $query->whereIn('filter_id', $filters);
});```

really appreciate any help, thank you
26 Apr
2 years ago

halcyon left a reply on Socialite - Fail Gracefully?

thank you for providing your solution 6 months ago. it helped me now :)