Skip to content

Instantly share code, notes, and snippets.

@kikegarcia
Created November 30, 2015 09:04
Show Gist options
  • Save kikegarcia/f2801af9b1fb9afd9a74 to your computer and use it in GitHub Desktop.
Save kikegarcia/f2801af9b1fb9afd9a74 to your computer and use it in GitHub Desktop.
Symfony2 Connections inside controller
public function connectDb(\Doctrine\ORM\EntityManagerInterface $em, $dbName, $connectionFactory){
$centerDb = $em->getRepository('SmCommonBundle:Center')->findOneBy(array('dbName' => $dbName));
if($centerDb) {
$server = $this->container->getParameter('database_host');
$port = $this->container->getParameter('database_port');
$result = $connectionFactory->createConnection(array(
'driver' => $this->container->getParameter('database_driver'),
'user' => $centerDb->getDbUserName(),
'password' => base64_decode($centerDb->getDbUserPass()),
'host' => $server,
'port' => $port,
'dbname' => $dbName,
));
// Versión Servidor Windows
// $result = new PDO("dblib:host=qa;dbname=$dbName",$centerDb->getDbUserName(), $centerDb->getDbUserPass());
// Versión Servidor Linux
// $result = new PDO("sqlsrv:Server=$server,$port;Database=$dbName",$centerDb->getDbUserName(), $centerDb->getDbUserPass());
} else {
$result = null;
}
return $result;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment