Answers for "where between 2 dates laravel"

PHP
6

laravel between dates

$from = date('2018-01-01');
$to = date('2018-05-02');

Reservation::whereBetween('reservation_from', [$from, $to])->get();
Posted by: Guest on April-28-2020
0

php laravel between dates

namespace AppHttpControllers;

use AppMailCheckUser;
use AppUser;
use CarbonCarbon;
use IlluminateHttpRequest;
use PDF;

class TestController extends Controller
{
    public function index()
    {   
       return view('welcome');
    }

    public function daily_report(Request $request)
    {
       $start_date = Carbon::parse($request->start_date)
                             ->toDateTimeString();

       $end_date = Carbon::parse($request->end_date)
                             ->toDateTimeString();

       return User::whereBetween('created_at', [
         $start_date, $end_date
       ])->get();
    }
}
Posted by: Guest on August-07-2021
0

get recoed between two datetime laravel

public function scopeCreatedBetweenDates($query, array $dates)
{
    $start = ($dates[0] instanceof Carbon) ? $dates[0] : Carbon::parse($dates[0]);
    $end   = ($dates[1] instanceof Carbon) ? $dates[1] : Carbon::parse($dates[1]);

    return $query->whereBetween('created_at', [
        $start->startOfDay(),
        $end->endOfDay()
    ]);
}
Posted by: Guest on January-11-2022

Code answers related to "where between 2 dates laravel"

Browse Popular Code Answers by Language