text insertion
| From: | Chris Stinemetz | Date: | Wed, 10 Aug 2011 18:34:54 +0000 |
| Subject: | text insertion | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-314463@lists.php.net to get a copy of this message | ||
How do I preserve text formatting when text is inserted into a database table?
For example: I am using a textarea to allow users to leave comments
into the database and I am using:
'" . mysql_real_escape_string($_POST['store_comments']) . "', to
prevent SQL injection;
But when I call the data with php from the database the format it was
inserted is not preserved. Is there a way to make sure when a user
adds new paragraphs or indentation it will be preserved?
Thank you,
Chris