Re: php code from plsql using owa htp.p

Frank van Bortel wrote:
> marvado_at_hotmail.com wrote:
>
>>Hi Dietmar,
>>
>>thanks for the tip, but I'm using exactly UTL_HTTP for that with htp.p
>>and it doesn't seem to be showing back the php result.
>>This is what I have in a plsql package:
>>
>>begin
>> htp.p('phpinfo();');
>>end;
>>
>>it gives me a blank page when I call the package from the browser. What
>>I expect is to see the environment variables for PHP with the
>>phpinfo(); function call.
>>
>>my setup:
>>- oracle 9i
>>- Oracle's HTTP Server with Apache 1.3
>>- php 5
>>
>>anything I'm missing?
>>thanks.
>>
>
>
> 1) Your browser requests http://yourserver/plsql_dad/your_procedure
> 2) Apache by Oracle recognizes the plsql_dad bit, and hands the request
> off to mod_plsql.
> 3) mod_plsql has some login processing, define in the Database
> Access Descriptor (dad), but will eventually call your procedure.
> 4) Your procedure sends the string phpinfo(); back to mod_plsql, that
> faithfully hands it off to Apache, that will send it back to your
> browser.
> 5) Your browser does not understand phpinfo(); and displays a blank
> page. Hint: check page source
>
> What did *I* forget here? Do you understand the sequence of
> events above? If you do, you should be able to understand why
> you do not get what you expected.
>
> Now, as we already established, I know nothing about php, but it
> seems to me, that:
> 1) Your browser needs to send phpinfo(); (not *receive* it)

PHP is a server-side language. The browser never sees the PHP code, and cannot "send" phpinfo().

> 2) And it needs to be sent to the php environment, not the
> Oracle pl/sql stack.
>

Yes. I'm not sure how to do it (I don't know mod_plsql) - but the code needs to be processed throught the PHP parser as well as mod_plsql.

> So, we're back at what was suggested before: link those two.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex_at_attglobal.net
==================