在代码末尾解析错误？看了好几遍都没找到

Question

我是这个领域的新手，我正在努力获得一些技能来成为一名网络开发人员，有点。这是我在浏览器中打开文件时遇到的错误：

解析错误：语法错误，第 26 行文件意外结束。

这是代码：

<?php

$servername = "";

$username = "";

$password = "";

$dbname = "";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($mysqli->connect_error) {

echo "Failed to connect to MySQL: " . $mysqli->connect_error;

}

$sql = "CREATE TABLE MyColor (

color

)";

if ($conn->query($sql) === TRUE) {

echo "Table MyColor created successfully";

} else {

echo "Error creating table: " . $conn->error;

$conn->close()

?>

Answer 1

除了 $conn->close() 行中缺少分号外，您创建表的 SQL 语句是错误的。颜色属性缺少类型。创建表应该是这样的：CREATE TABLE MyColor (&nbsp; &nbsp; &nbsp; color TYPEOFTHEFIELD)# TYPEOFTHEFIELD can be whatever type, varchar, int, whatever you want.&nbsp;有关创建表命令，请参阅此：https ://dev.mysql.com/doc/refman/8.0/en/create-table.html