Guest User

Untitled

a guest
Jul 3rd, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 KB | None | 0 0
  1. foreach(Doctrine_Manager::getInstance()->getConnections() as $connection){
  2. $conn = $connection->getOptions();
  3. preg_match('/host=(.*);/', $conn['dsn'], $host);
  4. var_dump($host);
  5. }
  6.  
  7. $this->em->getConnection()->getDatabase();
  8.  
  9. $this->em->getConnection()->getHost();
  10.  
  11. all:
  12. conexion1:
  13. class: sfDoctrineDatabase
  14. param:
  15. dsn: 'mysql:host=localhost;dbname=basegestion1'
  16. username: miusuario
  17. password: ********
  18. conexion2:
  19. class: sfDoctrineDatabase
  20. param:
  21. dsn: 'mysql:host=localhost;dbname=baseestadisticas1'
  22. username: miusuario
  23. password: ********
  24.  
  25. $mConexion1Options = Doctrine_Manager::getInstance()->getConnection('conexion1')->getOptions();
  26. preg_match('/dbname=(.*)/', $mConexion1Options['dsn'], $mDbConexion1);
  27.  
  28. echo $mDbConexion1[1]; //basegestion1
  29.  
  30. $myConnection = Doctrine_Manager::getInstance()->getConnection('doctrine')->getOptions();
  31. $dsnInfo = $this->parseDsn($myConnection['dsn']);
  32. $settings = array();
  33. $settings['dbUser'] = (string) $myConnection["username"];
  34. $settings['dbPassword'] = (string) $myConnection["password"];
  35. $settings['dbHost'] = (string) $dsnInfo["host"];
  36. $settings['dbName'] = (string) $dsnInfo['dbname'];
  37.  
  38.  
  39. private function parseDsn ($dsn)
  40. {
  41. $dsnArray = array();
  42. $dsnArray['phptype'] = substr($dsn, 0, strpos($dsn, ':'));
  43. preg_match('/dbname = (w+)/', $dsn, $dbname);
  44. $dsnArray['dbname'] = $dbname[1];
  45. preg_match('/host = (w+)/', $dsn, $host);
  46. $dsnArray['host'] = $host[1];
  47.  
  48. return $dsnArray;
  49. }
  50.  
  51. $conn = Doctrine_Manager::getInstance()->getConnection('doctrine')->getOptions();
  52.  
  53. $dns_array = split(';', $conn['dsn']);
  54. preg_match('/host=(.*);/', $dns_array, $dbhost);
  55. preg_match('/dbname=(.*)/', $dns_array, $dbname);
  56.  
  57. $dbname = $dbname;
  58. $dbhost = $dbhost;
  59. $dbuser = $conn['username'];
  60. $dbpass = $conn['password'];
  61.  
  62. $dns_array = explode(';', $conn['dsn']);
  63. preg_match('/host=(.*)/', $dns_array[0], $dbhost);
  64. preg_match('/dbname=(.*)/', $dns_array[2], $dbname);
  65.  
  66. $dbhost = $dbhost[1];
  67. $dbname = $dbname[1];
  68. $dbuser = $conn['username'];
  69. $dbpass = $conn['password'];
Add Comment
Please, Sign In to add comment