[RESOLVED] Using Forms

[QuizToon]

Hi all

hope you can help me out of what seems a little problem, but its driving me nuts.

I have a form which a user completes and it inserts the information into a database, no problems there.

When displaying the data, again no problem calling the information. One of the fields is a comment field. How do I make the form creat the information with line breaks so that when it is displayed it displays in paragraphs rather than in a block.

eg - it displays like this at the moment

Duis, velit facilisi, accumsan magna, quis. Vel euismod diam eros volutpat te commodo aliquam duis vero tation suscipit sit. Esse ut odio, ad consequat velit enim ad facilisi autem nulla. Amet accumsan lobortis, ut iriure, vulputate, vero praesent accumsan eu vel quis quis autem wisi eros. Ex, dignissim augue commodo, hendrerit consequat et augue odio ea ut tation odio iriure veniam eum. Vulputate exerci te. Dolore vel, blandit at qui veniam illum molestie minim veniam consequat eum at in, iusto luptatum ex, in esse et. Ut iusto nulla dolore exerci

eg - i want it to display this way

Duis, velit facilisi, accumsan magna, quis. Vel euismod diam eros volutpat te commodo aliquam duis vero tation suscipit sit. Esse ut odio, ad consequat velit enim ad facilisi autem nulla.

Amet accumsan lobortis, ut iriure, vulputate, vero praesent accumsan eu vel quis quis autem wisi eros. Ex, dignissim augue commodo, hendrerit consequat et augue odio ea ut tation odio iriure veniam eum.

Vulputate exerci te. Dolore vel, blandit at qui veniam illum molestie minim veniam consequat eum at in, iusto luptatum ex, in esse et. Ut iusto nulla dolore exerci

So whene the user inputs their comments and uses their return key it is reflected in that database field and also when it is displayed.

I hope you follow this and I hope someone can stop the splinters under my fingernals from all the head scratching 🙂

Thanks in advance

[Piranha]

Use nl2br(). An example when have the string in $text:

$text = nl2br($text);
echo $text;

[QuizToon]

Thanks for the assistance

Not sure i understand you, where does this go and if my field is called $comment is that what i put instead of where you have put text?

[fh47331]

Although I'm new to PHP, I think i'm right in saying that these things all follow the same principals!

Somewhere in the page after your form you will commit the data to the database. Presuming you are doing this through SQL INSERT statements, you'll have something like

$sql = "INSERT INTO tablename (userresponse) VALUES ($comment)";

You would need something like the following (apologies if my concatination isn't right!)

$sql = "INSERT INTO tablename (userresponse) VALUES (".nl2br($comment).")";

That way the system will process the line breaks in what ever is contained within $comment when it adds the data to the database.

[Piranha]

Ok, I have to explain it a little more. It should not be used when you insert to the database but when you write it to the webpage. Like this:

$sql = "SELECT notes FROM test LIMIT 1";
//Code to get the notes into $notes
echo nl2br($notes);

I hope that this is easier to understand. If not please look at http://www.php.net/manual/sv/function.nl2br.php

Edit: It is possible that you can do this before storing it in the database as well. I haven't tried, so I don't know. Just try it out and see if it works or not.

[QuizToon]

thanks guys, worked a treat