php - 尝试更新数据库中的条目

Question

我正在尝试使用以下代码更新数据库中的记录。我正在尝试更改产品名称，但出现以下错误:

Could not update data: Unknown column 'Earrings' in 'field list'

代码:

<?php
if(isset($_POST['update']))
{
    $dbhost = 'databasehost';
    $dbuser = 'username';
    $dbpass = 'password';
    $conn = mysql_connect($dbhost, $dbuser, $dbpass);

        if(! $conn )
        {
            die('Could not connect: ' . mysql_error());
        }

        $ProductsID = $_POST['ProductsID'];
        $ProductsName = $_POST['ProductsName'];

        $sql = "UPDATE Products ".
           "SET ProductsName = $ProductsName ".
           "WHERE ProductsID = $ProductsID" ;

        mysql_select_db('databasename');
        $retval = mysql_query( $sql, $conn );
        if(! $retval )
        {
            die('Could not update data: ' . mysql_error());
        }
        echo "Updated data successfully\n";
        mysql_close($conn);
}
else
{
?>

Answer 1

查询应该是

$sql = "UPDATE Products ".
       "SET ProductsName = '$ProductsName' ".
       "WHERE ProductsID = $ProductsID" ;

您忘记用引号将 $ProductName 括起来。在处理字符串值时不要忘记这样做。