插入子句错误:未知列'$变量名'在'字段列表' - Error on Insert clause: Unknown column '$variableName' in 'field list'

Error on Insert clause: Unknown column '$variableName' in 'field list'

编辑:在阅读我错误的SQL知识之前请阅读下面的答案lol

所以我试图插入一个变量，由于某种原因，它认为这是一个列，即使我有它在单引号。我做错了什么?谢谢你的宝贵时间。

Unknown column '$emailAddress' in 'field list'] in EXECUTE("UPDATE mailer_recipients SET email_address=$emailAddress WHERE id=539")
$sql = 'UPDATE ' . $this->recipientDbTable . ' SET ' . $this->recipientDbColumn['result_id'] . '=' . '$hash' . ' WHERE ' . $this->recipientDbColumn['id'] . '=' . $this->emailId;
    $sql = 'UPDATE ' . $this->recipientDbTable . ' SET ' . $this->recipientDbColumn['address'] . '=' . '$emailAddress' . ' WHERE ' . $this->recipientDbColumn['id'] . '=' . $this->emailId;

试试这个:

$sql = "UPDATE {$this->recipientDbTable} SET {$this->recipientDbColumn['result_id']} = '{$hash}' WHERE {$this->recipientDbColumn['id']} = {$this->emailId}";

仔细阅读单引号和双引号的区别