Find current Doctrine database connection settings in symfony

Question

I need to know the database name and database server name inside a symfony project. How can one access the current database connection settings programmatically in symfony (using Doctrine)?

Answer 1

Assuming you have the EntityManager as $this->em

Get Doctrine Database Name from Symfony2:

$this->em->getConnection()->getDatabase();

Get Doctrine Host Name (Server Name) from Symfony2:

$this->em->getConnection()->getHost();

---

There are many other parameters you can access from the connection such as username, port and password. See the connection class for more info

Answer 2

for example:

foreach(Doctrine_Manager::getInstance()->getConnections() as $connection){
  $conn = $connection->getOptions();
  preg_match('/host=(.*);/', $conn['dsn'], $host);
  var_dump($host);
}