mysql connect command to php array with keys

mysql-connect-command-to-array-values.php

<?php

function mysql_command_to_values($input) {
    $result = [];
    $key_assignment_short = [
        'D'        => 'database',
        'u'        => 'username',
        'p'        => 'password',
        'h'        => 'host',
        'P'        => 'port',
    ];

    $key_assignment_full = [
        'database' => 'database',
        'user'     => 'username',
        'password' => 'password',
        'host'     => 'host',
        'port'     => 'port',
    ];

    $match_short_arg = preg_match_all('/-(.)\s?([^\s]+)/', trim($input), $out_short);
    $match_full_arg = preg_match_all('/--(\b[^=]+)=(.+)/', trim($input), $out_full);

    if ($match_full_arg !== 0) {
        foreach ($out_full[2] as $key => $value) {
            $result[ str_replace(array_keys($key_assignment_full), array_values($key_assignment_full), $out_full[1][$key]) ] = $value;
        }
    } else if ($match_short_arg !== 0) {
        foreach ($out_short[2] as $key => $value) {
            $result[ str_replace(array_keys($key_assignment_short), array_values($key_assignment_short), $out_short[1][$key]) ] = $value;
        }
    } else {
        return false;
    }

    return $result;

}

result.md

mysql_command_to_values("mysql -D database_name -u username -pSecretPassword -h example.org");

returns:

array(4) {
  ["database"]=>
  string(13) "database_name"
  ["username"]=>
  string(8) "username"
  ["password"]=>
  string(14) "SecretPassword"
  ["host"]=>
  string(11) "example.org"
}

mysql_command_to_values("mysql
--database=database_name
--host=example.org
--user=username
--password=password");

returns:

array(4) {
  ["database"]=>
  string(13) "database_name"
  ["host"]=>
  string(11) "example.org"
  ["username"]=>
  string(8) "username"
  ["password"]=>
  string(8) "password"
}