sa_http_php_page( php_page )

This function returns a LONG BINARY value.

To use this system procedure, the PHP external environment must already be installed.

The owner of this system procedure is DBO. However, for improved security, the sa_http_php_page system procedure is executed as the invoker.

None

None

• sa_http_php_page_interpreted system procedure
• Web services functions
• Web services system procedures

The following example submits the phpinfo() query to a PHP interpreter and displays the HTML result.

SELECT CAST( sa_http_php_page('<?php phpinfo(); ?>') AS LONG VARCHAR );

The following example submits a PHP script to a PHP interpreter and displays the XML result.

SELECT CAST( sa_http_php_page('<?php '||
    '$conn = sasql_connect( "UID=DBA;PWD=sql" ); '||
    '$result = sasql_query( $conn, "SELECT * FROM Employees" ); '||
    'sasql_result_all( $result ); '||
    'sasql_free_result( $result ); '||
    'sasql_disconnect( $conn ); '||
    '?>') AS LONG VARCHAR );