SQL语句不起作用，我做错了什么> [重复]

Question

This question already has an answer here:

• When to use single quotes, double quotes, and backticks in MySQL 12 answers

I'm creating an admin panel with a form that creates a blog post. When I try to insert this into the database, I'm getting an error. This is my SQL statement:

INSERT INTO blog_posts ('title', 'author', 'tags', 'category', 'body') VALUES ('$title', '$author', '$tags', '$category', '$body');

What am I doing wrong? Full code:

$servername = "host";
$username = "username";
$password = "password";
$dbname = "dbname";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}

$title = $_POST['title'];
$author = $_POST['author'];
$tags = $_POST['tags'];
$category = $_POST['category'];
$body = $_POST['editor1'];

// sql to insert a record

$sql = "INSERT INTO blog_posts ('title', 'author', 'tags', 'category', 'body') VALUES ('$title', '$author', '$tags', '$category', '$body');";

if (mysqli_query($conn, $sql)) {
  echo "Succes";
} else {
  echo "Error";
}

mysqli_close($conn);

So, what do I do now?

</div>

Answer 1

1. You should not use single quote or double quote for table column field.
2. End with two time semicolon

Instead of:

$sql = "INSERT INTO blog_posts ('title', 'author', 'tags', 'category', 'body') VALUES ('$title', '$author', '$tags', '$category', '$body');";

Try this

 $sql = "INSERT INTO blog_posts (`title`, `author`, `tags`, `category`, `body`) VALUES ('$title', '$author', '$tags', '$category', '$body')";