Automatic <br>

[pndof12006]

Ok, I am starting a poetry website and when users submit a new poem they currently need to add a [code]<br>[/code] at the end of each line. is it possible to make it so when the form is submitted it automatically puts the breaks in the databse?

[trillion]

something like this maybe:

[code]$var = $_POST[poem]."<br/>";[/code]

then put  $var into the database insert query

[pndof12006]

but that will not put the [code]<br>[/code]at the end of each line of a poem.

[akitchin]

look up nl2br() in the php manual.

[pndof12006]

that doesn't help me, from what it looks like u have to have a \n in order for that to work.

[akitchin]

.. a newline character, you mean?  because that's EXACTLY what hitting enter in a text field does.  why don't you actually try using it before claiming it won't work?

[pndof12006]

well the thing is, when it's submitted and inserted into the DB there is no characters that are /n.

[akitchin]

you won't see them because they get converted into the actual linebreaks you see.

[code]echo nl2br($value_pulled_from_db);[/code]

try that.

[pndof12006]

didn't work.

[pndof12006]

when it gets inserted in the DB it is in the same format it ws in the text area. example

SAMPLE
SAMPLE

will show like that in the Text Area and in The DB, But when echoed to a page it is like this:

SAMPLE SAMPLE

[akitchin]

then let's see:

a) the MySQL select query that grabs the value from the database
b) the PHP code that echoes nl2br() of that value

[Daniel0]

pndof12006: Let me explain how it works:

\n (LF - line feed) - Linux uses this to display a new line
\r (CR - carriage return) - Macintosh use this to display a new line
\n\r (CRLF - carriage return, line feed) - Windows uses this to display a new line

[url=http://php.net]nl2br[/url] converts LF to [tt][nobbc]<br />[/nobbc][/tt]. If you want to convert all types of new lines to \n, then use this: [code]$string = preg_replace("/(\r\n|\r|\n)/","\n",$string);
$string = nl2br($string);[/code]

Or perhaps even better: [code]$string = preg_replace("/(\r\n|\r|\n)/","<br />\n",$string);[/code]

[pndof12006]

Daniel it didn't work.

[Daniel0]

Try to post the script that posts the poem.

[pndof12006]

[code]$p = preg_replace("/(\r\n|\r|\n)/","\n",$poem);
echo "<tr><td align='center'><b>$pname</b></td></tr>";
echo "<tr><td>&nbsp;</td></tr>";
echo "<tr><td align='center'>";
echo $p;
echo "</td></tr>";
echo "<tr><td>&nbsp;</td></tr>";[/code]

[akitchin]

you forgot the additional nl2br() if you're going to go with his first suggestion.

[code]echo nl2br($p);[/code]

[pndof12006]

still doesnt do nething

[akitchin]

try this:

[code]echo "<tr><td align='center'><b>$pname</b></td></tr>";
echo "<tr><td>&nbsp;</td></tr>";
echo "<tr><td align='center'>";
echo nl2br($poem);
echo "</td></tr>";
echo "<tr><td>&nbsp;</td></tr>";[/code]

[pndof12006]

doesn't do nething, still shows SAMPLE SAMPLE

[akitchin]

alright, give these a shot then:

[code]$p = preg_replace("/(\r\n|\r|\n)/","<br />\n",$poem);
echo $p;[/code]

[code]$p = preg_replace("/(\\r\\n|\\r|\\n)/","<br />\n",$poem);
echo $p;[/code]

[pndof12006]

alright, finally... It Works... Thanks Guys...

[xsist10]

You'll probably find that his code strips \n before inserting it into the database or that his database stores line breaks as \r only.