2. PHPRunner General questions
  3. Connect to two databases
This topic is locked

Connect to two databases

 		3/22/2010 11:37:21
PHPRunner General questions
K
 Khris author

I have a situation where there is an existing Accpac MS SQL database already setup which I would like to be able to access. My dilemma is that I only want to pull information from this database, and then connect to a second which will have full read/write capabilities. Is this possible with PHPRunner? Would both databases have to be MS SQL or could it be a mix of MS SQL and MySQL?
Sergey Kornilov admin 3/23/2010

By default PHPRunner supports one database only. If you need to connect to another database and perform some actions like authenticate a user - use Events for this purpose.
S
 		sts 4/29/2010



By default PHPRunner supports one database only. If you need to connect to another database and perform some actions like authenticate a user - use Events for this purpose.


I need this ability as well. I wish to lookup info from tables in a second database (an accounting system database) to populate some fields in a table contained in a database driven by phprunner. In other isnstance I simply wish to display fields from the second database.
I will be using events as suggested above. Can you tell me what is necessary to preserve and restore access to the original databases prior to opening the new database.
Thanks for the help!
J
 		Jane 5/3/2010

Hi,
there is no easy way to select values in the lookup dropdown from another database.

This task requires a lot of custom coding in the generated files. Unfortunately we don't have a ready to go solution for this.