Re: How can web PHP and SQL change the IBM i library list?

[Alfredo Delgado <adelgado@xxxxxxxxxxxxxxxxx>]

Pardon me for replying to myself, but for the sake of discussion and full
disclosure, I do know where the i5 toolkit is available outside of Zend
Core. http://www.easycom-aura.com/en/eac_php.asp

I just don't have any experience using it outside of Zend Core and paying
for it directly.

Alfred

On Thu, Apr 23, 2009 at 13:15, Alfredo Delgado
<adelgado@xxxxxxxxxxxxxxxxx>wrote:

> You're welcome, Eric. I assumed you were discussing Zend Core on i5 so the
> rest of this response presumes that's the case. I don't know that the i5
> toolkit is available outside of that.
>
> Here's another link to some lads who are using chglibl because setting
> I5_OPTIONS_INITLIBL didn't work for them. In my situation I rely on others
> to set the library list on the user and that wasn't working in my SQL
> queries but setting I5_OPTIONS_INITLIBL worked.
>
>
> http://www.ibuildings.nl/blog/archives/62-PHP-for-IBM-i5-how-to-control-your-library-list-from-PHP.html
>
> It sounds like you'd like to pass one more info to your developer about the
> differences in the calls. Here's an example of making a query and dumping
> the rows to the page.
>
> i5_pconnect( SYSTEM, USER, PASSWORD, array( I5_OPTIONS_INITLIBL=>'PROD
> STAGE QA' ) );
>
> $request = i5_prepare( "SELECT * FROM Table WHERE Key  = ?" );
> i5_setparam( $request, 0, 12345 );
> i5_execute( $request );
>
> while( $currentRow = i5_fetch_assoc( $request )  )
>     var_dump( $currentRow );
>
>
>
>
> On Thu, Apr 23, 2009 at 12:22, <elehti@xxxxxxxxxxxxxxxxxx> wrote:
>
> > Thank you Alfredo Delgado and Matt Haas, for your answers.
> > EricL
> >
> > --
> > 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