Skizo

Skizo

Member Since 2 Years Ago

Experience Points 4,180
Experience Level 1

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 40
Lessons
Completed
Best Reply Awards 0
Best Reply
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.

25 Apr
1 year ago

Skizo left a reply on Query To Eloquent Model

@devk The query above is simplified version of the actuall query so I dont really can use that. @bobbybouwmann I used this method already, I thought there are ways to use Eloquent relationships.

Skizo started a new conversation Query To Eloquent Model

I have this query:

SELECT authors.name, COUNT(books.id) books_count
FROM books
LEFT JOIN authors on authors.id = books.author_id
GROUP BY author.id

How can I transform this into Eloquent models?

I tried this:

class Book extends Model {
    public function author() {
        return $this->belongsTo('Author');
    }
}

Book::all()->with('author');

It worked but the group by is the problem.. Thanks.

02 Jan
1 year ago

Skizo left a reply on Error In Laravel But No Error In Phpmtadmin

@Snapey I know that id should be unique but in the actual code there are 2 joins between the if's, and because of the joins I get some of the jobs couple of times.

Skizo left a reply on Error In Laravel But No Error In Phpmtadmin

@GertjanRoke

if($domain != 0) {
    $jobs = $jobs->where('domain_id', $domain);
}
if(!isset($jobs)) {
    $jobs = \App\Job::all();
} else {
    $jobs = $jobs->groupBy('jobs.id');
    $jobs = $jobs->get();
}
01 Jan
1 year ago

Skizo started a new conversation Error In Laravel But No Error In Phpmtadmin

I use the ORM and I get this error:

SQLSTATE[42000]: Syntax error or access violation: 1055 'jobs.jobs.active' isn't in GROUP BY (SQL: select * from `jobs` where `domain_id` = 2 group by `jobs`.`id`)

I copied the sql query into the phpmyadmin, ran it and no errors. Good result. What is the problem with Eloquent?

25 Apr
2 years ago

Skizo started a new conversation Get User By Relationship

Hello friends

Let's say that I have application with boards that users can create, every board has user_id that linked to a user id, then a user inside a board can create lists so each list has board_id. Now if a user edit title of a list, the controller gets the id of the list and the new title now I want to check that the list is actually belongs to the user and the id of the list is not wrong. Do I need to get the board of the list and then to get the user and after that make the check?