geetpurwar

geetpurwar

Member Since 5 Years Ago

Experience Points
27,570
Total
Experience

2,430 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
267
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.

Level 6
27,570 XP
Oct
21
3 weeks ago
Activity icon

Replied to RelationShip Access Help

Distinct categories. This kind of query works but I am not sure how to setup in a relationship.

select count(posts.id) as 'Post Counts', categories.title
from posts
inner join categories on categories.id = posts.category_id
where user_id = 11 group by category_id
Activity icon

Started a new Conversation RelationShip Access Help

Hi,

I have these tables and I need to access all categories in which a user has created posts. I wanted to do following:

$user->with('posts')->categories()

Tables:

posts
    id - integer
    name - string
    user_id - integer
    category_id - integer

users
    id - integer
    name - string

categories
    id - integer
    name - string

Please advise.

Activity icon

Replied to Relationship

@nakov I will playaround and see if anything works. Thing is, I don't have any foreign key on user or categories table.

Just posts table has both user_id, and category_id column.

Activity icon

Replied to Relationship

@nakov Thank you for reply. its showing following error: Screenshot: https://cl.ly/ef1331bc9b2f

BadMethodCallException
Call to undefined method App\User::categories.posts()

When ran in tinker, it showed following error:

>>> $user->with('categories')->get()
Illuminate/Database/QueryException with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'categories.post_id' in 'on clause' (SQL: select `categories`.*, `posts`.`user_id` as `laravel_through_key` from `categories` inner join `posts` on `posts`.`id` = `categories`.`post_id` where `posts`.`user_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11))'

Looks like its looking for post_id column in category table, but we have setup BelongsTo relationship with Post.

public function category(){
    return $this->belongsTo(Category::class);
}

Please advise. Thanks.

Activity icon

Started a new Conversation Relationship

Hi,

I am having one issue which I am not sure how to approach. Issue is as follows:

Models:

  1. User -> hasMany(\App\Post)
  2. Post -> belongsTo(\App\User) -- Table has both user_id, category_id
  3. Category -> hasMany(\App\Post)

Is there a way to fetch All categories in which user has created posts, along with count of all posts in categories.

Thank you for the help.

Jul
06
4 months ago
Activity icon

Started a new Conversation Using Middleware In Dispatching Queue

Hi,

I need a bit of help here. I am using following function which seems fine with using middleware.

Route::get('push', function(){
    $product = \App\Product::find(5028);
    $product->shopify_upload();
    return "Done";
})->middleware('dConfig');

However, I need to dispatch this via queue job and this is providing me error as I am not able to use middleware in jobs.

Route::get('push', function(){
    PushProductToShopify::dispatch(5029)->delay(now()->addSeconds(1));
})->middleware('dConfig');

Anyone please suggest how do I use middleware in queues. Thanks.