Laravel and multiple database connections

Question

This might be a silly question. I have two separate databases that are being used with Laravel 4. One of them can only be accessed with a certain IP (security reasons) while the other can be accessed. I have two different mysql connections. I have seen the Database connection test using this:

if(DB::connection('mysql')->getDatabaseName()){ }

To test what can be seen and what can't be seen, I tried to give the mysql a false password. I get this nice ugly error how it can't connect. Is there a way to make it where if the Database cannot be reached, just to ignore it? There's only one PHP class that's calling the secure only database on page load, but the above check doesn't seem to be working.

can you reach your remote sql server with just plain php ? have you configured the remote sql server to accept connections ? if you're running xampp you might wanna read this stackoverflow.com/questions/8481620/… — astroanu
– astroanu, Commented Jan 22, 2015 at 3:40
@astro, I'm able to connect just fine while on a certain IP and this is exactly what I wanted to do, but I wanted some code NOT to run while outside of the IP. :) — cbloss793
– cbloss793, Commented Jan 22, 2015 at 16:33

Mysteryos · Accepted Answer · 2015-01-22 06:43:59Z

2

Going through the core code of laravel, there is no specific exceptions being thrown when a database connection fails.

The solution hence, is:

try {
    //Strings always evaluate to boolean true
    $dbConnected = (bool)DB::connection('mysql')->getDatabaseName();
}
catch (Exception $e)
{
    $dbConnected = false;
}

Then work your code based on the variable $dbConnected.

answered Jan 22, 2015 at 6:43

Mysteryos

5,8013 gold badges35 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel and multiple database connections

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related