Member Avatar for Nahiyan

I have one MySQL database field which saves comment from users. Some comments have new lines but when I try to use PHP to display the contents of the database, the new lines are ignored. I know about nl2br() but I guess it will not work as my users will not bear to write /n or /r/n or /r.

My column type is LONGINT and another problem is that if quotation marks exist in the comment, the comment doesn't get stored in the database.

I have more information to provide, I use textarea and use "POST" method.

I want reply as soon as possible.

  • 3 Contributors
  • 3 Replies
  • 203 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Nahiyan
Member Avatar for Shanti C

another problem is that if quotation marks exist in the comment, the comment doesn't get stored in the database.

for this use addslashes($str);

Member Avatar for pzuurveen

are your comment text?
The u can't store them in a longint. Just use TEXT as ur column type
If there are numerical i don't see the problem with new lines

Member Avatar for Nahiyan

I changed my column type to TEXT. Sorry my column's type was LONGTEXT before.
I have used nl2br in a different way and now it works :D

Edited by Nahiyan because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.