MySQL::GetJSON PHP Method

    public function GetJSON()
    {
        if ($this->last_result) {
            if ($this->RowCount() > 0) {
                for ($i = 0, $il = mysqli_field_count($this->mysql_link); $i < $il; $i++) {
                    $field = mysqli_fetch_field_direct($this->last_result, $i);
                    $types[$i] = $field->type;
                }
                $json = '[';
                $this->MoveFirst();
                while ($member = mysqli_fetch_object($this->last_result)) {
                    $json .= json_encode($member) . ",";
                }
                $json .= ']';
                $json = str_replace("},]", "}]", $json);
            } else {
                $json = 'null';
            }
        } else {
            $this->active_row = -1;
            $json = 'null';
        }
        return $json;
    }

    header('Content-type: text/html; charset=utf-8');
}
if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
    if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_METHOD'])) {
        header("Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS");
    }
    if (isset($_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS'])) {
        header("Access-Control-Allow-Headers: {$_SERVER['HTTP_ACCESS_CONTROL_REQUEST_HEADERS']}");
    }
}
include "mysql.class.php";
$database = new MySQL();
global $database;
if (!isset($_GET["parametro"])) {
    if ($database->Query("SELECT\n                                    kiiconnect_setting.nombre,\n                                    kiiconnect_setting.tag,\n                                    kiiconnect_setting.descripcion,\n                                    kiiconnect_setting.icono,\n                                    kiiconnect_setting.link,\n                                    kiiconnect_categoria.nombre AS categoria,\n                                    kiiconnect_categoria.id AS id_categoria,\n                                    kiiconnect_categoria.filecategoria,\n                                    kiiconnect_categoria.filecategoria2,\n                                    kiiconnect_categoria.icono AS categoria_icono\n                                FROM\n                                    kiiconnect_setting\n                                INNER JOIN kiiconnect_categoria ON kiiconnect_setting.id_categoria = kiiconnect_categoria.id\n                                WHERE\n                                    activo = 1\n                                ORDER BY\n                                    orden ASC")) {
        echo $database->GetJSON();
    } else {
        echo "<p>Query Failed</p>";
    }
} else {
    $temp = $database->QueryArray("SELECT\n                                    kiiconnect_categoria.nombre AS categoria,\n                                    kiiconnect_categoria.id AS id_categoria,\n                                    kiiconnect_categoria.iconodev AS categoria_icono,\n                                    kiiconnect_categoria.filecategoriadev AS filecategoria\n                                FROM\n                                    kiiconnect_categoria\n                                WHERE\n                                  activo = 1\n                                ORDER BY orden2", MYSQL_ASSOC);
    $temp2 = array();
    foreach ($temp as $index => $categoria) {
        $categoria_id = $categoria['id_categoria'];
        //            CONCAT('" . '<span style="font-weight:bold">' ." ', kiiconnect_setting.nombre, '</span>') AS nombre,
        $itemsCategoria = $database->QueryArray("SELECT\n                                    kiiconnect_setting.nombre,\n                                    kiiconnect_setting.tag,\n                                    kiiconnect_setting.descripcion,\n                                    kiiconnect_setting.icono,\n                                    kiiconnect_setting.file,\n                                    kiiconnect_setting.link\n                                FROM\n                                    kiiconnect_setting\n                                 WHERE\n                                    activo = 1 AND id_categoria = {$categoria_id}\n                                ORDER BY\n                                    orden ASC", MYSQL_ASSOC);
        if ($itemsCategoria != false) {
            $categoria['items'] = $itemsCategoria;
            $temp2[] = $categoria;
        }
    }