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