[php]

//更新数组
$update = array(
‘name’ => $name,
‘price’ => $price,
‘des’ => $des,
‘content’ => $content
);

//仅当用户选择上传图片 才进行图片上传处理
if($_FILES[‘file’][‘size’] > 0)
{
$pic = imgUpload($_FILES[‘file’]);
$update[‘pic’] = $pic;
}

//只更新被用户修改的信息 对比数据库数据跟用户表单数据

foreach($update as $k => $v)
{
if($goods[$k] == $v)//对应key相等 删除要更新的字段
{
unset($update[$k]);
}
}

//对比2个数组 如果没有需要更新的字段
if(empty($update))
{
msg(1, ‘操作成功’, ‘edit.php?id=’ . $goodsId);
}

$updateSql = ”;
foreach($update as $k => $v)
{
$updateSql .= "`{$k}` = ‘{$v}’ ,";
}
//去除多余 ,
$updateSql = rtrim($updateSql, ‘,’);

unset($sql, $obj, $result);
$sql = "UPDATE `im_goods` SET {$updateSql} WHERE `id` = {$goodsId}";

[/php]