Storing a string in a MySQL database

Question

I am using PHP to handle my html forms and a MySQL database to store the data. Users can upload posts on my web app with only one problem. If they use "returns" in the textarea it doesn't come back from the database that way. What can I do so that I store the "returns"?

Example

User Input:

This is a 
string.

Output from the database:

This is a string.

I want the output to match the input.

You might want to check the source code of the page; you _are_ storing the returns. — andrewsi, Dec 16 '13 at 19:29
@Dagon: That question concerned a string in which the newlines were already escaped - not a duplicate of this question. — eggyal, Dec 16 '13 at 19:30
@eggyal well just to lazy to find a real duplicate there are so many. — , Dec 16 '13 at 19:31

score 4 · Answer 1 · answered Dec 16 '13 at 19:29

4

A textarea uses newlines instead of BR's

If you are using PHP, try using 'nl2br()', this converts all the newlines in a textarea to BR's which should fix your content.

EDIT

Use this on your Database output.

answered Dec 16 '13 at 19:29

SidOfc

4,552
3
27
50

Storing a string in a MySQL database

1 Answers1