Re: [PHP-DB] How do I get a ' in my sql statement?
Terry, Thanks for the tip on the nl2br function. That function proved to be very helpful when displaying data in a HTML table. I noticed the \n is ok when sending text to a form with multiline input boxes. Thanks, Blaine >>> Terry Romine <[EMAIL PROTECTED]> 06/10/02 02:35PM >>> Any text field that has the possibility of getting quotes should be handled by $textfield = addslashes($textfield); prior to insert. Then on displaying, use $textfield = stripslashes($textfield); If it is a big text (including paragraphs) I use $textfield = nl2br(stripslashes($textfield)); On Monday, June 10, 2002, at 12:40 PM, Daniel Brunner wrote: > Hello!! > > Spit some code out...I put a lot of ' in my inserts... > > Is it from a form?!?!!? > > Is it from a Insert, or Select or Update?!? > > That's why we need some code... > > > Dan > > > On Monday, June 10, 2002, at 12:01 PM, [EMAIL PROTECTED] wrote: > >> I have noticed that when I try to assign the value of a input field >> that has a ' in it for example : It will goof up my attempt >> to load the information to the database. Anyone know a way around >> this? Do I have to send each string through a parsing routine before >> assigning my string to a variable that will be used in a SQL statement? >> >> >> Thanks, >> >> Blaine >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> Terry Romine Web Developer JumpInteractive.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How do I get a ' in my sql statement?
Any text field that has the possibility of getting quotes should be handled by $textfield = addslashes($textfield); prior to insert. Then on displaying, use $textfield = stripslashes($textfield); If it is a big text (including paragraphs) I use $textfield = nl2br(stripslashes($textfield)); On Monday, June 10, 2002, at 12:40 PM, Daniel Brunner wrote: > Hello!! > > Spit some code out...I put a lot of ' in my inserts... > > Is it from a form?!?!!? > > Is it from a Insert, or Select or Update?!? > > That's why we need some code... > > > Dan > > > On Monday, June 10, 2002, at 12:01 PM, [EMAIL PROTECTED] wrote: > >> I have noticed that when I try to assign the value of a input field >> that has a ' in it for example : It will goof up my attempt >> to load the information to the database. Anyone know a way around >> this? Do I have to send each string through a parsing routine before >> assigning my string to a variable that will be used in a SQL statement? >> >> >> Thanks, >> >> Blaine >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> Terry Romine Web Developer JumpInteractive.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] How do I get a ' in my sql statement?
Hello!! Spit some code out...I put a lot of ' in my inserts... Is it from a form?!?!!? Is it from a Insert, or Select or Update?!? That's why we need some code... Dan On Monday, June 10, 2002, at 12:01 PM, [EMAIL PROTECTED] wrote: > I have noticed that when I try to assign the value of a input field > that has a ' in it for example : It will goof up my attempt > to load the information to the database. Anyone know a way around this? > Do I have to send each string through a parsing routine before > assigning my string to a variable that will be used in a SQL statement? > > > Thanks, > > Blaine > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] How do I get a ' in my sql statement?
I have noticed that when I try to assign the value of a input field that has a ' in it for example : It will goof up my attempt to load the information to the database. Anyone know a way around this? Do I have to send each string through a parsing routine before assigning my string to a variable that will be used in a SQL statement? Thanks, Blaine -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php