php - CodeIgniter 中 select_avg() 的小数位数

Question

有没有办法在 CodeIgniter 中使用 select_avg() 只显示一位小数？

 $this->db  
      ->select_avg('Stars')
      ->from('Reviews') 
      $query=$this->db->get();  
      return $query->result(); 

Answer 1

尝试这样

$this->db->select_avg(ROUND('Nr_stele'))->from('Recenzii as r');
$query = $this->db->get(); 
return $query->result_array();

Check SQL ROUND() Function and $this->db->select_avg() in codeigniter