Writing "textarea" to MySQL then displaying in an array

[jonnyboy]

I am creating a message board. I am trying to find the difinitive answer on the following:-

In my textarea, what should I use with regard to wraps so that I won't present long strings of text?

wrap="hard"?

How do I then bring out the data into the format it was keyed? Just like on these forum pages?

i.e.

Line 1
Line 2
Line 3

And a line space if required?

Any help greatly appreciated!

Jonathan

[daphreeek]

If your textarea's text is stored in a variable called $test then use the following line:

$test=eregi_replace("\n","<br>", $test);

That will format it so each newline in the textarea has an HTML <br> so it displays correctly.

I use the following function so that I get smileys as well:

function forum_format_text($test) {
	$test = strip_tags($test, "<b> </b> <i> </i> <font> </font>");
	$test=stripslashes($test);
	$test=eregi_replace(":\)","<img src='images/smile.gif' alt=':\)' border=0>", $test);
	$test=eregi_replace(":\\(","<img src='images/frown.gif' alt=':\\(' border=0>", $test);
	$test=eregi_replace(";\)","<img src='images/wink.gif' alt=';\)' border=0>", $test);
	$test=eregi_replace(":\p","<img src='images/tounge.gif' alt=':\p' border=0>", $test);
	$test=eregi_replace(":\o","<img src='images/gasp.gif' alt=':\o' border=0>", $test);
	$test=eregi_replace(":\x","<img src='images/angry.gif' alt=':\x' border=0>", $test);
	$test=eregi_replace("\n","<br>", $test);

return $test;
}

//Call funtion:
$test = forum_format_text($test);

Don't forget to make the images for each smiley and put them in a dir.

Hope that helps 🙂
- Matt

[jonnyboy]

Thanks

I maybe being dumb, but:

I output this in the array...

//Print the main message body
echo "\n<tr>\n\t<td bgcolor=\"white\">" .
"<font color=\"black\">" .
$row["message_text"] .
"</td>\n</tr>";

How and where do I insert your code to make it work?

Also, do I need to do anything with the textarea form element that I am writing from?

Thanks

Jonathan

[daphreeek]

//Print the main message body 
echo "\n<tr>\n\t<td bgcolor=\"white\">" . 
"<font color=\"black\">" . 
forum_format_text($row["message_text"]) . 
"</td>\n</tr>"; 

that should work. if not, try this:

//Print the main message body 
$tmp = $row["message_text"];
echo "\n<tr>\n\t<td bgcolor=\"white\">" . 
"<font color=\"black\">" . 
forum_format_text($tmp) . 
"</td>\n</tr>"; 

• Matt