Not able to connect to external Database

[Brawlz]

Hi,

I hope this is the correct section for my problem.

All I need is a connection to an external Database and a query gettings some data. I do this in a processwire Page-Template. I am honestly not sure if it is a problem with processwire or my code:

$host = ‚XXXXX’;

$user = ‚XXXXX‘;

$pass = ‚XXXXX‘;

$db = ‚XXXXX‘;

$port = ‚3306‘;



$mydb = new Database($host, $user, $pass, $db , $port); 

$result = $mydb->query("SELECT * FROM char“); 

while($row = $result->fetch_assoc()) {

 print_r($row); 

}

 

Produces the following error:

Error: Exception: DB connect error 2002 - Connection timed out (in /customers/9/4/e/XXXX.de/httpd.www/wire/core/Database.php line 79)

 

I also tried connecting without the $port variable but got the same error.

[dragan]

Are those quotes actually single quotes ' ? I'd try to remove them from the $port, as it's just an integer anyway.

For an example of how to use the PW DB handlers, see this post from @ryan: 

Or you can use plain PHP functions (PDO, mysqli...) instead.

If the error persists, you simply don't have the correct DB credentials.

[Brawlz]

Yeah I didn't think it would make a difference for the port to be given as string or integer. I now tried using plain PHP but got the same error, guess it's the credentials then. Thanks for your suggestions!