How do I get line breaks to carry over from form to database?

Poodle Tosser · #1 (**permalink**) 03-30-04, 01:56 PM

I've created a very simple form using PHP that allows a user to add/delete/update the news items on a homepage.

The form asks a user to enter a Title, Date, and Article which are then uploaded to the corresponding fields in the MySQL database.

My problem is that the line breaks in the Article input area don't carry over to the database. For instance, if I cut and paste a 2 paragraph article from Word into the form, it just shows as one paragraph once it reaches the website.

Is there a way to make sure the appropriate <br> or <p> tags are inserted into the copy on it's way to the database?

I hope this is clear.

Thanks,
Glenn

blaw · #2 (**permalink**) 03-30-04, 09:51 PM

Hi there,

The line break is represented as \n in text format and this will be saved as is in your database. You don't see it (well you do, in a form of line break), but try replacing this thing with <br /> when you output it as HTML. Use str_replace() for this job. It's fast.

HTH.