How to get current month in Codeigniter?

By Hardik Savani | July 17, 2019 | Category : Codeigniter

In this example, we will learn how to get current month data in codeigniter. we can get current month data using codeigniter query builder. we will use MONTH() and YEAR() mysql function for getting current month data.

I will share with you simple example example of getting current month data in codeigniter 3 application. sometime it might be require to get and display only current month data in your php codeigniter 3 application.

You can see bellow example database query to getting current month data from database items table.


$data['data'] = $this->db->select('*')

->where('MONTH(created_at)', date('m'))

->where('YEAR(created_at)', date('Y'))








[0] => stdClass Object


[id] => 2

[title] => Codeigniter 3 CRUD Example

[description] => Codeigniter 3 CRUD Example From Scratch To follow :

[created_at] => 2019-07-11 00:00:00

[updated_at] => 0000-00-00 00:00:00



I hope it can help you....

Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
Follow Me: Github Twitter
***Do you want me hire for your Project Work? Then Contact US.

We are Recommending you: