</body>
</html>

<?php

$sql = "SELECT EMPNO, LASNAME, FIRSTNAME, TITLE, TITLE, HOMEPHONE, ADDR1, ADDR2, ZIP, DEPT, WORKPHONE, GENDER, BIRTHDATE, HIREDATE, SALARY";

// Standard DB connection to DB2...
$conn = "*LOCAL"; $name = "emppf";    $pwd = "";
$DB2link = db2_connect($conn, $name, $pwd);
if (!$DB2link)
    echo 'Connection failed: '.db2_stmt_error().' : '.db2_stmt_errormsg();

    
$sql = "SELECT * from phpnn";
    
$stmt = db2_exec($DB2link,$sql)
or die("Failed query:".db2_stmt_error().":".db2_stmt_errormsg());

// Setup table header...
echo '<h1> Employee Database</h1>';
echo '<TABLE BORDER="10" BORDERCOLOR="red"><TBODY BGCOLOR="00FF00">';
echo '<TR><TD><B>EmpNo</TD><TD><B>LastName</TD><TD><B>FirstName</TD>
        <TD><B>Title</TD><TD><B>HomePhone</TD></TR>';
// loop di loop through customer recs...
while($row=db2_fetch_array($stmt)){
list( $Empno, $LasName, $FirstName, $Title, $HomePhone)= $row;        
echo("<TR><TD> {$row[0]}</TD> <TD>$Empno</TD> <TD>$LasName</TD>
        <TD>$Firstname</TD><TD>$Title</TD></TR>");
}

echo '</table>';
db2_close($DB2link);
?>

$sql = "SELECT * from phpnn";

$sql = "SELECT * from EMPFF";

$sql = "SELECT EMPNO, LASNAME, FIRSTNAME, TITLE, TITLE, HOMEPHONE, ADDR1, ADDR2, ZIP, DEPT, WORKPHONE, GENDER, BIRTHDATE, HIREDATE, SALARY";

$sql = "SELECT EMPNO, LASNAME, FIRSTNAME, TITLE, TITLE, HOMEPHONE, ADDR1, ADDR2, ZIP, DEPT, WORKPHONE, GENDER, BIRTHDATE, HIREDATE, SALARY FROM EMPNO";