php - 为什么mysql文本包含`[`会损坏html css格式

Question

I insert some text contain [ (only one parentheses, not include ] ), then when I use mysql query to the front php page, the [ will damage html css format.

$result = mysql_query("SELECT * FROM mytable Order By date DESC LIMIT 10");  
while ($row = mysql_fetch_array($result))
{
echo '<div class="text">'.$row['content'].'</div>';
}

I notice the html output source code.

before the [ text, the html is correct,

<div class="text">this is a test, no parentheses</div>

but after [ text, the html looks as

<div class=&#8221;text&#8221;>this is a test, contain [ </div>

How many symbols will cause the faults like this? and how to avoid? Thanks.

Answer 1

Are you using htmlentities or htmlspecialchars anywhere? As a sidenote, you should probably be doing something like this as well:

echo '<div class="text">'.htmlspecialchars($row['content'], ENT_QUOTES).'</div>';