php72 连接mysql,PHP连接MySQL

$servername = "localhost";

$username = "username";

$password = "password";

$dbname = "myDBPDO";

try {

//$conn = new PDO("mysql:host=$servername;", $username, $password);

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

echo "连接成功";

// 设置 PDO 错误模式为异常

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$sql = "CREATE DATABASE myDBPDO";

// 使用 exec() ，因为没有结果返回

$conn->exec($sql);

echo "数据库创建成功
";

} catch(PDOException $e) {

echo $sql . "
" . $e->getMessage();

}

$conn = null;

?>