formatting text (as html) before submitting to database

dealspecialist

I am sorry if I'm not clear, but I'm not sure how to word this...

I am using a form to submit content to be inserted into a mysql database.

This submitted content will be displayed as content on a web page.

I wanted the line breaks ( 's) to be automatically generated when the content is submitted (sort of like how forum postings work). Anyone have any suggestions on how I would go about doing this?

Thanks in advance,
Dealspecialist

bubblocity

IS the only tag that is your concern?

If yes, instead of string HTML in your databse, just store it as plain text. From a textarea box, a line break will store in the database as chr(13).

When you pull it back out to display, apply the nl2br() function to your string.

But if there are other tags, then maybe you want to look for one of those JavaScript Formatting Bars like on this forum...

cheese

Hi Deal,

Following on from bubblocity's comment this is a stock line of code I use for adding 's in to db output;


print "<p>" . str_replace("\n","<br>",$row[3]) . "</p>"; // $row[3] being the output from your query.....

Cheers,

Neil.

laserlight

this is a stock line of code I use for adding 's in to db output

bubblocity suggested [man]nl2br/man, you should use it too.

cheese

Hi Laserlight,

I agree with you, use nl2br(). My problem was (for what ever reason) it didn't work, that's why I wrote a bit of stock code, which always seems to work......

Cheers,

Neil.

dealspecialist

I think adding 's or 's should be sufficient. The only other thing I would need is 's, but I think the users can figure that out.

I give your ideas a try tonight and see how it works out. Thanks for the suggestions.

dealspecialist

Worked wonderfully. Thanks everyone!!!😃