Re: Calling Stored procedure from PHP

With Easycom for PHP (or PHP i5 ToolKit), when a query returns result sets, you need to call i5_next_result() once, before to fetch, unless you set I5_OPTIONS_AUTOMATIC_NEXT_RESULT when connecting.
See documentation pages at
http://www.easycom-aura.com/Data/WebHelp/PHP/api_functions/sql_queries___procedures/i5_next_result.htm
If you don't do it, i5_fetch() will return output parameters values.
This is a compatibility issue because of WAMP and LAMP applications running the ToolKit as it, for many years.

Ask Easycom technical support : tech@xxxxxxxxxxxxxxxx

Regards

Sylvain Rubele
AURA Equipements
http://www.easycom-aura.com

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Kevin Schroeder
Sent: Thursday, April 15, 2010 7:42 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] MAJOR information leaked out about the future of
PHPinmeeting I attended.

Maybe I'm missing something here but shouldn't it be

$qUpdateCustomer = "CALL NEWJCLIB/PROC_JC15_ALL( )";
$request = i5_prepare( $qUpdateCustomer );
if( !$request ) var_dump( i5_error( ) );
$procExec = i5_execute( $request );
if( !$procExec ) var_dump( i5_error( ) );
$stuff = i5_fetch_assoc( $procExec ); <-- Was
i5_fetch_assoc( $request );
var_dump($stuff) ;

Here is my code:
$qUpdateCustomer = "CALL NEWJCLIB/PROC_JC15_ALL( )";
$request = i5_prepare( $qUpdateCustomer );
if( !$request ) var_dump( i5_error( ) );
$procExec = i5_execute( $request );
if( !$procExec ) var_dump( i5_error( ) );
$stuff = i5_fetch_assoc( $request ); <<== already has $request
var_dump($stuff) ;

ANYWAY, I changed it to what I think you meant ($procexec) and now I get
bool(false) shown.

Tom Deskevich
Insane with anger.