get double value in MySQL with 2 decimal places

 public function getRatings(Request $request)
    {
      $data = array();
      $lang = $request->lang;
      $data['ratings']= DB::connection($lang)->table('review')->select(DB::raw('format(avg(rating),2) as `rate`'),  'review_id')->groupby('review_id')->get(); 
      return $this->sendResponse($data, 'Successfully'); 
    }
format(number, qtyDecimals)
sample: format(1000, 2)
result 1000.00


Leave a Reply