Re: [PHP-DB] TEXT fields without line breaks

2001-07-06 Thread John S. Huggins 

The line breaks may be there, but HTML will not render them.

Try this:

  $outputstring = nl2br($stringfromDB);

  print(p$outputstring/p);

or something like this to see if the newlines will convert to br and
render correctly.

John

On Fri, 6 Jul 2001, Mat Marlow wrote:

-Hi all,
-(I'm not sure if this is the right place to submit this but I'm having
-problems with the php.general group)
-
-I am in desperate need for a solution to HTML text fields not storing new
-lines. I'm storing news articles in a database but all the text just ends up
-in a big block because it ignores line breaks. Is there a way around this
-without having to upload text files?
-
-Thanks,
-
-Mat
-
-
-
-
-
--- 
-PHP Database Mailing List (http://www.php.net/)
-To unsubscribe, e-mail: [EMAIL PROTECTED]
-For additional commands, e-mail: [EMAIL PROTECTED]
-To contact the list administrators, e-mail: [EMAIL PROTECTED]
-

**

John Huggins
Virginia Net Corporation
7101 Oriole Avenue
Springfield, VA 22150
703-912-6214
703-912-4831 fax

[EMAIL PROTECTED]
http://www.va.net/

**


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] TEXT fields without line breaks

2001-07-06 Thread Kevin Johnson 



Ive encountered this at my last job and we were using perl as our backend.
Before inserting into the database, check for \n or \r and replace with
a combo of chars that are mostly likely not to be typed into the text field.
Examples: ][, or |43; or whatever...
Then when you reread back from the database and output the data, swap your 
special newline chars with \n.

A bit of a pain, but it works.

Kevin Johnson
KJ

-Original Message-
From: Mat Marlow [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 06, 2001 8:42 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] TEXT fields without line breaks


Hi all,
(I'm not sure if this is the right place to submit this but I'm having
problems with the php.general group)

I am in desperate need for a solution to HTML text fields not storing new
lines. I'm storing news articles in a database but all the text just ends up
in a big block because it ignores line breaks. Is there a way around this
without having to upload text files?

Thanks,

Mat





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]