Re: html ina text feild
It doesn't make any difference B.J.Rumsey wrote: B: Sorry should of given more infromation. I'm using Roxen 2.1 as my web B: server and am using the roxen emit tag to call the information. B: B: -Original Message- B: From: Carl Troein <[EMAIL PROTECTED]> B: To: [EMAIL PROTECTED] B: Date: Fri, 30 Nov 2001 10:22:34 GMT B: Subject: Re: html ina text feild B: B: > B: > sherzodR writes: B: > B: > > No, you don't have to change the type of field. If you want more HTML B: > > embedded, you could save those HTMLs together w/ the text in your B: > > database, or... if you just want the tags, then, assuming your B: > > text has a new line character (\n), you have to do some sort of B: > substitution. B: > B: > Ah, the joys of communication. This was probably closer to what it was B: > he wanted to know than my reply. B: > B: > In PHP, there's htmlentities() and nl2br() which are useful in various B: > situation. Or... one could just allow users to type in any html and B: > see what happens. :-o B: > B: > //C - doesn't trust users. B: > B: > -- B: > Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 B: > [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ B: > Amiga user since '89, and damned proud of it too. B: > B: > B: > - B: > Before posting, please check: B: >http://www.mysql.com/manual.php (the manual) B: >http://lists.mysql.com/ (the list archive) B: > B: > To request this thread, e-mail <[EMAIL PROTECTED]> B: > To unsubscribe, e-mail B: > <[EMAIL PROTECTED]> B: > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php B: > B: B: B: B: - B: Before posting, please check: B:http://www.mysql.com/manual.php (the manual) B:http://lists.mysql.com/ (the list archive) B: B: To request this thread, e-mail <[EMAIL PROTECTED]> B: To unsubscribe, e-mail <[EMAIL PROTECTED]> B: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php B: -- sherzodR <[EMAIL PROTECTED]> use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: html ina text feild
Sorry should of given more infromation. I'm using Roxen 2.1 as my web server and am using the roxen emit tag to call the information. -Original Message- From: Carl Troein <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Fri, 30 Nov 2001 10:22:34 GMT Subject: Re: html ina text feild > > sherzodR writes: > > > No, you don't have to change the type of field. If you want more HTML > > embedded, you could save those HTMLs together w/ the text in your > > database, or... if you just want the tags, then, assuming your > > text has a new line character (\n), you have to do some sort of > substitution. > > Ah, the joys of communication. This was probably closer to what it was > he wanted to know than my reply. > > In PHP, there's htmlentities() and nl2br() which are useful in various > situation. Or... one could just allow users to type in any html and > see what happens. :-o > > //C - doesn't trust users. > > -- > Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 > [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ > Amiga user since '89, and damned proud of it too. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: html ina text feild
sherzodR writes: > No, you don't have to change the type of field. If you want more HTML > embedded, you could save those HTMLs together w/ the text in your > database, or... if you just want the tags, then, assuming your > text has a new line character (\n), you have to do some sort of substitution. Ah, the joys of communication. This was probably closer to what it was he wanted to know than my reply. In PHP, there's htmlentities() and nl2br() which are useful in various situation. Or... one could just allow users to type in any html and see what happens. :-o //C - doesn't trust users. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: html ina text feild
Webmaster writes: > I've set up a database with a text feild and want to call that > information with html code embeded into the text( eg. ). Do I need > to change the type of field ?. At the moment the html code is being > returned as plain text. An HTML document is just a sequence of bytes, as is any other data that a computer handles. A TEXT field holds such a sequence and does absolutely no conversion of it. You're not giving a lot of information on what you're trying to do and what goes wrong, but most likely what you get out is exactly what you put in. Could it be that you've done some unwanted pre- or postprocessing of your data, such as escaping some HTML entities? //C - vague -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: html ina text feild
No, you don't have to change the type of field. If you want more HTML
embedded, you could save those HTMLs together w/ the text in your
database, or... if you just want the tags, then, assuming your
text has a new line character (\n), you have to do some sort of substitution.
Forexample, in Perl you could do the following:
my $text = $dbh->selectrow_array("SELECT text_field FROM table_name WHERE id=?",
undef, $id);
$text =~ /\n//g;
Webmaster wrote:
W: I've set up a database with a text feild and want to call that
W: information with html code embeded into the text( eg. ). Do I need
W: to change the type of field ?. At the moment the html code is being
W: returned as plain text.
W:
W:
W:
W: -
W: Before posting, please check:
W:http://www.mysql.com/manual.php (the manual)
W:http://lists.mysql.com/ (the list archive)
W:
W: To request this thread, e-mail <[EMAIL PROTECTED]>
W: To unsubscribe, e-mail <[EMAIL PROTECTED]>
W: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
W:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
html ina text feild
I've set up a database with a text feild and want to call that information with html code embeded into the text( eg. ). Do I need to change the type of field ?. At the moment the html code is being returned as plain text. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
