PHP - How to echo a code as a text

Question

Now I got a query that contains HTML code and when I select it in php it makes the code,

$query = mysql_query("SELECT * FROM `table`")or die(mysql_error());
while($arr = mysql_fetch_array($query)){
$num = mysql_num_rows($query);
$code = $arr ['code'];
echo $code;
}

and in that query there is this code <a href="http://google.com">Click Here</a>

when it echo it shows me Click Here, But I want it to sows me the code.

So how can I do that in PHP.

Thanks
Klaus

Answer 1

Use htmlspecialchars() to prevent HTML elements from being interpreted by the browser.

$query = mysql_query("SELECT * FROM `table`")or die(mysql_error());
while($arr = mysql_fetch_array($query)){
    $num = mysql_num_rows($query);
    $code = $arr ['code'];
    echo htmlspecialchars($code);
}

Answer 2

Just encode the output with htmlspecialchars

$query = mysql_query("SELECT * FROM `table`")or die(mysql_error());
while($arr = mysql_fetch_array($query)){
$num = mysql_num_rows($query);
$code = $arr ['code'];
echo htmlspecialchars($code);
}