PHP lib CURDATE() issue

rpmccormick

Regarding this Google result (closed thread):
https://datatables.net/forums/discussion/61200/current-date-problem

This is my working SQL:
AND DATE(TimeSpan_Start)=CURDATE()

This solution works:
$Editor->where('DATE(TimeSpan_Start)', date('Y-m-d'), '=');

But I would prefer to use MySQL... why doesn't this work:
$Editor->where('DATE(TimeSpan_Start)', 'CURDATE()', '=', false);

Time-Zones for different Web Servers vs. SQL Server make things complicated.

allan

It doesn't work like that, because the Editor->where() method doesn't have the same signature as Query->where(). Specifically there isn't the optional binding parameter. Instead, do:

->where(function ($q) {
  $q->where('DATE(TimeSpan_Start)', 'CURDATE()', '=', false);
}

Using an anonymous function like that gives you access to the underlying Query->where() method which does allow you to set the binding option.

Allan