How to view data based on date range using laravel and mysql

Question

Route:

Route::post('dategraph','Chatbot\TrackerController@dategraph');

Controller:

public function dategraph(Request $request)
{
    $dategraph = DiraStatistics::all()->whereBetween('date_access', [$from, $to])->get();

    $dates = $dategraph('date_access');

    return view('AltHr.Chatbot.graph', compact('dates'));
}

View:

<form id="form-project" role="form" action="{{action('AltHr\Chatbot\TrackerController@dategraph')}}" autocomplete="off" method="POST">

          {{csrf_field()}}
          <!-- <canvas id="myChart" width="150" height="50"></canvas> -->

            <div class="form-group-attached">
              <div class="row">
                  <div class="col-lg-6">
                      <div class="form-group form-group-default required" >
                          <label>From</label>
                          <input type="date" class="form-control" name="from" required>
                      </div>
                  </div>
                  <div class="col-lg-6">
                      <div class="form-group form-group-default required" >
                          <label>To</label>
                          <input type="date" class="form-control" name="to">
                      </div>
                  </div>
              </div>
            </div>
            <button class="btn alt-btn-black btn-xs alt-btn pull-right" type="submit">Next</button>
</form>

Hi guys, so im trying to view the data from the selected dates as the code ive written. But im getting an error. Did i write it correctly? or am i missing something?

values of $from and $to, you need to get them from $request as $request->input()['from'] — Danyal Sandeelo
– Danyal Sandeelo, Commented Oct 17, 2017 at 5:49

Unamata Sanatarai · Accepted Answer · 2017-10-17 06:44:18Z

1

You do not have a $from variable. You need to pull out posted variables from the request.

The method get() will return a Collection of objects. You can, for example, turn it to a flat array by plucking the column and turning it toArray()

$dategraph = DiraStatistics::whereBetween(
    'date_access', 
    [
        $request->get('from'),
        $request->get('to')
    ]
)->get();
$dates = $dategraph->pluck('date_access')->toArray();

answered Oct 17, 2017 at 6:44

Unamata Sanatarai

6,6293 gold badges32 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

How to view data based on date range using laravel and mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related