php mysql n 转义字符串,如何在MySQL中存储转义字符并在php中显示它们？

最新推荐文章于 2021-03-12 21:17:10 发布

Playmz

最新推荐文章于 2021-03-12 21:17:10 发布

阅读量120

点赞数

文章标签： php mysql n 转义字符串

"本文介绍如何在PHP中从MySQL数据库获取字符串"That's all"，同时移除'转义字符，并保持格式如换行和空格。建议使用stripslashes()和nl2br()函数处理，或自定义函数进行字符串转换。提及了mysql_*函数的使用和mysqli或PDO的替代方案。"

摘要由CSDN通过智能技术生成

For example I want to store the String "That's all". MySQL automatically escapes the ' character. How do I echo that String from the database using php but remove the \ in front of escaped characters like \' ? I would also like to preserve other formatting like new lines and blank spaces.

解决方案

Have you tried stripslashes(), regarding the linebreaks just use the nl2br() function.

Example:

$yourString = "That\'s all\n folks";

$yourString = stripslashes(nl2br($yourString));

echo $yourString;

Note: \\ double slashes will turn to \ single slashes

You should probably setup your own function, something like:

$yourString = "That\'s all\n folks";

function escapeString($string) {

return stripslashes(nl2br($string));

}

echo escapeString($yourString);

There are also several good examples in the nl2br() docs

Edit 2

The reason your are seeing these is because mysql is escaping line breaks, etc. I am guessing you are using mysql_* functions. You should probably look into mysqli or PDO.

Here is an example:

$yourString = "That's all

folks";

echo mysql_escape_string($yourString);

Outputs:

That\'s all\r\n folks