Still trying to understand the new version of the client. Was saving the
script to my C: drive instead of my mapped one to HTDOCS. But anyway,
still does not work, here is the log using your example Alfredo.
i5_setparam() [<a href='function.i5-setparam'>function.i5-setparam</a>]:
Parameter 1 must be a ressource but a bool was passed\n in
i5_execute() [<a href='function.i5-execute'>function.i5-execute</a>]:
Parameter 1 must be a ressource but a bool was passed\n in /ww
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of ADelgado@xxxxxxxxxxxxxxxxxx
Sent: Monday, April 12, 2010 4:54 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] 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
midrange.com
