Parse error at the end of the code? I have reviewed it several times, I can't find anything

Question

I am new in this field, I am trying to get some skills to be a web developer, kind of. This is the error I get when opening the file in my browser:

Parse error: syntax error, unexpected end of file on line 26.

this is the code:

<?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()
?>

Hi, perhaps there's no closing brace `}` after the last `else`. — IronMan, Feb 26 '20 at 00:53
Your last line `$conn->close()` is missing a semicolon (`;`) at the end, and your `else` block isn't closed. — samlev, Feb 26 '20 at 00:53
Error creating table: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 — mdrr5545, Feb 26 '20 at 01:02
Very good. You got this far. Now you need to go learn the correct syntax for making a table. Good luck. — ryantxr, Feb 26 '20 at 01:10

score 0 · Accepted Answer · answered Feb 26 '20 at 01:13

Besides the semicolon is missing from the $conn->close() line, you're SQL statement for the create table is wrong. It is missing type for the color attribute.

Create table should be like this:


CREATE TABLE MyColor (
      color TYPEOFTHEFIELD
)

# TYPEOFTHEFIELD can be whatever type, varchar, int, whatever you want.

Refer to this about the create table command: https://dev.mysql.com/doc/refman/8.0/en/create-table.html

Parse error at the end of the code? I have reviewed it several times, I can't find anything

1 Answers1