“字段列表”中的未知列'xxx'[重复]

Question

This question already has an answer here:

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

So here is an error:

Error: INSERT INTO fo_reports (`path`, `version`, `userContacts`, `userMessage`, `errorMessage`) VALUES (`asd`, `10`, `regtyh`, `frtgtyh`, `vfgtyh`)
Unknown column 'asd' in 'field list'

PHP file itself:

<?php

$path = $_GET["path"];
$version = $_GET["version"];
$userContacts = $_GET["userContacts"];
$userMessage = $_GET["userMessage"];
$errorMessage = $_GET["errorMessage"];


$servername = "xxxxxxxxx";
$username = "xxxxxxxxxxx";
$password = "xxxxxxxxxxx";
$dbname = "xxxxxxxxxxxxxxxx";

$conn = mysqli_connect($servername, $username, $password, $dbname);

$sql = "INSERT INTO fo_reports (`path`, `version`, `userContacts`, `userMessage`, `errorMessage`) VALUES (`$path`, `$version`, `$userContacts`, `$userMessage`, `$errorMessage`)";

if (mysqli_query($conn, $sql)) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);

?>

So how can I fix that? I think, that the problem is in quotes.. But I tried different variants, but nothing helps..

</div>

Answer 1

use '`' only around column names. When you pass `asd` in your values it thinks that it should grab values from column called 'asd'. If you want to pass a value surround your variables with single quotes.