2. PHPRunner General questions
  3. How to link data field from 2 databases?
This topic is locked

How to link data field from 2 databases?

 		12/11/2012 3:12:51 AM
PHPRunner General questions
P
 phpcmk author

Hi,
I have previously created a project A (pure php coding, not using phprunner) and now I would like to link up the data field between my project A and the current project B (using phprunner). Can someone please kindly help me on this as I have really no idea how to proceed?
For example, whenever user created a record in project A, certain fields will automatically reflect in project B database.
Thanks in advance for the help.
C
 		cgphp 12/11/2012

PHPRunner only supports one database per project.
B
 		btrdev 12/12/2012

Depending on what database platform you are working with, you can access the tables from database B through database A. That way PHPR only needs to see one database.
In SQL Server for instance, you can create Views in database A that are linked to the tables in database B. PHPR can then perform then read or update those tables as necessary, through the Views.