Something

<?php

class MemberStats {

var $name;
var $mysqli;
var $member_id;
var $raid_count = 0;
var $loot_count;

    function __construct($id, $mysqli) {

        $this->member_id = $id;
        $this->mysqli = $mysqli;
        $this->populateStats();
        
    }
    
    function populateStats()
    {
    
    //get member name
        $statement = "SELECT name from icono.raid_members where id = ?";
        $statement = $this->mysqli->prepare($statement);
        $statement->bind_param("i", $this->member_id);
        $statement->execute() or die(mysqli_error());
        $statement->bind_result($this->name);
        $statement->fetch();
        $statement->close();
        
    //get total raids    
        $statement = "SELECT Count(*) as raid_count
                FROM icono.raid_attendance
                WHERE member_id = ? AND active ='1'
                GROUP BY member_id";
        $statement = $this->mysqli->prepare($statement);
        $statement->bind_param("i", $this->member_id);
        $statement->execute() or die (mysqli_error());
        $statement->bind_result($this->raid_count);
        $statement->fetch();
        $statement->close();

        
   //get loot count
        $statement = "SELECT name, tier_id, COUNT(*) as cnt FROM icono.raid_loot LEFT JOIN icono.loot_class on class_id = icono.loot_class.id where member_id = ?
        group by class_id, tier_id";
        $statement = $this->mysqli->prepare($statement);
        $statement->bind_param("i", $this->member_id);
        $statement->execute() or die (mysqli_error());
        $statement->bind_result($class, $tier, $count);
        
        while($statement->fetch())
        {    
            $this->loot_count["$class"]["$tier"] = $count;
        }
          
        $statement->close();
    }
    function memberExists()
    {  
        if(!empty($this->name))
                return true;
        return false;
    }
    function getRaidCount(){
       
        return $this->raid_count;
    }
    
    
    function getLootCount($class, $tier)
    {
    
        if(strtolower($tier) == "total")
        {
            $total = 0;
            if(isset($this->loot_count[$class]))
                foreach($this->loot_count[$class] as $v)
                    $total += $v;
                    
            return $total;
            
        }
        
        return isset($this->loot_count[$class][$tier]) ? $this->loot_count[$class][$tier] : 0;
        
    }
   
    
    function getRatio($class){
        if($this->getLootCount($class, "total") == 0)
                return $this->getRaidCount();
                
        return round($this->getRaidCount() / $this->getLootCount($class, "total"), 2);
        
    
    }
    
    function getName(){
        return $this->name;
    }
    
    function getLoot()
    {   
        return $this->loot_count;
    }

    function display()
    {
        if(!isset($this->loot_count))
            return;
        
        $output = "<table>
        
        <caption>Raid Statistics for " . $this->name . " </caption>
        <thead>
                <tr>
                        <th scope=\"col\">Raids</th>
                        <td>" . $this->getRaidCount() . "</td>
                        <th>Tier 5</th>
                        <th>Tier 6</th>
                        <th>Tier 7</th>
                        <th>Total</th>
                        <th>Ratio</th>
        
                </tr>
        </thead>
                
        <tfoot>
        <tr><td>View Extra details</td></tr>
        </tfoot>
        <tbody>";
        
        foreach($this->loot_count as $k => $v){
                
                        $output .= "<tr>
                                <td colspan=\"2\" scope=\"col\">$k</td>
                                <td>" . $this->getLootCount("$k","5") . "</td>
                                <td>" . $this->getLootCount("$k","6") . "</td>
                                <td>" . $this->getLootCount("$k","7") . "</td>
                                <td>" . $this->getLootCount("$k","total") . "</td>
                                <td>" . $this->getRatio("$k"). "</td>
                        </tr>";

                        
                
        } 
        $output .= "</tbody><table>";
        echo $output;
    }
}

?>