[PHP] Single Quotes in Oracle Queries
Before we go about writing new functions to handle single quotes for our Phorum reengineering project, I need to know if there is a way for PHP to easily handle the issue of passing strings to a PL/SQL script, which requires that single quotes be doubled up: that "I don't know" is properly translated into "I don''t know". In my dreams, this is handled by OCIParse or even OCIExecute, but I have a sinking feeling that this isn't the case, and that we'll need to do an extra parsing step for all of our strings that are inserted into the database, just for single quotes. Help! Richard -- PHP General 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] Single Quotes in Oracle Queries
Where are the strings coming from? If from a FORM, then magic_quotes_sybase (in php.ini) is your friend. If from elsewhere, see magic_quotes_runtime for possible help (also in php.ini). Kirk -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 12:05 PM To: [EMAIL PROTECTED] Subject: [PHP] Single Quotes in Oracle Queries Before we go about writing new functions to handle single quotes for our Phorum reengineering project, I need to know if there is a way for PHP to easily handle the issue of passing strings to a PL/SQL script, which requires that single quotes be doubled up: that "I don't know" is properly translated into "I don''t know". In my dreams, this is handled by OCIParse or even OCIExecute, but I have a sinking feeling that this isn't the case, and that we'll need to do an extra parsing step for all of our strings that are inserted into the database, just for single quotes. Help! Richard -- PHP General 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 General 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] Single Quotes in Oracle Queries
The quotes are indeed coming from a FORM. I'll look into magic_quote_sybase. Thanks! Original Message On 4/11/01, 11:19:26 AM, "Johnson, Kirk" [EMAIL PROTECTED] wrote regarding RE: [PHP] Single Quotes in Oracle Queries: Where are the strings coming from? If from a FORM, then magic_quotes_sybase (in php.ini) is your friend. If from elsewhere, see magic_quotes_runtime for possible help (also in php.ini). Kirk -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 12:05 PM To: [EMAIL PROTECTED] Subject: [PHP] Single Quotes in Oracle Queries Before we go about writing new functions to handle single quotes for our Phorum reengineering project, I need to know if there is a way for PHP to easily handle the issue of passing strings to a PL/SQL script, which requires that single quotes be doubled up: that "I don't know" is properly translated into "I don''t know". In my dreams, this is handled by OCIParse or even OCIExecute, but I have a sinking feeling that this isn't the case, and that we'll need to do an extra parsing step for all of our strings that are inserted into the database, just for single quotes. Help! Richard -- PHP General 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 General 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 General 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]