Simple PHP database configuration script that automatically switches between local and production databases based on the server it is being run on.

PHP_DB_Config.php

<?php
	$whitelist = array('127.0.0.1','::1');
	if(!in_array($_SERVER['REMOTE_ADDR'], $whitelist)){
	    //SERVER
		$server = 'localhost';
		$username = 'server_username';
		$password = 'server_password';
		$dbname = 'username_dbname';

		$conn = mysqli_connect($server, $username, $password, $dbname);
		if (!$conn){
		    die("Connection Failed! ".mysqli_connect_error());
		}
	}else{
		//LOCAL
		$server = 'localhost';
		$username = 'root';
		$password = '';
		$dbname = 'dbname';

		$conn = mysqli_connect($server, $username, $password, $dbname);
		if (!$conn){
		    die("Connection Failed! ".mysqli_connect_error());
		}
	}
?>