• Registered: 12/05/2015
  • Posts: 9

Topic: FrontAccounting with two database

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,094

Re: FrontAccounting with two database

2 databases for the same company?

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

apmuthu's Website

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,185

Re: FrontAccounting with two database

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_',
  ),
);
Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website