Php mysqli real escape string add back slashes

Question

I have a text field that stores a value in database. When I input inverted commas i.e " " or apostrophe i.e. '' it automatically adds back slash to my string. How to remove back slashes or inverted commas and apostrophe?

<?php
if (empty($_POST['video_title'])) {
        $error[] = 'You must enter a video title';
    } else {
        $vid_title =  mysqli_real_escape_string($conn, $_POST['video_title']);
    }
?>

Perhaps you have [magic quotes](http://php.net/manual/en/security.magicquotes.php) enabled? — eggyal, Sep 06 '15 at 11:38

score 0 · Accepted Answer · answered Sep 06 '15 at 11:46

that is happening because of magic quotes, you should disable, if you don't want to, you can run stripslashes()

such as

<?php
if (empty($_POST['video_title'])) {
        $error[] = 'You must enter a video title';
    } else {
        $vid_title =  mysqli_real_escape_string($conn, $_POST['video_title']);
        $vid_title = stripslashes($vid_title);
    }
?>

Php mysqli real escape string add back slashes

1 Answers1