LeonLatex Posted April 9, 2023 Share Posted April 9, 2023 I need help to solve a problem I can't get rid of. I get this error: Unable to connect to the database server: SQLSTATE[HY000] [2005] Unknown MySQL server host '$host' (2) So, the error check works, it writes out the error message. The problem is I can't find the problem/error in the script. I hope you could be so kind and find it for me. I am VERY sure my user details are correct. Is every reference to variables correct, for instance? Could you be kind and tell me where and what to do? <?php $host = 'mysqlhost.no'; //Default database host. $dbname = 'mydatabasename'; //Default database name. $username = 'myusername'; //Default database username. $password = 'mysecretpassword'; //Default database password. try { $pdo = new PDO('mysql:host=$host;dbname=$dbname;charset=utf8', '$username', '$password'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); return $db; } catch (PDOException $e) { $output = 'Unable to connect to the database server<X>: ' . $e->getMessage(); ' in ' .$e->getFile() . ':' . $e->getline(); } Quote Link to comment https://forums.phpfreaks.com/topic/316107-pdo-connection-problem/ Share on other sites More sharing options...
requinix Posted April 9, 2023 Share Posted April 9, 2023 You seem to be really enjoying single quotes today. https://www.php.net/manual/en/language.types.string.php#language.types.string.syntax.single 1 Quote Link to comment https://forums.phpfreaks.com/topic/316107-pdo-connection-problem/#findComment-1607157 Share on other sites More sharing options...
LeonLatex Posted April 9, 2023 Author Share Posted April 9, 2023 49 minutes ago, requinix said: You seem to be really enjoying single quotes today. It seems like that because I have tried so much. Thanks for the link. I will check it out. Quote Link to comment https://forums.phpfreaks.com/topic/316107-pdo-connection-problem/#findComment-1607158 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.