Re: [PHP-DB] MySQL/PHP Form & Addslashes() command
Hello! JJeffman wrote: > There is the "nl2br()" function too : > // From php manual : > > nl2br -- Converts new lines to HTML line breaks. > Description > > string nl2br(string string); > > Returns string with '' inserted before all new lines. > Sure, but never add any html tag to the data before insert into the database. Instead, use this function when you output the text. Mage -- 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] MySQL/PHP Form & Addslashes() command
There is the "nl2br()" function too :
// From php manual :
nl2br -- Converts new lines to HTML line breaks.
Description
string nl2br(string string);
Returns string with '' inserted before all new lines.
HTH
Jayme.
http://www.conex.com.br/jjeffman
-Mensagem Original-
De: Rubanowicz, Lisa <[EMAIL PROTECTED]>
Para: 'James Smith' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Enviada em: sexta-feira, 26 de janeiro de 2001 07:59
Assunto: RE: [PHP-DB] MySQL/PHP Form & Addslashes() command
> I am a beginner but did it like this, with a little help from my friends!!
> $query = "INSERT INTO guests ";
> $query .= "(guest_id, guest_name, ";
> $query .= "guest_email, guest_time, guest_message) ";
> $query .= "values(, '$name', '$email', NULL, '" .
> str_replace("\n","", $message) . "')";
>
> Where $message is the TEXTAREA box submitted
> All the best
> Lisa
>
> -Original Message-
> From: James Smith [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 25, 2001 8:50 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] MySQL/PHP Form & Addslashes() command
>
>
> Alright, you have a textarea in a form, say some one
> right this:
>
> Today, during the meeting blah blah blah... (now they
> want to start a new paragraph, so they press enter
> twice.)
>
> After the construction meeting blah blah blah...
>
> Ok... Now the question. The addslashes() command
> won't add the NULL spots to make it a new paragraph
> when you open this row in a page. How do I get that
> to work...
>
> Thank You,
>
> James Smith
>
> __
> Do You Yahoo!?
> Yahoo! Auctions - Buy the things you want at great prices.
> http://auctions.yahoo.com/
>
> --
> 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]
RE: [PHP-DB] MySQL/PHP Form & Addslashes() command
I am a beginner but did it like this, with a little help from my friends!!
$query = "INSERT INTO guests ";
$query .= "(guest_id, guest_name, ";
$query .= "guest_email, guest_time, guest_message) ";
$query .= "values(, '$name', '$email', NULL, '" .
str_replace("\n","", $message) . "')";
Where $message is the TEXTAREA box submitted
All the best
Lisa
-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 25, 2001 8:50 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL/PHP Form & Addslashes() command
Alright, you have a textarea in a form, say some one
right this:
Today, during the meeting blah blah blah... (now they
want to start a new paragraph, so they press enter
twice.)
After the construction meeting blah blah blah...
Ok... Now the question. The addslashes() command
won't add the NULL spots to make it a new paragraph
when you open this row in a page. How do I get that
to work...
Thank You,
James Smith
__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
--
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]
