error_reporting(E_ALL); set_time_limit(0); $db = mysql_connect('localhost','root','123456') or die("Database error"); mysql_select_db('zhoumengkang', $db); $result = mysql_query("set names 'utf8'"); $content = '\r\n22222'; $query = 'insert into `z_blog`(`title`,`content`)values(111,"'.$content.'")'; $query = "insert into `z_blog`(`title`,`content`)values(111,'{$content}')"; //var_dump($query); $result = mysql_query($query);
发现上面两种字符串格式都会把`\r\n`保存为`回车`
如果在把内容转义下,就OK了`$content = addslashes('\r\n22222');`
此时的`$content`为`\\r\\n22222`
存入数据库的时候反而又自动转回来了,变为了`\r\n22222`
看手册上大家都说最好是使用http://www.php.net/manual/en/function.mysql-real-escape-string.php 和http://www.php.net/manual/en/mysqli.real-escape-string.php
来替代`addslashes`
我试了下,效果一样,不过官方手册上建议使用那就造他们说的做吧!
error_reporting(E_ALL); set_time_limit(0); $db = mysql_connect('localhost','root','zmkzmk') or die("Database error"); mysql_select_db('zhoumengkang', $db); $result = mysql_query("set names 'utf8'"); $content = '\r\ncontent_test'; $query = 'insert into `z_blog`(`title`,`content`)values("title","'.mysql_real_escape_string($content).'")'; echo $query; $result = mysql_query($query);