2. PHPRunner General questions
  3. multiple databases
This topic is locked

multiple databases

 		10/14/2008 12:56:02 PM
PHPRunner General questions
P
 promanron author

Hi All,

I am still working thru some questions regarding PHPR, and have another one.
I have two separate databases, called admin and public.
admin contains tables such as users, logs, clients, etc.

public contains tables such as orders and shipments.
I want to create a web page for maintenance of the orders table (in the public database), but have users login and get verified against the users table (in the admin database).
I do not see a method of opening multiple databases within a single PHPR project.
Any ideas?
thanx in advance,

ron
Sergey Kornilov admin 10/14/2008

Ron,
PHPRunner supports one database per project only.
P
 		promanron author 10/14/2008

Ron,

PHPRunner supports one database per project only.


Hi Sergey,

Thanx for the reply.
I have found an answer for my use, and maybe it will work for someone else.
The question was how to validate users login info against a table that resides in a different database.
My answer will be to define the original table as a master and create a master/ slave replication connection between the 2 databases. Whenever the master users table in the admin database is updated, the slave users table in the public database will be updated. There could be some lag between updates, but, not significant enough to cause a problem. Once the slave users table is automatically created, it will be available for use by PHPR
thanx,

ron