Where to store user settings?

Question

symfony

Where to store user settings like title, database settings. What would users be able to edit them through the form on the site?

Answer 1

DB configuration in config. Everything else is in the database.

Answer 2

Let me ask you, why would you allow users to edit database connection settings?

Answer 3

class YourService extends ContainerAware
{ 

  public function switchDatabase($dbName, $dbUser, $dbPass) 
  {
    $connection = $this->container->get(sprintf('doctrine.dbal.%s_connection', 'dynamic_conn'));
    $connection->close(); // for sure ;)

    $refConn = new \ReflectionObject($connection);
    $refParams = $refConn->getProperty('_params');
    $refParams->setAccessible('public'); //we have to change it for a moment

    $params = $refParams->getValue($connection);
    $params['dbname'] = $dbName;
    $params['user'] = $dbUser;
    $params['password'] = $dbPass;

    $refParams->setAccessible('private');
    $refParams->setValue($connection, $params);

    $this->container->get('doctrine')->resetEntityMamager('dynamic_manager'); // for sure (unless you like broken transactions)
  }
}

stackoverflow.com/questions/6409167/symfony-2-multiple-and-dynamic-database-connection
And do what you want!!.. (c)