Re: Calling Stored procedure from PHP

[Glenn Hopwood <ghopwood.list@xxxxxxxxx>]

No luck for me. I'll send an email to the support line.

Glenn

On 4/15/2010 12:12 PM, Sylvain Rubele wrote:
> 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.