RE: [PHP-DB] MySQL/PHP Form Addslashes() command

2001-01-26 Thread Rubanowicz, Lisa

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","br", $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]



Re: [PHP-DB] MySQL/PHP Form Addslashes() command

2001-01-26 Thread JJeffman

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 'BR' 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","br", $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

2001-01-26 Thread Mage

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 'BR' 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]