Re: [問題]請問從MySQL裡抓文字資料如何才能分行？
看板Web_Design作者johnney (You make me Complete!)時間19年前 (2005/11/19 07:58)推噓0(0推 0噓 0→)留言0則, 0人參與討論串2/2 (看更多)
最近看到的...
People want to know how they can retain textarea line breaks in HTML.
You should store text in the database in its original format
(e.g. with just newlines) and then use nl2br() to convert newlines
to HTML <br /> tags on display.
That's all good, except for one problem with nl2br():
it doesn't seem to convert \r newlines
(edit: this has now been fixed in PHP 4.2.0).
Windows uses \r\n newlines; *nix uses \n; Mac uses \r.
nl2br() works correctly on text from Windows/*nix
because they contain \n. However, if you get text from a Mac,
nl2br() will not convert its newlines (again, fixed in PHP 4.2.0).
To remedy this, I use the following bit of code
to convert \r\n or \r to \n before inserting it into the database.
It won't hurt anything and ensures that
nl2br() will work on the \n only newlines on display.
Also, it has the side effect of saving 1 byte in the database per newline
from Windows (by storing only \n instead of \r\n). :)
PHP Code:
$txt = preg_replace('/\r\n|\r/', "\n", $txt);
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.119.170.182
討論串 (同標題文章)
完整討論串 (本文為第 2 之 2 篇)：
Web_Design 近期熱門文章
PTT數位生活區 即時熱門文章
-1
12