Re: PHP Result Set/Stored Procedure

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

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.