Question : fetch data based on month and year in laravel
Answered by :
$post = Mjblog::whereYear('created_at', '=', $year) ->whereMonth('created_at', '=', $month) ->get();Source : https://laracasts.com/discuss/channels/laravel/compare-only-month-and-year-in-db-and-fetch-records?page=1 | Last Update : Tue, 20 Oct 20
Question : fetch data based on month and year in laravel
Answered by :
$date = Carbon::createFromFormat('d/m/Y', $request->salary_date);
$empsalaries = EmpSalary:: whereMonth('salary_date', $date->month) ->whereYear('salary_date', $date->year) ->get()Source : https://laracasts.com/discuss/channels/laravel/compare-only-month-and-year-in-db-and-fetch-records?page=1 | Last Update : Tue, 20 Oct 20