Robert J. Hanson - 2001-11-09

I am developing an application using Apache 1.3.14-6, PHP 4.0.6 and MySQL 3.23.40 on a Linux system.  I have an index page that passes 2 variables (UserID) & (PassWD) to a php page for processing against the database.

Example 1 from index page:
<form action="testbox.php" method="post">
        UserID:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" name="UserID"><br><br>
        Password:&nbsp;&nbsp;&nbsp;<input type="password" name="PassWD"><br><br>
        <input type="Submit" name="Submit" value="OK">&nbsp;&nbsp;&nbsp;&nbsp;<input type="reset" name="Cancel" value="Cancel">
</form>

The following is the php code that I am passing the variables to.

<?php

echo $UserID;
echo $PassWD;
$Appl = substr($UserID,0,3);
echo $Appl;

  include ( "/usr/local/httpd/php/include/db_mysql.inc" );
  class MySQLDBTest extends DB_Sql
  {
    var $Host           ="localhost";
    var $Database       ="winsids02";
    var $User           ="bpsidad1";
    var $Password       ="jlync09";
  }
  function GetGenOpts( $aTablename, $aCurSel = "" )
  {
    $aResult = "";
    $aDB = new MySQLDBTest;
    $aSQL = "select applic from $aTablename where applic_group = 'bps';";
    $aDB->query ( $aSQL );
    while ( $aDB->next_record() )
    {
      $aApplic    = $aDB->f( "applic" );
      if ( $aApplic == $aCurSel )
      {
        $aResult .= "<option value=\"$aApplic\"selected>$aApplic</option>";
      }
      else
      {
        $aResult .= "<option value=\"$aApplic\">$aApplic</option>";
      }
    }
    return $aResult;
  }
?>

  <html>

  <head>

    <title>Form Test.</title>
  </head>

  <body>

  <p><br></p>

        <table width=500 border=1 bgcolor="aqua" align="center">
                <tr>
                        <td align="center" valign="middle">
                        <div align="center">WINS Teradata UserID Request Form</div><br>
                        </td>
                </tr>
        </table>

  <p><br></p>

  <form action="some_place.phtml" method="post">

    <table>

      <tr>

        <td>
          Application:
        </td>

        <td>
          <select name="last_name" size="3" multiple>
          <?php
                print ( GetGenOpts( "applic_groups", "Applic" ) );
          ?>
          </select>
        </td>

      </tr>

    </table>

  </form>

  </body>

  </html>

The problem is that I can not pass the $UserID and $PassWD variables to the (var $User) and (var $Password) variables in the db_mysql.inc portion of the php code.

Any suggestions on how to accomplish this would be greatly appreciated.