PHP PDO 在更新时转义双引号

Question

在我的本地环境中，一切正常，但当我在 GoDaddy 上移动我的网站并尝试更新帖子时，每个双引号前面都会添加一个“\”。

$sql = 'UPDATE '.$_REQUEST['id'].' SET description_'.$_REQUEST['lang'].' = :desc where id = 1';

    try
    {
        $prepare = $bd->BD_Interne->prepare($sql);
        $result = $prepare->execute(array(":desc" => $_REQUEST['raw_desc']));
        $_SESSION['update'] = "good";
    }
    catch(PDOException $e)
    {
        $_SESSION['update'] = "bad";
        echo $e->getMessage();
    }

这是mysql配置问题还是我必须在php中做一些事情？

Answer 1

也许这是指令ma​​gic_quotes_gpc的工作请参阅:http://php.net/manual/en/function.addslashes.php

function addslashes returns a string with backslashes before characters that need to be escaped. These characters are single quote ('), double quote ("), backslash () and NUL (the NULL byte).

The PHP directive magic_quotes_gpc was on by default before PHP 5.4,and it essentially ran addslashes() on all GET, POST, and COOKIE data.

您可以在此处阅读如何在 GoDaddy 上禁用魔术引号:https://uk.godaddy.com/help/disable-magic-quotes-8383