=('" . date('Y-m-d H:i:s') . "'-INTERVAL 15 MINUTE) AND updated_at <='" . date('Y-m-d H:i:s"> =('" . date('Y-m-d H:i:s') . "'-INTERVAL 15 MINUTE) AND updated_at <='" . date('Y-m-d H:i:s">

print query in laravel

About

print query in laravel

in Laravel 

$data['result'] = DB::connection($lang)->table('cal_user_activity')->select('module_id', DB::raw('count(*) as total'))->where(['module'=> $module, 'module_id'=> $module_id])->whereRaw("updated_at >=('" . date('Y-m-d H:i:s') . "'-INTERVAL 15 MINUTE) AND updated_at <='" . date('Y-m-d H:i:s') . "'")->groupBy('module_id')->toSql();

Leave a Reply