Re: Help with PHP questions

Should this line be assignment:

} while ($column = db2_fetch_assoc($cols)) ;

or comparison:

} while ($column == db2_fetch_assoc($cols)) ;



----- Original Message ----- From: "Cyndi Bradberry" <CyndiB@xxxxxxxx>
To: <WEB400@xxxxxxxxxxxx>
Sent: Monday, August 24, 2009 2:56 PM
Subject: [WEB400] Help with PHP questions

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 --
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.