laravel 5 - sorting dates and searching the dates

Question

I have a date table like below :

Schema::create('dates', function (Blueprint $table) {
    $table->bigIncrements('id');
    $table->dateTime('date');
    $table->float('price');
    $table->timestamps();
});

Now I have a form that submits an start and a finish date so I have 2 variables

$start_date;
$end_date

How can I sort my date table ascending and show the dates between the start_date and the end_date?

What format are $start_date and $end_date ?

apokryfos
– apokryfos

2019-04-02 08:04:17 +00:00
Commented Apr 2, 2019 at 8:04 — apokryfos
– apokryfos, Commented Apr 2, 2019 at 8:04

thefallen · Accepted Answer · 2019-04-02 07:57:39Z

2

You can use the whereBetween() method:

\DB::table('dates')
    ->whereBetween('date', [$start_date, $end_date])
    ->orderBy('date', 'asc')
    ->get();

If you have a model for this table you can use it directly instead of the DB facade.

answered Apr 2, 2019 at 7:57

thefallen

9,8202 gold badges39 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sepehr · Accepted Answer · 2019-04-02 08:06:07Z

-1

You can use Eloquent like below:

   YourModel::whereDateBetween(‘date’,$start_date,$end_date)->orderBy->(‘date’,’asc’)->get();

answered Apr 2, 2019 at 8:06

sepehr

135 bronze badges

Collectives™ on Stack Overflow

laravel 5 - sorting dates and searching the dates

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related