Get Data By Month and Year

 <h2>Get Data By Month and Year</h2>  
 <div dir="ltr" style="text-align: left;" trbidi="on">  
 <br />  
 function getLeave()<br />&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp; <br />&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $this-&gt;db-&gt;where('MONTH(CURDATE()) = MONTH(emp_leave_start_date) and&nbsp; YEAR(CURDATE()) = YEAR(emp_leave_start_date)');<br />&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $query = $this-&gt;db-&gt;get('employee_leave');<br />&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; return $query-&gt;result();<br />&nbsp;&nbsp;&nbsp; }</div>