[CMS] Using second databaseconnection in 2 widgets

[Removed-836727]

Hi.

I've created a widget which gets the data from an other database.
So i've created a second db connection in the widget.

Now i want 2 or more widgets which gets there data from the other connection.

What would be the best way to do that?
ATM i open the connection, send the query to get the data, close the connection.
In the second widget the same thing is happening.

Now i thought to create a singleton class for the db connection, so i don't have to open & close it in every widget.
Would that be better?
Where should i than close the connection?

[Edwin Brown]

Personally I would do that-make a singleton class so the connection is maintained. That's how we do it.

[Removed-836727]

OK thx.

[Removed-836727]

That's my code now

class ragtek_seconddatabaseconnection
{
    private static $instance = null;

    /**
     * Constructor protected to enforce singleton use.
     */
    protected function  __construct() {
    }

    /**
     * returns the databaseconnection
     * @return <vB_Database> Database Object
     */
    public static function Instance()
    {
        if (self::$instance === null)
        {
            self::$instance = new vB_Database(vB::$vbulletin);
            self::$instance->connect('oscommerce', 'localhost', null, 'shopdb', '');
        }
        return self::$instance;
    }

    /**
     * protected to enforce singleton use
     */
    protected function  __clone() {
    }
} 

Any optimisation tips?

And to close the db connection, i've created a plugin at hook global_complete

if (class_exists('ragtek_seconddatabaseconnection'))
{
ragtek_seconddatabaseconnection::Instance()->close();
}