PHP MySQL vs SQLite Count Items Function

PHP

/* MYSQL Version */
    public function count_items() {
        $db_table_name = $this->db->real_escape_string($this->db_table_name); 
        $sql = "select count(id) as total from $db_table_name";
        $result = $this->db->query($sql);
        while($row = $result->fetch_assoc()) {
            return($row['total']);
        }
    }  

/* SQLite Version */
    public function count_items() {
        $db_table_name = $this->db->escapeString($this->db_table_name);
        $sql = "select count(id) as total from $db_table_name";
        $result = $this->db->query($sql);
        while($row = $result->fetchArray()) {
            return($row['total']);
        }
    }  

/* Combined version - which gets a bit too complex, so i left them separated */
    public function count_items() {
        // mysql version of escape
        if($this->db_type == "mysql") {
          $db_table_name = $this->db->real_escape_string($this->db_table_name); 
        }
        // sqlite version of escape
        if($this->db_type == "sqlite") {
          $db_table_name = $this->db->escapeString($this->db_table_name);
        }

        // common query
        $sql = "select count(id) as total from $db_table_name";
        $result = $this->db->query($sql);
      
        // mysql version of the loop
        if($this->db_type == "mysql") {
          while($row = $result->fetch_assoc()) {
              return($row['total']);
          }
        }
        // sqlite version of the loop
        if($this->db_type == "sqlite") {
          while($row = $result->fetchArray()) {
              return($row['total']);
          }
        }
      
    }