// DB connection from Azure App Settings environment variables
$connectstr_dbhost     = getenv('DATABASE_HOST');
$connectstr_dbname     = getenv('DATABASE_NAME');
$connectstr_dbusername = getenv('DATABASE_USERNAME');
$connectstr_dbpassword = getenv('DATABASE_PASSWORD');

define('DB_NAME',     $connectstr_dbname);
define('DB_USER',     $connectstr_dbusername);
define('DB_PASSWORD', $connectstr_dbpassword);
define('DB_HOST',     $connectstr_dbhost);
define('DB_CHARSET',  'utf8');
define('DB_COLLATE',  '');

// SSL for Azure MySQL
$mysql_sslconnect = getenv('DB_SSL_CONNECTION') ?: 'true';
if (strtolower($mysql_sslconnect) !== 'false'
    && strpos($connectstr_dbhost, '127.0.0.1') === false
    && strpos(strtolower($connectstr_dbhost), 'localhost') === false) {
    define('MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL);
}