I am creating a DB raw query, to return a record between two dates, but giving an error, my MYSQL look like this 2018-01-25
using the format Y-m-d
This is my query
public function index() {
date_default_timezone_set('UTC');
$format = 'Y/m/d';
$now = date($format);
$to = date($format);
$data = [
'from' => $now,
'to' => $to
];
$em = $this->getEm($data);
return view('report.index', ['em' => $em, 'search' => $data]);
}
private function getData($data) {
return DB::table('A')
->select('A.firstname', 'A.middlename', 'A.lastname')
->where('date_hired', '>=', $data['from'])
->where('date_hired', '<=', $data['to'])
->get()
->map(function ($item, $key) {
return (array) $item;
})
->all();
}
}
The following error occurs when I run the query
(1/1) InvalidArgumentException
Illegal operator and value combination.
The question is how to remove the error to return results, who can assist me
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire