Filter results from - to date

I want to search data from database according to input that comes from input fileds : i have two input fieldfrom and to.my dates comes in format like this2016-02-26

public function search(Request $request){

        $start = $request->get('from');
        $end = $request->get('to');
        $from = min($start, $end);
        $till = max($start, $end);
      //  dd($till);




        $members = DB::table('member_register')
                  ->where('created_at', '>=', $from)
                  ->where('created_at', '<=', $till)
                  ->select('name')
                  ->get();
                 dd($members);
    }

but i have not got data between two dates . i got data that matches date from only first input field.

How can i get data between input comes from two fields

kahriman

10 years ago

Level 30

You need to create Carbon object before search:


//get data from form
$from = Carbon::create($year, $month, $day, $hour, $minute, $second, $timezone);
$members = DB::table('member_register')
->where('created_at', '>=', $from)
->get();

1 like

Please or to participate in this conversation.