Re: PHP and table/view names with '$'
| From: | David Robley | Date: | Thu, 23 Apr 2009 10:27:13 +0000 |
| Subject: | Re: PHP and table/view names with '$' | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46133@lists.php.net to get a copy of this message | ||
Mark Casson wrote:
> 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
Try enclosing your query in single quotes so php doesn't try to expand what
it sees as the variable $sql. For example
$stmt = OCIParse($conn, 'SELECT * FROM v$sql');
Cheers
--
David Robley
I am Homer of Borg. Prepare to be assim... mmmm, donuts.
Today is Pungenday, the 40th day of Discord in the YOLD 3175.