mysql中 怎么显示字段中的换行符_在HTML中显示mysql换行符

Certain fields in our mysql db appear to contain newline characters so that if I SELECT on them something like the following will be returned for a single SQL call:

Life to be sure is nothing much to lose

But young men think it is and we were young

If I want to preserve the line breaks when displaying this field on a webpage, is the standard solution to write a script to replace '\n\r' with a br HTML tag or is there a better way?

Thanks!

解决方案

Assuming PHP here...

nl2br() adds in
for every \n. Don't forget to escape the content first, to prevent XSS attacks. See below: