Re: Call an as/400 stored procedure and pass a parameter andget a result set back in PHP

Do you have an i5_connect() that you didn't paste in there?


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 08, 2010 11:28 AM
To: web400@xxxxxxxxxxxx
Subject: [WEB400] Call an as/400 stored procedure and pass a parameter
andget a result set back in PHP

I want to call an as/400 stored procedure using PHP and pass a parameter
in,
and process the result set.I have found 10 different ways to do this,
nothing working.

Here is Version 10, release *zero.

$sql='CALL NEWJCLIB/PROC_00001(?)';
$rec=i5_prepare($sql);
i5_bind_Param($req, $statuscode);
i5_execute($req);
i5_bind_result($req, $rs);

Tom Deskevich
Infocon Corporation
Phone 814-472-6066
Fax 814-472-5019