phpmysqlformattingnl2br

Formatting is all screwed up on MySQL record when pulling with nl2br

Take a look here: http://www.sw-bfs.com/index.php?siteid=t_rules&id=5

It is adding weird diamond like shapes and removing formatted text like from the original body. The database uses UTF8 and I am using nl2br in PHP to pull the record. Any suggestions on how to fix it?

EDIT:

Using this code here:

  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

Seems to have fixed the weird formatting, but the website is still not showing anything in between such as that is in the text. Any thoughts on how to repair that then? I am assuming this is caused by the nl2br perhaps?

Solution

  • Try,

    htmlspecialchars($data_string, ENT_QUOTES, 'UTF-8');

    OR You can add in head section,

        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

    Thanks.