I am running into a problem where users insert their data into a textarea, which is then sent to a corresponding table in Heidisql. When the user clicks on the print button, it recalls the information to be printed. However, all the paragraph breaks and formatting, which is still present in Heidi, is lost upon the recall. I keep finding little bits on explode, does anyone have any advice on what I can do to stop the condensing of text and losing all the formatting? Thanks.
mgn2683 0 Junior Poster in Training
phper 9 Posting Whiz in Training
Hi,
Heidisql is just your GUI that displays data from your MySQL database. If you post again use MySQL so people now what DB your using.
When you submit that data to the database are the, for example: "<BR/>", being saved? Or is it just pure text?
Regards,
Alex.
nav33n 472 Purple hazed! Team Colleague Featured Poster
Use nl2br() to retain the format.
vssp -5 Junior Poster
use htmlentities
mgn2683 0 Junior Poster in Training
Ok now I have been able to format the text in the blob by using the convert- New lines to BRs in the dynamic text window. It keeps all the formatting except for apostrophes and quotations. Is there any secondary formatting that I could add to recognize and retain the quotations? Any help is greatly appreciated.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.