"; } function HTML_Foot() { echo ""; } function Output_Entries() { /* Make the connection to the excessbase. The syntax is odbc_connect( 'SYSTEM_DSN' , 'USER', 'PASSWORD' ); $cnx will hold the pconnect is used to establish a persistent excessbase connection to the excessbase until the procedure is completed. */ $cnx = odbc_connect( 'HelpDesk' , '', '' ); if (!$cnx) { Error_handler( "Error in odbc_connect" , $cnx ); } // send a simple odbc query . returns an odbc cursor $cur= odbc_exec( $cnx, "select ID,FirstName,LastName,partNum,serial,location,description,Date from excess" ); if (!$cur) { Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx ); } $nbrow=0; //Local variable to count number of rows echo "". "\n"; while( odbc_fetch_row( $cur )) { $ID= odbc_result( $cur, 1 ); // get the field "Index" $FirstName= odbc_result( $cur, 2 ); // get the field "FirstName" $LastName= odbc_result( $cur, 3 ); // get the field "LastName" $PartNum= odbc_result( $cur, 4 ); // get the field "PCatagory" $serial= odbc_result( $cur, 5 ); // get the field "describe" $location= odbc_result( $cur, 6 ); // get the field "date" $description= odbc_result( $cur, 7 ); // get the field "date" $Date= odbc_result( $cur, 8 ); // get the field "date" $nbrow++; echo "". "\n"; } odbc_close( $cnx); } echo "
IDExcess Procedure Requested byDOJ Part NumberSerial NumberDatelocationDescription
$ID\n$FirstName$PartNum$serial$Date$location$description
"; // close the connection. important if persistent connection are "On" function Error_Handler( $msg, $cnx ) { echo "$msg \n"; odbc_close( $cnx); exit(); } HTML_Head(); Output_Entries(); HTML_Foot(); print "
"; ?>

 

O.C.M. Excess I.T. Equipment Report

 


CopyRight 2004
QuickIntranet.com
http://www.QuickIntranet.com