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

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