note 112588 added to pdo.quote
| From: | lalithaprasad dot velamuri at verizon dot com | Date: | Tue, 02 Jul 2013 09:27:04 +0000 |
| Subject: | note 112588 added to pdo.quote | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-195431@lists.php.net to get a copy of this message | ||
Hello,
I am unable to fetch information from "systables" from an external schema. Find below
query which I am trying to execute from PHP
"SELECT * FROM {schema_name}:systables"
When we pass this query to "prepare" function then it is failing because we used column(:)
in the FROM part. The reason is we can't bind values to identifiers like tables and columns.
But here my intention is not to bind the table name but to refer a table in that schema.
Is there a way that I can run this query in PHP. I tried several ways but no use and also I posted
it in other forums but no one is able to reply. Please provide me a solution asap.
--
Regards,
Lalith
----
Server IP: 69.147.83.199
Probable Submitter: 103.22.239.215
----
Manual Page -- http://php.net/manual/en/pdo.quote.php
Edit -- https://master.php.net/note/edit/112588
Del: integrated -- https://master.php.net/note/delete/112588/integrated
Del: useless -- https://master.php.net/note/delete/112588/useless
Del: bad code -- https://master.php.net/note/delete/112588/bad+code
Del: spam -- https://master.php.net/note/delete/112588/spam
Del: non-english -- https://master.php.net/note/delete/112588/non-english
Del: in docs -- https://master.php.net/note/delete/112588/in+docs
Del: other reasons-- https://master.php.net/note/delete/112588
Reject -- https://master.php.net/note/reject/112588
Search -- https://master.php.net/manage/user-notes.php