Allows dynamic switching of database credentials based on the current defined site URL.

gistfile1.php

<?php

// ** MySQL settings - You can get this info from your web host ** //
  /** DB switch statement */

$wufunc_getServName = $_SERVER['SERVER_NAME'];  

	switch ($i) {
	case 'localdev.siteurl.com':
		/** JH local */
		define('DB_NAME', 'database-name');
		/** MySQL database username */
		define('DB_USER', 'database-user');
		/** MySQL database password */
		define('DB_PASSWORD', 'database-password');
		/** MySQL hostname */
		define('DB_HOST', 'localhost');	
	break;

	case 'stageserver.siteurl.com':
		/** STAGEWP */
		define('DB_NAME', 'wpress');
		/** MySQL database username */
		define('DB_USER', 'web_admin');
		/** MySQL database password */
		define('DB_PASSWORD', 'password');
		/** MySQL hostname */
		define('DB_HOST', 'stagedb-host');	
	break;

	default:
		/** PRODUCTION */
		define('DB_NAME', 'database-name');
		/** MySQL database username */
		define('DB_USER', 'database-user');
		/** MySQL database password */
		define('DB_PASSWORD', 'database-password');
		/** MySQL hostname */
		define('DB_HOST', 'localhost');	
				
}