Information Technology

VueJS

Ionic

React

laravel

Currently I'm working as remote employer at Capital Typing Inc. which is a US Firm. Currently I am developing a ERP software which has file management with s3 integration, has task management and invoicing etc. It is developing by Laravel, Vue Js

In this tutorial, i will try to illustrate how you can create blog archive sorted by month, year with the count of total article published on that month. So lets get started.&nbsp;

&nbsp;

First lets think what we want to get as output right? So if we try to build query with raw SQL.

<pre><code>
select
 year(created_at) as year,
 month(created_at)as month,
 MONTHNAME(created_at) month_name,
 count(*) total_published
From articles
where status=1
 GROUP BY year, MONTH(created_at), MONTHNAME(created_at)
 ORDER BY year DESC, month DESC;
</code>
</pre>

After Executing this query we will get output like this -

YearMonthMonth NameTotal Published20179September2201710October2201711November2201712December2

So how we can write this in laravel query builder format? lets have a look here -&nbsp;

<pre><code>
 $archives = DB::table('articles')
 -&gt;selectRaw('year(created_at) as year,month(created_at) as month, monthname(created_at) as monthname, COUNT(*) post_count')
 -&gt;groupBy('year')
 -&gt;groupBy('monthname')
 -&gt;groupBy('month')
 -&gt;orderBy('year', 'desc')
 -&gt;orderBy('month', 'desc')
 -&gt;where('status',1)
 -&gt;get();
</code>
</pre>

You can check the what you have got in $archives variable by dd($archive). Then for generating links for each month,year we have to run foreach loop here. Something like this -&nbsp;

<pre><code>
&lt;ul class="link_nav"&gt;
 &lt;li&gt;
 @foreach($archives as $archive)
 &lt;a href="{{ route('archives', ['month' =&gt; $archive-&gt;monthname, 'year'=&gt;$archive-&gt;year]) }}"&gt;
 {{ $archive-&gt;monthname }}, {{ $archive-&gt;year }} &lt;b class="badge"&gt;{{ $archive-&gt;post_count }}b&gt;
 a&gt;
 @endforeach
 li&gt;
ul&gt;
</code>
</pre>

Here in route we are passing month and year to controller so that we can filter out the result. Closely look at month, here we are passing month name as string for SEO purpose. We will deal with it in our controller. So first declare the route like this -&nbsp;

<pre><code>
Route::get('/archives', ['as' =&gt; 'archives', 'uses' =&gt; 'Blogs@archives']);
</code>
</pre>

We will get url like this - https://www.sshakil.com/archives?month=December&amp;year=2017

Now Lets look at our controller -&nbsp;

<pre><code>
public function archives(Request $request)
{
 $month = $request-&gt;month;
 $year = $request-&gt;year;
 
 $data['archive_name'] = 'Archives from '.$month.', '.$year;
 
 $articles = Article::latest();
 $articles-&gt;whereMonth('created_at', Carbon::parse($month)-&gt;month);
 $articles-&gt;whereYear('created_at', $year);
 
 $data['articles'] = $articles-&gt;paginate(10);
 
 return view('frontEnd.blogs.archives', $data);

}
</code>
</pre>

&nbsp;

Here we are using whereMonth(), whereYear() method for filtering the result by month, year. Remember we got our month name as string e.g. December/January. But Here we need the month value as integer. Here comes <a href="about:blank" target="_blank">Carbon::parse.</a>&nbsp;Very useful at this point.&nbsp;Carbon::parse($month)-&gt;month by doing this we are converting december to 12.&nbsp;

So this is how we get articles after filtering. passing $articles to blade view and We need to run foreach loop to get all the articles from the specific month,year.

Software Engineer@Capital Typing Inc.

Read Latest Articles

How you can generate blog archive links in laravel

How to use Toastr Notification in Angular 5

How to use Toastr Notification in Angular 5

How to use Toastr Notification in Angular 5

How to use Toastr Notification in Angular 5

Sports

How to check if user is logged in or not in Laravel

Laravel

Make bootstrap carousel dynamic in Laravel

Codigniter

Make youtube video responsive by JQuery

JQuery

How you can get current controller or method name in codeigniter

Software Engineer@Capital Typing Inc.