Re: PHP Result Set/Stored Procedure

You're welcome, but keep in mind that I was using PHP4 in PASE, not Zend
Core. Wanting to consume SQL result sets from RPG and PHP via store
procedures is sound practice so you have better functionality at your
disposal with the official release.

I've been meaning to contact Zend for Zend Platform. The mileage on "I'm too
busy to upgrade" is starting to run out :)

On Tue, Jul 1, 2008 at 9:35 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

Hi Alfredo -

Thanks for the response. I've been attempting to use i5_Prepare and
i5_Execute, while I see you used an ODBC call. Let me study your
solution a bit and I'll get back to you.

- Michael

On Tue, Jul 1, 2008 at 9:19 AM, Alfredo Delgado
<adelgado@xxxxxxxxxxxxxxxxx> wrote:

What's the nature of the difficulties you've run into? Do you have any

code

to share? (http://code.midrange.com)

I've used stored procedures with PHP on IBM i before Zendcore and it took
some extra steps back then. I haven't done it in a while but we can

probably

help if you can provide more details.

I documented how I called an RPG program as an external stored procedure
back in 2006:
http://www.i5php.net/index.php?name=Forums&file=viewtopic&p=775#775

On Tue, Jul 1, 2008 at 8:55 AM, Michael Ryan <michaelrtr@xxxxxxxxx>

wrote:

I've been trying to return a result set from a stored procedure into a
PHP script. My idea behind this was to enable both display file
programs and PHP programs to access the same business logic. I would
take an existing program, break out the business logic into a stored
procedure that returns a result set, and then access that stored
procedure from either an RPG program or a PHP script. However, I can't
get this to work, and Zend can't/won't either.

So here's my question: Is this a bad idea? What's a better approach? I
want to be able to produce 'something' that could be accessed by
either a display file program or a PHP script. I know I could create a
file as an intermediate step, but that seems so kludgy. Ideas?
Comments? Catcalls?

Thanks!
--
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: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
Alfredo Delgado / Web Development
6800 Broken Sound Pkwy; Suite 150
Boca Raton, Florida 33487
T: (561) 443-9152
C: (561) 350-4143
F: (561) 443-9108
--
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: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
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: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.