Re: PHP Result Set/Stored Procedure

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.