public function getAveRating($restoid) { $where = array( "restoid" => $restoid ); $this->db->where($where); $this->db->select_avg('rate'); $query = $this->db->get('ratings')->first_row('array'); return $query['rate']; } How do I limit the average into 2 decimal places in getting the rating?
public function getAveRating($restoid){ $where=array( "restoid"=>$restoid ); $this->db->where($where); $this->db->select_avg('rate'); $query = $this->db->get('ratings')->first_row('array'); return round($query['rate'], 2); } Change return $query['rate']; to return round($query['rate'],2);
You can call number_format() on the lone returned value from your query if you want a formatted string with thousands placeholders otherwise use round() to return a float value.
public function getAveRating(int $restoid): float { return round( $this->db ->select_avg('rate') ->get_where('ratings', ['restoid' => $restoid]) ->row('rate'), 2 ); } Or you could round in the query itself.
public function getAveRating(int $restoid): float { return (float)$this->db ->select('ROUND(AVG(rate), 2) rate') ->get_where('ratings', ['restoid' => $restoid]) ->row('rate'); }