wpdb class : provide a disconnect / connect to db functions

[arena]

some hosts automatically disconnect mysql after a short while.
I think it could be interesting to have in wpdb a disconnect and connect functions.

[ocean90]

Related: #5932

[arena]

Hi ocean90

the code i am currently using

class data_base
{
	function mysql_disconnect()
	{
		global $wpdb;
		mysql_close($wpdb->dbh);
	}

	function mysql_connect()
	{
		global $wpdb;
		$wpdb->__construct(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST);
	}
}

but still have some "mysql_real_escape_string(): nn is not a valid MySQL- Link resource" on some webhosts after disconnecting/connecting !

[pento]

Unless there's another use case for this, I'm inclined to close this ticket. The reported bug (hosts automatically disconnecting MySQL) will be fixed by #5932.

[arena]

Not sure to close this ticket is a good option.
At least wordpress to privide an api in fixing #5932.
Some plugins may use it ...

[pento]

Duplicate of #5932.

If the MySQL connection is lost mid-page load, it will reconnect as of [27279].

For more advanced connecting/disconnecting, this is the realm of a drop-in DB replacement.