class analyticsdbconnect extends analyticslogininfo {
    function getSettings(){
        $settings = logininfo::getSettings();
        $host = $settings['dbhost'];
        $db = $settings['dbname'];
        $user = $settings['dbusername'];
        $pass = $settings['dbpassword'];
        $connect= mysqli_connect($host, $user, $pass,$db) or die ("Sorry, Could not Connect Database! Error Code #3")
        return ($connect);
    }
}

require_once 'libraries/database.connect.php';
class mysqlqueryforAnalytics extends analyticsdbconnect{

     function countGroupBy($queryFor,$beginningDate,$endDate){
        $conAnalytics=analyticsdbconnect::getSettings();

        $this->query=sprintf("SELECT '%s' ,COUNT(*) as count FROM `analyticsDB`.`analytics` WHERE date BETWEEN '%s' AND '%s' GROUP BY '%s'  ORDER BY count DESC",
                mysqli_real_escape_string($this->conAnalytics, $this->queryFor),
                mysqli_real_escape_string($this->conAnalytics,$this->queryFor),
                mysqli_real_escape_string($this->conAnalytics, $this->beginningDate),
                mysqli_real_escape_string($this->conAnalytics,$this->endDate));
        $this->result=mysqli_query($this->conAnalytics, $this->query)or die(mysqli_error());
        return $this->row=mysqli_fetch_row($this->result);
        return $this->count=count($this->row);
    }
}

$newquery="country";
$beginDate="2016-11-01";
$endDte="2016-11-28";
$thequery= new mysqlqueryforAnalytics();
$test=$thequery->countGroupBy($newquery, $beginDate, $endDte);
echo $test;