Paragraph marks

SameerParker · December 13th, 2004, 04:50 AM

Hi all

I enter information on a page in a "textarea" and can then post to a different page. On the subsequent page I want to store the information in a mysql database with paragraph i.e. "\n" marks. Is there anyway I can get the paragraph formatting into the MYSQL database? When I retrieve the text from the database and put it into the html it doesn't save the line breaks. The line breaks only appear if I put the text into a "textarea" again.

Is there no way way of storing the information from a textarea and putting it into a mysql database and then outputting the information to html (without the use a textarea) and still maintaining the line breaks?

The code i used to test it is as follows...

linetest.php >>>>>>

<html>
<head>
  <title>Test</title>
</head>
<body>
  <form action="linetest1.php" method="post"> <table border="0">
      <tr> <td>Action Plan</td> <td>
      <textarea rows="10" name="ActionPlan"></textarea></td></tr>
    </table> <input type = "submit" value = "now"> </form>
</body>
</html>

linetest1.php >>>>>>>>>>>>>

<?php

  $new_actionplan = addslashes($HTTP_POST_VARS['ActionPlan']);
  echo 'The action plant is: '.$new_actionplan.' </br>';
  echo '<textarea>'.$new_actionplan.'</textarea>';

?>

The output is firstly the text without line breaks. Then the output is a textarea with the text inside. In the second instance the text has linebreaks. I would like the text with linebreaks outside of a textarea.

Any hints would be helpful.

SiliconFuRy · December 13th, 2004, 05:10 AM

Try the combination "\r\n"

Many shoes,

Jamez/SiliconFuRy

SameerParker · December 13th, 2004, 06:57 AM

Hey Jamez

Where would I put the "\r\n"?

Sameer

SiliconFuRy · December 13th, 2004, 07:55 AM

in the file...

linetest1.php >>>>>>>>>>>>>

<?php

  $new_actionplan = addslashes($HTTP_POST_VARS['ActionPlan']);
  echo 'The action plant is: '.$new_actionplan.' </br>';
  echo '<textarea>'.$new_actionplan.'</textarea>';

?>

IF you look at the markup of that page (load it in the browser, file->view source) then you'll see the outputted text outside of the textarea is linebroken. You need to do a string replace for "\n" with "<br>" or "<p>" if you want the linebreaks to be shownin the html output.

Many shoes,

Jamez/SiliconFuRy

Snib · December 13th, 2004, 01:19 PM

I recommend nl2br as an easy way to do this..

Code:

$new_actionplan = nl2br($_POST['ActionPlan']);

-Snib - http://www.snibworks.com
Where will you be in 100 years?

SiliconFuRy · December 14th, 2004, 05:25 AM

ooh, nl2br, you learn something new every day ;)

Many shoes,

Jamez/SiliconFuRy