Styjun

I have some data having date field. I want to display the data starting from the current month data ...

I get the 1st record started from current month. But next month is again starting from january. I want the records like current month+1 then currentmonth+2 and so on

@foreach($leave_manages as $holiday)
 <tr>
 <td class="danger">$holiday->date->format('F')</td>
 <td class="warning">$holiday->date->format('d-m-Y')</td>

 <td class="danger">$holiday->holiday</td>
 <td class="info">$holiday->date->format('l')</td>
 </tr>
@endforeach

Expected Result: March, April, May, June,............., February.

Actual Result: March, January, February..........,December

Laravel provides built-in functions to get records using date functions. below code will get records from latest to older within the current year. user this

$leave_manages = $leave_manages = Leave_manage::whereYear('created_at', date('Y'))->orderBy('created_at', 'desc')->get();;

Since don't know the full content of your database not completely sure this is what you are looking for.

Assuming leave_manages table contains all the months you can use native eloquent query to fetch the results

$leave_manages = Leave_manage::whereDate('holiday', '>', CarbonCarbon::createFromDate(date('Y'), 1, 1))
 ->whereDate('holiday', '<', now())
 ->orderBy('holiday', 'acs')
 ->get();

$leave_manages->concact(Leave_manage::whereDate('holiday', '>', now())
 ->whereDate('holiday', '<', CarbonCarbon::createFromDate(date('Y'), 12, 31))
 ->orderBy('holiday', 'acs')
 ->get());

$from = Carbon::now()->toDateTimeString();
$to = Carbon::now()->subMonth(11)->toDateTimeString();
$data = Leave_manage::where('created_at', '>=', $to)->where('created_at', '<=', $from)
->select(DB::raw("DATE_FORMAT(created_at, '%m') as login_month , DATE_FORMAT(created_at, '%Y') as login_year"))
 ->groupBy('login_month')
 ->groupBy('login_year')
 ->orderBy('login_year')
 ->orderBy('login_month')
 ->get();