无法在php中获得与MySQL的连接

Question

I have this simple code:

<?php
//Open the mySQL connection
$conn_string = "'localhost', 'Vale', 'test'";
$dbh = mysql_connect($conn_string);

//Check that a connection with the DB has been established
if (!$dbh) 
{
   die("Error in MySQL connection: " . mysql_error());
}
...

And I get the error: Error in MySQL connection: php_network_getaddresses: getaddrinfo failed: The requested name is valid, but no data of the requested type was found.

I cannot figure out what the problem is, I have been google-ing but all the suggestions have failed (tried 127.0.0.1 instead of localhost, 127.0.0.1:3306, etc.)

I have code that works with postgre, but I need to use mysql, and I am trying to modify it, but I cannot pass the first line and get a connection. Any suggestion, please? Thank you!

Answer 1

mysql_connect doesn't take a comma seperated string. It takes 3 individual strings. Change it to this:

$dbh = mysql_connect($server, $mysql_user, $password);

If you absolutely have a comma separated string, and can't get around this, you can split the string like this:

 $config = str_replace("'", '', $conn_string); // replace the quotes.
 $config = preg_split('/,/', $conn_string); // split string on ,
 if($config != $conn_string) { // make sure this returned an array
     count($config) === 3 OR die("Invalid database configuration string");
     $dbh = mysql_connect($config[0], $config[1], $config[2]);
     if(FALSE === $dbh) {
         die("Coult not connect: " . mysql_error());
     }
 }