How can i escape the XML syntax

[fekaduw]

hello everyone,

 

i have a textarea where users can input information about themselves. They can even edit the texts (making the texts bold, italic...). It works fine when i try to add the info into the db. But when i try to display the info from the db, it displays some characters like \\\\" whatever. I used stripslashes, but it didn't solve the problem. What do you advise me so that i can handle the XML  special characters not to disturb my design??

 

[trq]

Are you using addslashes on the data before you are submitting it to the db? And if so... are you checking to see if magic_quotes_gpc is enabled beforehand. eg;

 

<?php

  if (!get_magic_quotes_gpc()) {
    $data = addslashes($data);
  }

?>

 

If magic_quotes_gpc is enabled, there is no need to use addslashes.

[fekaduw]

i used the mysql_real_escape_string($data) rather than the addslashes

[trq]

Take a look at example 1428 here. You may need to apply something similar.