[SOLVED] mysql newline help

[sasori]

i have this problem when outputing the content of my page,

here's the screenshot

 

 

my database contents is this

 

 

i tried to put "\n" inside the database..and yet nothing happened..it just worsen the output and it output the \n as is

 

[JasonLewis]

Check out nl2br(). You need to convert the new line characters to HTML line breaks.

[sasori]

but sir, the problem is with the data that i input in the database.. its a 3 liner..but when pull it out and output it using PHP,, it produces a single line only

[eddy556]

Why don't you store in the database with <br /> after each line.  This should then format it correctly on the page.

[eddy556]

In addition it looks like you're using your database wrong, surely line should be a different record?  Each tied together with the foreign key (i.e. yours)

[sasori]

it worked with the <br/> tag..i never thought that is possible. thank sir

[eddy556]

no problem, the first topic I've solved  :D :D

[JasonLewis]

No, no, no!

If it's stored in the database as 3 lines, like so:

 

Hey
this is three
lines!

 

Then all you need to do is grab the data from the database and use nl2br() on it. You shouldn't be inserting HTML tags into the database when what it's doing is perfectly normally.

 

So you get your data:

 

$connect = mysql_connect("localhost", "root", "");
mysql_select_db("database");

$query = mysql_query("SELECT textarea FROM table WHERE id='1'") or die(mysql_error()); //just an example query.
$data = mysql_fetch_assoc($query); //Fetch the data

echo $data['textarea']; //This will display it all on one line, which is wrong.

echo "<br /><br />";

echo nl2br($data['textarea']); //After performing the nl2br() function on it it'll convert all \n characters to the HTML equivalent <br />

 

Make sense?

[fenway]

Yes... please DO NOT store <BR> in the DB.

[eddy556]

Okay I agree about not storing <br /> in the database as its actually NOTHING to do with the data being stored, however I'm pretty sure if this is true the whole problem here is attempting to store FORMATTING in the database which is also wrong - if these values are fundamentally seperate (they are all different qualifications) they should be stored within different records.  I am correct?

[sasori]

Check out nl2br(). You need to convert the new line characters to HTML line breaks.

 

thank you very much for the tips.

[JasonLewis]

No worries, just whatever you do... Don't insert HTML into the database.

Good luck with your coding.

 

Oh, one more thing. When inserting data, look into functions like mysql_real_escape_string().