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

[Alfredo Delgado <adelgado@xxxxxxxxxxxxxxxxx>]

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.