How to add a new line in MySql when user hits 'enter' in textarea?

Asked Jul 19 '18 at 21:36

Active Jul 19 '18 at 21:36

Viewed 34 times

Whenever user enters text in textarea field,the data is saved in MySql database using php and ajax.

The problem is that data gets saved in mysql in a straight line without line breaks even if the user hits 'enter'.

Please help me .If you could give code,that would be awesome.

asked Jul 19 '18 at 21:36

Shaheryar ahmed

I'd guess `nl2br` is what you are after. – user3783243 Jul 19 '18 at 21:36
Are you sure the line break is not being saved in the database column? Where are you trying to display it? If it's in HTML you'll need to replace the line break `\n\r` with a `` https://stackoverflow.com/questions/784539/how-do-i-replace-all-line-breaks-in-a-string-with-br-tags – Gabe Gates Jul 19 '18 at 21:42
@user3783243 would it need to place additional
tags at the place where enter was hit? – Shaheryar ahmed Jul 19 '18 at 21:43
@Gabriel I am displaying it in html – Shaheryar ahmed Jul 19 '18 at 21:44
A `
` in place of `\n` should be the same as what was entered. If you want to double space use 2. – user3783243 Jul 19 '18 at 21:44

0 Answers0