Re: Calling a stored procedure from PHP, they can't make this stuff any easier.

Does something like this not work for you?

e.g.

$qUpdateCustomer = "CALL SP_INSERT_F550101Z( ?, ?, ? )";
$request = i5_prepare( $qUpdateCustomer );
i5_setparam( $request, 0, $transactionId );
i5_setparam( $request, 1, 'C' );
i5_setparam( $request, 2, $_POST['ABALPH'] );
i5_execute( $request );

--
Alfredo Delgado / Web Development
6800 Broken Sound Pkwy, Suite 150
Boca Raton, Florida 33487

-----web400-bounces@xxxxxxxxxxxx wrote: -----

To: "'Web Enabling the AS400 / iSeries'" <web400@xxxxxxxxxxxx>
From: "Tom Deskevich" <thomas.l.deskevich@xxxxxxxxxxxxx>
Sent by: web400-bounces@xxxxxxxxxxxx
Date: 04/12/2010 16:33
Subject: [WEB400] Calling a stored procedure from PHP, they can't make
this stuff any easier.

I know I have asked about this in other posts, but am desperate.
I have never got an answer in my past posts.

I put about 20 hours into trying to call a stored procedure from the
as400 so far using PHP. I have tried i5_ commands and Db2_ commands. I
have googled till I am googley eyed. Of the handful of examples I have
found, none work.

I created the stored procedure with iseries navigator. I am assuming it
shortens the name because it is now called PROC_00001. But that object
has never been called. So I know my call the stored procedure call has
NEVER been successful.

Connection:
require_once('Connection.php');
try {
$conn = new Connection();
} catch (Exception $e) {
echo "Failure to connect";
echo $e->getMessage();
die();

I do get past this with no errors.

The i5 and db2 examples are such a mess, I cannot really include them
because they have been changed so much to try to make them work, I am
not even sure how they started out.

Please help!

Thanks.

Tom Deskevich

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [1]http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [2]http://archive.midrange.com/web400.

References

Visible links
1. http://lists.midrange.com/mailman/listinfo/web400
2. http://archive.midrange.com/web400