php 数据库操作 数组转换成数据库语句

 //更新sql处理
    $update = array(
        'name' => $name,
        'price' => $price,
        'cid' => $cid,
        'content' => $content,
        'pay_content' => $pay_content,
    );
    //校验图片 当用户选择商品 才进行上传处理
    if ($_FILES['file']['size'] > 0) {
        //处理图像上传
        $pic = imgUpload($_FILES['file']);
        $update['pic'] = $pic;
        if (!empty($update)) {
            $update['update_time'] = $_SERVER['REQUEST_TIME'];
        }
    }
    //只更新被用户更改的信息 对比数据库信息和表单数据
    foreach ($update as $k => $v) {
        //对应key相等 删除要更新的字段
        if ($goods[$k] == $v) {
            unset ($update[$k]);
        }
    }
    //对比两个数组 如果没有需要更新的字段
    if (empty($update)) {
        msg(1, "商品无需任何更改", 'publish.php?type=edit&id=' . $goodsId);
    }
    $updateSql = '';
    //update 'la_goods' set 'name='value',
    foreach ($update as $key => $value) {
        $updateSql .= "`{$key}`='{$value}',";
    }
    //"'`name`='超仙中长款雪纺2018夏季新款女装韩版雪纺韩版气质修身格纹连衣裙','`price`='3','`des`='des','`content`='\"undefined\"',"
    #var_export($updateSql);
    //去除多余逗号
    $updateSql = rtrim($updateSql, ',');
    # var_export($updateSql);
    //`name`=\'超仙中长款雪纺2018夏季新款女装韩版雪纺韩版气质修身格纹连衣裙\',\'`price`=\'3\',\'`des`=\'des\',\'`content`=\'\\"undefined\\"\''
    $sql = "UPDATE `la_goods` SET {$updateSql} WHERE `id`={$goodsId} and `user_id`={$userId}";