This topic is locked
[SOLVED]

conection banks

5/15/2024 7:12:46 PM
PHPRunner General questions
Roosevelt author

Hello everyone, I need to connect two banks in one project, is it possible?

Sergey Kornilov admin 5/16/2024

What are "banks"?

C
Chris Whitehead 5/16/2024

As Admin has asked, can you expand on what a bank is?

Is it the actual project or the default templates, I believe you can make one a template(if it isn't) and import it.

Roosevelt author 5/18/2024

banks = database

C
Chris Whitehead 5/18/2024

This might be what you're looking for. I'm not sure if this is only enterprise edition.
https://asprunner.com/forums/topic/27314-multiple-databases-setup

If it is only for enterprise and you're using the standard version you can still use 2 databases but they won't appear in the project, I would do either of the following.

You can setup a standard MySql connection in the "after application initialised" event and use the connection as a global variable. I have used this for syncing a local to remote database.

Or you can extend the class "DB" using a new class called "DB2", then setup a new connection in the function "CurrentConnection()", this method would allow you to use the existing PHPRunner functions , for example DB2::DBLookup( $query );

Roosevelt author 5/19/2024

I liked this idea. Thank you very much. I'll try.

Sergey Kornilov admin 5/20/2024

Enterprise Edition of PHPRunner supports multiple databases in a single project:
https://xlinesoft.com/ee