Page 1 of 1

PHP easily switch databases

Posted: Thu Jul 05, 2012 11:55 pm
by 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)

Re: PHP easily switch databases

Posted: Fri Jul 06, 2012 12:19 am
by Jackolantern
Nice! :)

Re: PHP easily switch databases

Posted: Sun Jul 08, 2012 12:54 am
by 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);
}