Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- foreach(Doctrine_Manager::getInstance()->getConnections() as $connection){
- $conn = $connection->getOptions();
- preg_match('/host=(.*);/', $conn['dsn'], $host);
- var_dump($host);
- }
- $this->em->getConnection()->getDatabase();
- $this->em->getConnection()->getHost();
- all:
- conexion1:
- class: sfDoctrineDatabase
- param:
- dsn: 'mysql:host=localhost;dbname=basegestion1'
- username: miusuario
- password: ********
- conexion2:
- class: sfDoctrineDatabase
- param:
- dsn: 'mysql:host=localhost;dbname=baseestadisticas1'
- username: miusuario
- password: ********
- $mConexion1Options = Doctrine_Manager::getInstance()->getConnection('conexion1')->getOptions();
- preg_match('/dbname=(.*)/', $mConexion1Options['dsn'], $mDbConexion1);
- echo $mDbConexion1[1]; //basegestion1
- $myConnection = Doctrine_Manager::getInstance()->getConnection('doctrine')->getOptions();
- $dsnInfo = $this->parseDsn($myConnection['dsn']);
- $settings = array();
- $settings['dbUser'] = (string) $myConnection["username"];
- $settings['dbPassword'] = (string) $myConnection["password"];
- $settings['dbHost'] = (string) $dsnInfo["host"];
- $settings['dbName'] = (string) $dsnInfo['dbname'];
- private function parseDsn ($dsn)
- {
- $dsnArray = array();
- $dsnArray['phptype'] = substr($dsn, 0, strpos($dsn, ':'));
- preg_match('/dbname = (w+)/', $dsn, $dbname);
- $dsnArray['dbname'] = $dbname[1];
- preg_match('/host = (w+)/', $dsn, $host);
- $dsnArray['host'] = $host[1];
- return $dsnArray;
- }
- $conn = Doctrine_Manager::getInstance()->getConnection('doctrine')->getOptions();
- $dns_array = split(';', $conn['dsn']);
- preg_match('/host=(.*);/', $dns_array, $dbhost);
- preg_match('/dbname=(.*)/', $dns_array, $dbname);
- $dbname = $dbname;
- $dbhost = $dbhost;
- $dbuser = $conn['username'];
- $dbpass = $conn['password'];
- $dns_array = explode(';', $conn['dsn']);
- preg_match('/host=(.*)/', $dns_array[0], $dbhost);
- preg_match('/dbname=(.*)/', $dns_array[2], $dbname);
- $dbhost = $dbhost[1];
- $dbname = $dbname[1];
- $dbuser = $conn['username'];
- $dbpass = $conn['password'];
Add Comment
Please, Sign In to add comment