PDO SQL Server / MySQL Connections

PDO SQL Server Configuration Method:

        
            /**
            * Configuration for SQL Server database connection
            *
            */
               $host = "idsprod";
               $dbname = "Testing";
               
               $username = "";
               $password = "";
               $dsn = "sqlsrv:server=$host;database=$dbname";
               
               $hostRemote = "P3NWPLSK12SQL-v05.shr.prod.phx3.secureserver.net";
               $dbRemote = ""; 
               $userRemote = "";
               $passwordRemote = "";
               $dsnRemote  ="sqlsrv:server=$hostRemote;database=$dbRemote";
           
               $_hostRemote = "P3NWPLSK12SQL-v05.shr.prod.phx3.secureserver.net";
               $_dbRemote = ""; 
               $_userRemote = "";
               $_passwordRemote = "";
               $_dsnRemote  ="sqlsrv:server=$_hostRemote;database=$_dbRemote";
           
               $options = array(
                   PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
               );
               
        
        

PDO MYSQL Configuration:

        
            /**
            * Configuration for MYSQL database connection
            *
            */
           
           function get_PDO_Parameters($source)
           {
               $options = [
                   \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION,
                   \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC,
                   \PDO::ATTR_EMULATE_PREPARES => false,
               ];
               
               if (strtolower($source) == "local") {
                   $pd['host'] = "localhost";
                   $host = $pd['host'];
                   $pd['username'] = "";
                   $pd['password'] = "";
                   $pd['dbname'] = "";
                   $dbname = $pd['dbname'];
                   $charset = 'utf8mb4';
                   $pd['dsn'] = "mysql:host=$host;dbname=$dbname;charset=$charset";
           
               } else {
                   $pd['host'] = "p3nlmysql83plsk.secureserver.net";
                   $host = $pd['host'];
                   $pd['username'] = "";
                   $pd['password'] = "";
                   $pd['dbname'] = "";
                   $dbname = $pd['dbname'];
                   $charset = 'utf8mb4';
                   $pd['dsn'] = "mysql:host=$host;dbname=$dbname;charset=$charset";
               }
               $pd['options'] = $options;
               return $pd;
           }