MySQLi不插入md5哈希[重复]

Question

This question already has an answer here:

• Mysql syntax seems correct 3 answers

    $date       = date('Y-m-d');
    $key        = md5(uniqid(rand(), true));

    $title  = mysqli_escape_string($dbc, $title);
    $content    = mysqli_escape_string($dbc, $content);
    $author     = mysqli_escape_string($dbc, $author);

    $query  = "INSERT INTO fpdf (title, authorID, content, dateCreated, dateEdited, key)
                  VALUES ('$title', '$author', '$content', '$date', '$date', '$key')";


    $result     = mysqli_query($dbc, $query);
    if(!$result) {
        echo "Database fout opgetreden.<br>";
        printf("Error: %s
", mysqli_error($dbc));
    }



//// mysqli_error()
Error: 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 'key) VALUES ('werwerwer', '3', 'wrtwerw', '2014-04-16', '2014-04-16', '' at line 1 

Either I've been looking at this for too long or I'm crazy. If I remove the key altogether from the insert it works fine.

`key` varchar(32) DEFAULT NULL

</div>

Answer 1

key is a reserved keyword. If you are going to use it you must wrap it in ticks;

$query  = "INSERT INTO fpdf (title, authorID, content, dateCreated, dateEdited, `key`)
              VALUES ('$title', '$author', '$content', '$date', '$date', '$key')";