Preserve Line Breaks From TextArea When Writing To MySQL

Question

I m using a textarea to enable users to input comments   However  if the users enters new lines  the new lines don t appear when they are outputted   Is there any way to make the line breaks stay   Any idea how do preserve the line breaks

User · Answer

Got my own answer   Using this function from the data from the textarea solves the problem   function mynl2br  text        return strtr  text  array   r n    gt    lt br   gt      r    gt    lt br   gt      n    gt    lt br   gt            More here  http   php net nl2br

User · Answer

function breakit  t        return nl2br htmlentities  t  ENT QUOTES   UTF-8         this may help you  pass the textarea wal

User · Answer

This works   function getBreakText  t        return strtr  t  array    r  n    gt    lt br gt       r    gt    lt br gt       n    gt    lt br gt

User · Answer

Two solutions for this    PHP function nl2br     e g    echo nl2br  This r nis n ra nstring r        will output This lt br   gt  is lt br   gt  a lt br   gt  string lt br   gt   Wrap the input in  lt pre gt  lt  pre gt  tags   See  W3C Wiki - HTML Elements pre

User · Answer

why make is sooooo hard people when it can be soooo easy        here is the pull from the form  your form text     POST  your form text        line 1 fixes the line breaks - line 2 the slashes  your form text   nl2br  your form text    your form text   stripslashes  your form text      email away  message    Comments   your form text   mail  destination email whatever com    Website Form Submission    message   headers     you will obviously need headers and likely have more fields  but this is your textarea take care of

User · Answer

Here is what I use   textToStore   nl2br htmlentities  inputText  ENT QUOTES   UTF-8        inputText is the text provided by either the form or textarea   textToStore is the returned text from nl2br and htmlentities  to be stored in your database  ENT QUOTES will convert both double and single quotes  so you ll have no trouble with those

User · Answer

i am using this two method steps for preserve same text which is in textarea to store in mysql and at a getting time i can also simply displaying plain text      step 1   status   POST  status    lt br  gt   textToStore   nl2br htmlentities  status  ENT QUOTES   UTF-8      In query enter  textToStore     step 2   write code for select query   and direct echo values      It works

[php] Preserve Line Breaks From TextArea When Writing To MySQL

Examples related to php

Examples related to mysql

Examples related to html