@Override public void useDatabase(String alias, String path) { File f; try { f = FileWriterImpl.getInstace().fileCreate(path); } catch (IOException ex) { Logger.getLogger(PHPGenericWriterImpl.class.getName()).log(Level.SEVERE, null, ex); return; } // get database config DatabaseConfig db = DBManagerImpl.getInstace().getDatabaseConfig(alias); // include of connection details FileWriterImpl.getInstace().writeLine("include '" + db.getConfigFileName() + "';", f); // PDO connection to database String phpCode = "/* Connect to an ODBC database using driver invocation */\n" + "$_dsn = 'mysql:dbname=$_db_config_databaseName;host=$_db_config_host';\n" + "\n" + "try {\n" + " $dbh = new PDO($_dsn, $_db_config_user, $_db_config_password);\n" + "} catch (PDOException $e) {\n" + " echo 'Connection failed: ' . $e->getMessage();\n" + "}"; FileWriterImpl.getInstace().writeLine(phpCode, f); }