php - 如何在 Laravel 5.1 中编写原始查询？

Question

我是 Laravel 的初学者。我可以用原始 PHP 编写查询。现在我想在 Laravel 框架中编写它。到目前为止，我已阅读文档并尝试过:

原始 PHP:

SELECT count(*)/(TIMESTAMPDIFF(YEAR,'2016-01-01 00:00:00',now())+1) as avg from buyer  where created_at >= '2016-01-01 00:00:00';

尝试使用 Laravel:

public function index(){
    //
    $yrUserReg = DB::table('buyer')
                    -> SELECT (DB::raw (count('*')/("TIMESTAMPDIFF(YEAR,'2016-01-01 00:00:00',now())+1"))) 
                    -> AS ('avg') 
                    -> WHERE ("created_at >= '2016-01-01 00:00:00'");
   return view('userflow',compact($yrUserReg));                 
}

但它引发了我一个错误:除以零。我找不到任何解决方案。提前致谢。任何帮助将不胜感激!!

Answer 1

这是完整的构建查询:

$yrUserReg =  DB::table('buyer')
                ->select(DB::raw("(count('*')/(TIMESTAMPDIFF(YEAR,'2016-01-01 00:00:00',now())+1)) as avg"))
                ->where('created_at', '>=', '2016-01-01 00:00:00')
                ->get();