PDO创建mysql数据库并指定utf8编码

时间:2021-10-11 21:00:16
<?php 
//PDO创建mysql数据库并指定utf8编码
header('Content-type:text/html; charset=utf-8');
$servername = "localhost";
$username = "root";
$password = "";
$dsn="mysql:host=$servername"; try {
$pdo = new PDO($dsn, $username, $password);
// 设置 PDO 错误模式为异常
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "CREATE DATABASE IF NOT EXISTS MY_DB DEFAULT CHARSET utf8 COLLATE utf8_general_ci";
$result=$pdo->prepare($sql)->execute();
echo "数据库创建成功<br>";
}
catch(PDOException $e)
{
echo "<br>" . $e->getMessage();
} $pdo = null;
?>