Help with HTML TEXTAREA, PHP and MySQL, not sure where the problem is?

Question

Hi, I am just learning new programming languages and creating a website, not for a company just for my learning but i am stuck in a silly thing. I am using PHP and MySQL. And in HTML i am using TEXTAREA to write huge text. Basically if I write something like this:

This is first line,
This is second line.

When I store the above in MySQL database using TEXT datatype, and try to read it, it comes like this:

This is first line.This is second line.

They don't seem to come in separate lines.
Can you please tell me where the problem is.
Thankyou.

Oh, by the way this is the website i have created, still under construction:
http://www.sentosajaipur.com

But how can a user on my website will put
, in yahoo answer if i press enter, it comes in a new line, so don't know how to do that.

as per what FlpcNerds.com is saying, i know
is for breaking the line, but i know this and people who don't know computers, how can they put
code when writing something in different lines.

Answer 1

Here is a better idea. I think the TEXTAREA return text with newline characters.

You are using php so replace newline characters with
before you store the text in the database. I believe the strtr() function will work.

Another thing you could do is use a specialized text area box meant for editing. There are text boxes out there that will automatically insert Html into the text that you could put in your webpage. I believe you could find one on hotscripts.com

Answer 2

When you read back the form text, you will have to convert line break instances (\n \r or whatever) to
tags before storing the text. Don't forget to escape the string after you alter it.

The line breaks might still be stored even if you don't handle them at post time.
If so, on output you would need to replace them with
tags.

Answer 3

in PHP there is a function n12br($var);
this function transforms every Enter press of the client in br tag...this is the solution to your problem....I'm web designer...if you want to chat with somebody about Web Design my messenger id is: lauriry_1991;
Stock the contain of the textarea in a variable then use the function on it before stocking the text into a database.
Good Luck!

Answer 4

You need the BREAKLINE tag..which is

I do not know exactly if MySQL accepts HTML tags perfectly..

But
is the HTML code for Breakline

example

This is first line,

This is second line.

will appear on a regular page as

This is first line,
This is second line.

Answer 5

A SQL database field ignores the formatting of your web page field. As far as your database knows, it's just a string field. If you want the lines to be separate, you'll have to have separate fields in the database.

Answer 6

Looks like you need a line break - not just pressing enter in your code.

Answer 7

When you read in the values from the db, parse the \r\n & convert it into
.

Answer 8

Try to use preformatted tags

Answer 9

I suggest you to use dreamwaver, it will help you a little,