<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/REC-html40/loose.dtd">
<html>
<head>
<meta name="generator" content="HTML Tidy, see www.w3.org">
<title>DBMS function test</title>
<link href="/styles/cs1.css" rel="stylesheet">
</head>
<body>
<h1>Db2 Function Test</h1>

<p>These examples generate dynamic search query forms for the
VENDOR table using the functions found in <a href= 
"/fragments/db2func.pinc">db2func.pinc</a> (see <a href= 
"/fragments/db2func.phps">db2func.phps ) prettyprint source</a>
<?php
     require("db2func.pinc");
    //connect 
    $user = "";  // the account webserver runs as is the user
    $upasswd="";
   
    $conn = odbc_pconnect("DBMS", $user,$upasswd ); 

     
?></p>

<h2>Select Functions</h2>

<h3>Tests: <code>function makeOption ($intConn,$strTable,$strColumn
)</code></h3>

<form action="db2funcresult.phtml" method="GET">
<input type="hidden" name="testtype" value="selecttest">
<select name="VEN_CODE">
<?php 
    makeoption($conn,"CIS3311.VENDOR","VEN_CODE"); 
?>
</select> 

<p><input type="submit" value="Search"></p>
</form>

<h3>Tests: <code>function makeOptionLong($intConn,$strTable,$strColumn1,$strColumn2)</code></h3>

<form action="db2funcresult.phtml" method="GET">
<input type="hidden" name="testtype" value="selecttest">
<select name="VEN_CODE">
<?php
   makeoptionLong($conn,"CIS3311.VENDOR","VEN_CODE","VEN_NAME"); 
?>
</select> 

<p><input type="submit" value="Search"></p>
</form>

<h2>Checkbox Functions</h2>

<h3>Tests: <code>function makeCheck($intConn, $strTable,
$strColumn,$names="")</code>
</h3>
<p>Note: <code>$names</code> is blank in this test.</p>
<form action="db2funcresult.phtml" method="GET">
<input type="hidden" name="testtype" value="checktest1">
<?php

    makeCheck($conn,"CIS3311.VENDOR","VEN_CODE");

?> 
<input type="submit" value="Search"></form>

<h3>Tests: <code>function makeCheck($intConn, $strTable,
$strColumn,$names="")</code><br>
</h3>
<code>$names</code> is "VenCode[]" in this test.

<form action="db2funcresult.phtml" method="GET">
<input type="hidden" name="testtype" value="checktest2">
<?php

    makeCheck($conn,"CIS3311.VENDOR","VEN_CODE","VenCode[]");

?> 
<input type="submit" value="Search"></form>

<h3>Tests: <code>function makeCheckArray($intConn, $strTable,
$strColumn,$names="")</code><br>
</h3>
<p><code>$names</code> is "VenCode[]" in this test.</p>
<form action="db2funcresult.phtml" method="GET">
<input type="hidden" name="testtype" value="checktest2">

<?php

$checkList=array();
$checkList=
makeCheckArray($conn,"CIS3311.VENDOR","VEN_CODE","VenCode[]");
while ($box = next($checkList)) {
    print "$box <br>\n";
}
?> 
<input type="submit" value="Search">
</form>

<?php @odbc_close($conn); ?>
<hr>
<p align="center"> <a href="demos.phtml"> demos</a></p>
</body>
</html>