我需要知道Symfony项目中数据库和数据库服务器的名称。如何在Symfony中通过编程方式访问当前的数据库连接设置(使用Doctrine)?
$this->em
。
从Symfony2获取Doctrine数据库名称:
$this->em->getConnection()->getDatabase();
从Symfony2中获取Doctrine主机名(服务器名称):
$this->em->getConnection()->getHost();
你可以从连接中访问许多其他参数,例如用户名
、端口号
和密码
。有关更多信息,请参见连接类。
foreach(Doctrine_Manager::getInstance()->getConnections() as $connection){
$conn = $connection->getOptions();
preg_match('/host=(.*);/', $conn['dsn'], $host);
var_dump($host);
}
特定连接的dsn中的dbname:
databases.yml
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
现代(截至2022年10月)Doctrine DBAL 3.4.5和Persistence 2.5.4的答案
在现代版本的Doctrine中,我只能找到一种通过注入ManagerRegistry
来获取Doctrine连接名称(在doctrine.yaml
文件中配置)的方法:
use Doctrine\DBAL\Connection;
use Doctrine\Persistence\ManagerRegistry;
use Doctrine\Persistence\ObjectManager;
// ...
private function getConnectionName(ManagerRegistry $managerRegistry, Connection $targetConnection): string
{
foreach ($managerRegistry->getConnections() as $connectionName => $connection) {
if ($targetConnection === $connection) {
return $connectionName;
}
}
return '<unrecognized connection>';
}
// ...
$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'];
更新
由于函数split()已被弃用
,因此这里推荐使用以下方式。
$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'];