a MySQL question i guess

[mina_gabriel84]

i would like to ask if i insert a data from a textarea with the following formating :
<textarea name='text'>this IS a test
text area </textarea>
and the we insert this textarea to database :
INSERT INTO mytable (textarea)VALUES ('$_post[text]');
the textarea attribute is a LONGTEXT not a VARCHAR
thats what i have made already

the question is if u select this text to te display how u can dsplay it with the same formating
cause if i SELECT * FROM mytable
and the we
echo $row[0];
i get that (this is a test text area )
this is not the working code i have just invent it i have the working one and it works good

[cahva]

You mean newlines that do not show if you just print it out. You can use nl2br() funtion to do that.

[mina_gabriel84]

like what u have done ----> u send me a message and it will be called from the databse (keeping the text font color and evey thing else pluse the entering )

what i mean is if a user type any this in that text area the code save what ever have been typed in the database

like

--hi iam a new user and my name is ------------
--mina and iam 25 plaplapla ------------

--thnx for adding me pla plapla ------------

imagine this is the textarea
you will save this in to the database in a longtext attribute
when select this text to be display in another page from database
u will get
--hi iam a new user and my name ismina and iam 25 plaplapla thnx for adding me pla plapla ------------------
losing the formattion
so how can i keep this formation in the data base

[_uk_stuff]

It is like cahva says.

when you select from the database and echo the result to the screen just wrap the element within the nl2br function i.e.

$RS = mysql_query(SELECT * FROM mytable);
$row = mysql_fetch_array($RS);
echo nl2br($row[0]);

This way it would display exactly as entered into the original TextArea.

[halojoy]

before you insert,

use

1. text= if get_magic_quotes_gpc() then stripslashes($_POST['text'])
2. text = mysql_real_escape_string(text)
3. INSERT into mysql field
   ========
   When pull it back from Database:
   You can use:
4. text = mysq result row['textarea']
5. $output = htmlspecialchars('text');
6. echo $output;
   ========================

not only will your text have a good format.
But it will be more secure, if you take it as a good rule to use:
[man]mysql_real_escape_string[/man]
This function is to prepare any String to have the correct and SAFE Format
for insert into a MySQL database Field

Study and read howto use those functions
Notice all those Examples from readers posted comments!
[man]get_magic_quotes_gpc[/man]
[man]stripslashes[/man]
[man]mysql_real_escape_string[/man]

[man]mysql_query[/man]
[man]htmlspecialchars[/man]
[man]echo[/man]

😉
why not be very basic,
even if you and I know several of these things more than well, since before

Back To Basics
... thinks halojoy 🙂