在MYSQL中插入数据之前删除多余的字符？

Question

I'm trying to create a simple blog type system for my site using PHP and MYSQL.

everything works fine. however, the issue that I am facing right now is that when I insert data into mysql database, it will have some extra characters.

the extra character that I am having the most difficulty with is this: \

Example:

when I insert an image link/tag into database: I get the following in my database:

<p><img alt=\"\" src=\"http://somedomain.com/images/9Image1.jpg\" /></p>

so I am trying to remove those extra characters before inserting the data into mysql using PHP.

for that, I tried using the following code:

$body = preg_replace("/\\\\\/", "", $body);

however, this code doesn't do anything. and in fact stops my entire code working and it stops my code from inserting any data into mysql.

Could someone please advise on this issue?

Thanks in advance.

Answer 1

Try to use stripslashes(string)

$body = stripslashes($body);

Let me know if it works.