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`
看手册上大家都说最好是使用