=('" . 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

$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();

Discover more from Soa Technology | Aditya Website Development Designing Company

Subscribe to get the latest posts sent to your email.



Leave a Reply

Discover more from Soa Technology | Aditya Website Development Designing Company

Subscribe now to keep reading and get access to the full archive.

Continue reading