-
PHP Oracle Errors with Double quotes?
I'm new to Oracle and am trying to pull information from Oracle into a web page.
PHP Version 5.2.1
Apache 2.0.55
When I just do a basic query the results return fine but when I use double quotes in my php to I can include a WHERE statment I start getting errors
here are 2 examples of the code i'm using:
Works But can't use a WHERE statment:
$db_conn = ocilogon("xxxxxx", "xxxxxx", "xxxxxx");
$cmdstr = 'select app_user from application$_user';
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
Doesn't work with Double Quotes in the query:
$db_conn = ocilogon("xxxxxx", "xxxxxx", "xxxxxxx");
$cmdstr = "select app_user from application$_user where app_user = 'BLAH'";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
Any help would be greatly appreciated.
-
here is a copy of the error
Warning: ociexecute() [function.ociexecute]: ORA-00942: table or view does not exist in C:\Program Files\Apache Group\Apache2\htdocs\opera\myconnectiontest7.php on line 7
Last edited by csolano702; 02-14-2007 at 04:15 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|