class mssqlClass {

    function connect($database = 'db') {
        $mssql_server = 'server';
        $mssql_data = array("UID" => 'uid',
            "PWD" => 'pwd',
            "Database" => $database);

        if(! ISSET ($this->connection)){
            return $this->connection = sqlsrv_connect($mssql_server, $mssql_data);
        }
        if(! $this->connection){
            return 'Failed to Connect to Host';
        }
    }

    function getData($query) {
        $this->data_array = array();
        $result = sqlsrv_query($this->connection, $query);
        while ($row =  sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
            $this->data_array[] = $row;
        }
        $m = $this->data_array;
        return $m;
    }
    function query($query) {
        $result = sqlsrv_query($query) or die( print_r( sqlsrv_errors(), true));
    }

}