Re: MAJOR informationleakedoutaboutthefutureofPHPinmeeting I attended.

Stored procedure.

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Kevin Schroeder
Sent: Thursday, April 15, 2010 9:30 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] MAJOR
informationleakedoutaboutthefutureofPHPinmeeting I attended.

Actually, let me back up a bit. Are you trying to call a program or a
stored procedure? If a program, this would be the correct path.
However, if you are calling a stored procedure in the DB it would
probably be better to go down the route of using the DB2 extension.


Kevin Schroeder
Technology Evangelist
Zend Technologies, Ltd.
www.zend.com
www.twitter.com/kpschrade
www.eschrade.com










-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Kevin Schroeder
Sent: Thursday, April 15, 2010 8:20 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] MAJOR information
leakedoutaboutthefutureofPHPinmeeting I attended.

Could you try calling

$stuff = i5_fetch_assoc( $procExec );

I know that's not what the docs say but that just seems more correct.


Kevin Schroeder
Technology Evangelist
Zend Technologies, Ltd.
www.zend.com
www.twitter.com/kpschrade
www.eschrade.com









-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Tom Deskevich
Sent: Thursday, April 15, 2010 8:13 AM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] MAJOR information leaked
outaboutthefutureofPHPinmeeting I attended.


$qUpdateCustomer = "CALL NEWJCLIB/PROC_JC15_ALL( )";
$request = i5_prepare( $qUpdateCustomer );
if( !$request ) var_dump( i5_error( ) );
$procExec = i5_program_call( $request, array() );
if( !$procExec ) var_dump( i5_error( ) );
$stuff = i5_fetch_assoc( $request );
var_dump($stuff) ;


I am to take array() literally?

Or are you telling me to define an array and pass it as a parmameter?
array(8) { [0]=> int(258) [1]=> int(9) [2]=> string(21) "Bad connection
handle" [3]=> string(0) "" ["num"]=> int(258) ["cat"]=> int(9) ["msg"]=>
string(21) "Bad connection handle" ["desc"]=> string(0) "" }

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

Try

$procExec = i5_program_call( $request, array() );


Kevin Schroeder
Technology Evangelist
Zend Technologies, Ltd.
www.zend.com
www.twitter.com/kpschrade
www.eschrade.com










-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Tom Deskevich
Sent: Thursday, April 15, 2010 7:40 AM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] MAJOR information leaked out about
thefutureofPHPinmeeting I attended.

Ok, you switched me from i5_execute to i5_program_call

Here is my code:

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

I get this:

array(8) { [0]=> int(263) [1]=> int(9) [2]=> string(51) "Wrong parameter
count for i5_program_call function " [3]=> string(0) "" ["num"]=>
int(263) ["cat"]=> int(9) ["msg"]=> string(51) "Wrong parameter count
for i5_program_call function " ["desc"]=> string(0) ""


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

Nope. What you are doing is taking the "prepare" resource and trying to
get the result from that. What I believe you want to be doing is taking
the "execute" resource and extracting the result from there.

However, the example that I see in the docs that uses i5_fetch_assoc()
seem to use i5_program_prepare and not i5_prepare. If that is the case
your code should look something like

$request = i5_program_prepare( $qUpdateCustomer );
i5_program_call( $request );
$stuff = i5_fetch_assoc( $request );

If I were to venture a guess it looks like you might have combined the
i5_prepare/execute code with the i5_program_prepare/call logic.

Kevin Schroeder
Technology Evangelist
Zend Technologies, Ltd.
www.zend.com
www.twitter.com/kpschrade
www.eschrade.com










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

I think you meant to put the WAS on the next line down?


-----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.