close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Text formatting

Thread began 10/17/2012 9:00 am by colinlangley441259 | Last modified 10/22/2012 5:48 pm by colinlangley441259 | 1506 views | 14 replies |

colinlangley441259

Text formatting

Hi,
I could you tell me how you keep the text formatting when using mysql and php as when the page uses the data held in the database i lose all formatting such as paragraphs?

Sign in to reply to this post

Jason ByrnesWebAssist

I dont follow, can you please provide more details.

Sign in to reply to this post

colinlangley441259

hi sorry,
im trying to make a php news page. I have a page to allow me to upload the text to the mysql database however on the actual news page itself when it brings the text back from the database all the text has lost any paragraph spacing and other formatting such as bold or italic text which it originally had prior to going into the database. I hope that makes slightly more sense.

Sign in to reply to this post

Jason ByrnesWebAssist

send a copy of the news insert page and a link where i can see the news article online to troubleshoot.

Sign in to reply to this post

colinlangley441259

Hi Jason,
The input page is manage_news.php?
and the page it shows up on is legacy.php

If you see the test content i have put in i originally had paragraph spaces etc before it went into the database and when it came back out the text has no formatting.

Sign in to reply to this post

Jason ByrnesWebAssist

In the insert record behavior, when selecting the binding for the text area, select the formatting option to convert new lines to BR tags. See the attached screen shot.

Sign in to reply to this post

colinlangley441259

sorry jason how do you get to the insert record behaviour? do i take it this can be changed even though the pages are already made?

Sign in to reply to this post

Jason ByrnesWebAssist

go to the server behaviors panel, and double click the insert record behavior to edit it.

Sign in to reply to this post

colinlangley441259

thanks i have changed this but its still taking multiple spaces and paragraphs out

Sign in to reply to this post

Jason ByrnesWebAssist

instead of using a textarea, use an HTML Editor field to give rich text editing capabilities.

replace the text area with an HTNL Editor filed.

webassist -> forms -> HTML Editor

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...