Display a List of Tags with Counter

This is pretty straightforward, as you're only counting the tags once they appear in the article_tag (otherwise they wouldn't exist). I'm assuming you are using Laravel 5.1. Please do say so if you're not.

So, first of all you could get a list of all Tag IDs by using:

Tag::lists('id')->all(); // This will return an array: [1, 2, 3, 4, 5] etc

Then, you can query the article_tag table with the IDs you've just got:

(just had to take a call, will update this when I'm back.)

@mstnorris Nice a half reply..

This is a good solution for your problem: http://stackoverflow.com/questions/25973095/getting-count-from-pivot-table-in-laravel-eloquent

@mstnorris thanks for the tip. No, I'm using Laravel 5.0 for this.

@bobbybouwmann Thanks for the link, but I can't figure out how implement that to my scenario.

This is what I have done so far on Articles model.

// additional helper relation for the count
    public function tagsCount()
    {
        return $this->belongsToMany('Tag')
            ->selectRaw('count(tags.id) as aggregate')
            ->groupBy('tag_id');
    }

    // accessor for easier fetching the count
    public function getTagsCountAttribute()
    {
        if ( ! array_key_exists('tagsCount', $this->relations)) $this->load('tagsCount');

        $related = $this->getRelation('tagsCount')->first();

        return ($related) ? $related->aggregate : 0;
    }

I now want to display the tagsCount here

@foreach($tags as $tag)
    <p><li><a class="" href="{{ url('stories/'.$tag->name) }}">{{ $tag->name.' (tag_count_should_be_here)</a></li></p>
@endforeach

Well with this code you can simply do this

@foreach($tags as $tag)
    $tag->tagsCount;
@endforeach

@bobbybouwmann So am I supposed to move those two methods into the Tag model?

Euhm nop, this is the example from the link

$products = Product::with('ordersCount')->get();

// then for each product you can call it like this
$products->first()->tagsCount; // thanks to the accessor

So in your case you would have something like this

@foreach ($articles as $article)

    @foreach($tags as $tag)
        <li><a class="" href="">{{ $tag->name }} ({{ $article->tagsCount }})</a></li>
    @endforeach

@endforeach

Thanks, I think I have messed here

public function tagsCount()
{
    return $this->belongsToMany('Tag')
                ->selectRaw('count(tags.id) as aggregate')
                ->groupBy('tag_id');
}

because it is displaying (1) for all the tags which is incorrect.

And what about create a tag_link? I mean when you want to display every articles which has the tag "X" ? I kinda need that, thanks in advance! I already have the many to many relationships.