Database connection failed SQLSTATE [HY000][1102]incorrect database name ‘study ‘

Question

<?php
header("Content-type:text/html;charset=utf-8");    //设置编码
$servername = "localhost";
$username = "root";
$password = "root";
// 创建连接
$conn = mysqli_connect($servername, $username, $password);
mysqli_set_charset($conn,'utf8'); //设定字符集
// 检测连接
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}
// 创建数据库
$sql = "CREATE DATABASE study";
if (mysqli_query($conn, $sql)) {
    echo "数据库创建成功";
} else {
    echo "数据库创建失败: " . mysqli_error($conn);
}
mysqli_close($conn);
?>

Answer 1

OK, thanks

Answer 2

First check whether there is any problem with the PHP code format, then put the SQL statement into mysql and test it to see if there is any problem with the SQL statement, and then look at the mysqli extension problem.

Answer 3

Yes, there is an error when running

Answer 4

Three codes into one, is your file utf-8 without BOM header?