PHP easily switch databases

[BobMann]

I felt like sharing a small function I made, I have a lot of databases and I would always lose track to witch one was the last one called.

Code: Select all

function mysql_database_query($db, $query)
{
	if(!$db)
	{
		echo 'mysql_database_query(); No database selected! ';
		quit();
	}

	if(!$query)
	{
		echo 'mysql_database_query(); No query given ';
		quit();
	}
	
	mysql_select_db($db, $connection);
	
	return mysql_query($query);
}


$data = mysql_database_query($database, $query, $connection);

Just felt like sharing.
(Note: It may just be me but I get a lot of errors unless a connection is defined BEFORE this function)

[Jackolantern]

Nice!

[Xaleph]

Code: Select all

function query($q, $db=false, $c=false)
{
    return ($db ? mysql_select_db($db, $c ? $c : null) ? mysql_query($q) : false : mysql_ping() ? mysql_query($q) : false);
}