Laravel 4 Fluent Databasse error for my SQL query
I am getting this error building my SQL query with PHP's Laravel 4 Fluent
Databasse library
BadMethodCallException
Call to undefined method Illuminate\Database\Query\Builder::table()
Here is my code...
$timeCards = TimeCard::table('timeclock_timecard')
->select(DB::raw('DATE_FORMAT(clock_in_datetime, "%Y-%m-%D") AS
clock_in_datetime, timecard_id'))
->where('clock_in_datetime', 'LIKE', '%$year-$month%')
->get();
here is what the query looks like when used outside of laravel in regular
PHP and it works
$sql = "SELECT timecard_id, DATE_FORMAT(clock_in_datetime,'%Y-%m-%D') AS
clock_in_datetime FROM timeclock_timecard WHERE clock_in_datetime LIKE
'%$year-$month%'";
Anyone know how to fix this in Laravel 4?
No comments:
Post a Comment