mamp_pro_local_remote_switch.php

<?php
  if ($_SERVER['SERVER_NAME'] === 'REMOTE_HOST') {
    // remote host data
    define('DB_HOST', (string) 'REMOTE_DB_HOST');
    define('DB_USER', (string) 'REMOTE_DB_USERNAME');
    define('DB_PW', (string) 'REMOTE_DB_PASSWORD');
    define('DB_DB', (string) 'REMOTE_DB');
  } else {
    // local host data
    define('DB_HOST', (string) 'LOCAL_DB_HOST');
    define('DB_USER', (string) 'LOCAL_DB_USERNAME');
    define('DB_PW', (string) 'LOCAL_DB_PASSWORD');
    define('DB_DB', (string) 'LOCAL_DB');
  }

  $mysqli = new mysqli(DB_HOST, DB_USER, DB_PW, DB_DB);

  if ($mysqli->connect_error) {
    error_log(__FILE__ . ' ' . 'MySQL connect error: '.$mysqli->connect_error);
  } else {
    $mysqli->set_charset('utf8mb4');
    $mysqli->query('SET NAMES utf8mb4');
  }
?>