FrontAccounting forum — FrontAccounting with two database

Re: FrontAccounting with two database

null@example.com (kvvaradha) — Mon, 07 Dec 2015 04:18:49 +0000

you can do it like this.

 $db_connections = array (
  0 => 
  array (
    'name' => 'Company Name 1',
    'host' => 'localhost',
    'dbuser' => 'root',
    'dbpassword' => '123456',
    'dbname' => 'first_database',
    'tbpref' => '0_',
  ),
 
1 => 
  array (
    'name' => 'Company Name 2',
    'host' => 'localhost',
    'dbuser' => 'root',
    'dbpassword' => '123456',
    'dbname' => 'second_database',
    'tbpref' => '0_',
  ),
);

Re: FrontAccounting with two database

null@example.com (apmuthu) — Sun, 06 Dec 2015 08:44:52 +0000

2 databases for the same company?

Switch database in the file config_db.php's dbname element for the appropriate company..

FrontAccounting with two database

null@example.com (deep97) — Sat, 05 Dec 2015 23:55:05 +0000

Hi want to know how I can connect FrontAccounting with two Databases.
I have two database, Want to pick and update some values in 2nd database.
Regards
DEep