Re: [PHP-DB] Re: PHP and table/view names with '$'
[email protected] (Christopher Jones)
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
With PHP 5.3 the "nowdocs" syntax will make quoting SQL easier: http://blogs.oracle.com/opal/2008/02/php_53_nowdocs_make_sql_escapi.html Chris Mark Casson wrote: > i was absolutely convinced that i tried to escape the $ and it hadn't worked > and got side tracked looking at other options . . . but yes, that indeed > works perfectly. > > Thanks a lot! > > > ""Yves Sucaet"" <[email protected]> wrote in message > news:007d01c9c404$97d4d1b0$0402a8c0@rincewind... >> Switch back to double quotes? :-) >> >> $stmt = OCIParse($conn, "SELECT * FROM v\$sql WHERE >> INSTR(SQL_TEXT,'something')>0"); >> >> ----- Original Message ----- >> From: "Mark Casson" <[email protected]> >> To: <[email protected]> >> Sent: Thursday, April 23, 2009 6:10 AM >> Subject: [PHP-DB] Re: PHP and table/view names with '$' >> >> >>> Hi, >>> >>> Of course, the next problem is that i want to specify a line to find: >>> >>> $stmt = OCIParse($conn, 'SELECT * FROM v$sql WHERE >>> INSTR(SQL_TEXT,'something')>0'); >>> >>> and i seem to have to use single quotes in the INSTR function. >>> >>> Is there an alternative way to deal with that? >>> >>> Thanks again >>> >>> Mark >>> >>> ""Mark Casson"" <[email protected]> wrote in message >>> news:[email protected]... >>>> Hi, >>>> >>>> I am trying to access some of the v$ views using php on iis, with admin >>>> privileges. >>>> >>>> However, using: >>>> >>>> $stmt = OCIParse($conn, "SELECT * FROM v$sql"); >>>> >>>> gives me this error: >>>> >>>> PHP Notice: undefined variable: sql . . . >>>> >>>> Is there a way around this? >>>> >>>> Thanks >>>> >>>> Mark >>>> >>> >>> >>> -- >>> PHP Database Mailing List (http://www.php.net/) >>> To unsubscribe, visit: http://www.php.net/unsub.php >>> > > > -- Email: [email protected] Twitter: http://twitter.com/ghrd Free PHP Book: http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf