Re: Help with PHP questions

[Scott <scottgcampbell@xxxxxxxxx>]

Cyndi,

I tried your exact code with several users and several library/table 
combinations and they all worked, even when the user I was connecting 
with had *EXCLUDE authority to the object.  Check the logs in
/usr/local/Zend/core/logs
/usr/local/Zend/apache2/logs

to see if there are any hints there.  Let us know if you find anything.

Scott

PS:
Craig, yes it is supposed to be an assignment.  The assignment is done 
until the last record is read, then the next iteration will return false 
and the loop will end.

Cyndi Bradberry wrote:
> Ok, I am finally getting a chance to work on my PHP book again. I am
> using The IBM I Programmer's Guide to PHP, page 246 figure 8.12 as my
> source code;
>  
> <?php
> //Set the database name
> $tableName = 'SYSTABLES' ;
> $libName = 'QSYS2' ;
>  
> //Create the connection to the System i Relational Database
> if (($dbh = db2_connect('BOISE','OPERIT','ITOPER')) === false) {
>       echo 'connection failed.<br>' ;
>       echo db2_conn_errormsg().'<br>' ;
>       die() ;
> }
>  
> //Retrieve a result set with the column info for the
> //file specified at the top of the script.
> if (($cols = db2_columns( $dbh, null, $libName, $tableName, '%' )) ===
> FALSE) {
>       echo 'colums retrieval failed. <BR>' ;
>       echo db2_stmt_errormsg(). '<BR>' ;
>       die() ;
> }
>  
> //Fetch the first row and output the file name
> // and library name from the result set.
> $column = db2_fetch_assoc($cols) ;
> echo 'FileTable: ' ;
> echo $column["TABLE_SCHEM"]."/".$column["TABLE_NAME"]."<BR>" ;
>  
> //Loop thru all the result set rows and list all the column names.
>  
> do {
>       echo $column["COLUMN_NAME"]."<BR>" ;
> } while ($column = db2_fetch_assoc($cols)) ;
>       
> ?>
>  
> I get a triangle with an exclamation point next to the } while line at
> the bottom of the code, which when I hover over, it shows this:
>  
> Multiple annotations found at this line:
>             - Line Breakpoint: db2Script1.php 
>              [line: 31 ]
>             - bool-assign : Assignment in condition
>  
> The script runs (now, not sure why) and I get this output:
>  
> FileTable: QSYS2/SYSTABLES
> TABLE_NAME
> TABLE_OWNER
> TABLE_TYPE
> COLUMN_COUNT
> ROW_LENGTH
> TABLE_TEXT
> LONG_COMMENT
> TABLE_SCHEMA
> LAST_ALTERED_TIMESTAMP
> SYSTEM_TABLE_NAME
> SYSTEM_TABLE_SCHEMA
> FILE_TYPE
> BASE_TABLE_SCHEMA
> BASE_TABLE_NAME
> BASE_TABLE_MEMBER
> SYSTEM_TABLE
> SELECT_OMIT
> IS_INSERTABLE_INTO
> IASP_NUMBER
> ENABLED
> MAINTENANCE
> REFRESH
> REFRESH_TIME
> MQT_DEFINITION
> ISOLATION
> PARTITION_TABLE
> TABLE_DEFINER
>  
> Should I be able to change to any file/library (Table/Schema) on the
> system and get a list of the columns in the table ?  
> When I change the names in $tableName and $libName, I only get
> FileTable: / as a response.
>  
> I know I have to be missing something simple here. Manual references
> that will explain things are enjoyed.
>  
> Cyndi B.
> Boise, ID