Hi John,

The buttons at the bottoms of the main form are really submit statements within submit tags like:

#### Four headings for the four columns of the table####

print "<tr style='text-align:$FORM{'headalign'};
color:$FORM{'headbackcolor'};
background-color:$FORM{'headforecolor'};
font-family:$FORM{'headfont'}; font-size:$FORM{'headfontsize'};
font-style:$FORM{'headfontstyle'};
font-weight:$FORM{'headfontweight'};'>";
print "<td>Your Account</td>";
print "<td>Go Shopping</td>";
print "<td>Administration</td>";
print "<td>Other</td>";
print "</tr>";

####Four columns of submit buttons####

if ( $FORM{'userlogged'} eq "t" ) {

   print "<tr>";
   print "<td align='center'>";
   print "<input type=submit name='menu_choice' value='New Account'><BR>";
   print "<input type=submit name='menu_choice' value='Find Account'><BR>";

   print "<input type=submit name='menu_choice' value='Edit Account'><BR>";
   print "</td>";

   print "<td align='center'>";
   print "<input type=submit name='menu_choice' value='Shop'><BR>";
   print "<input type=submit name='menu_choice' value='Check Out'><BR>";
   print "<input type=submit name='menu_choice' value='Sales'><BR>";
   print "</td>";

   print "<td align='center'>";
   print "<input type=submit name='menu_choice' value='Products'><BR>";
   print "<input type=submit name='menu_choice' value='Shipping'><BR>";
   print "<input type=submit name='menu_choice' value='CRC'><BR>";
   print "<input type=submit name='menu_choice' value='Tax Authorities'><BR>";
   print "<input type=submit name='menu_choice' value='Create DB'><BR>";
   print "</td>";

			
   print "<td align='center'>";
   print "<input type=submit name='menu_choice' value='Email password'><BR>";
   print "<input type=submit name='menu_choice' value='Clear/Reset'><BR>";
   print "<input type=submit name='menu_choice' value='New Session'><BR>";
   print "<input type=submit name='menu_choice' value='Help'><BR>";
   print "</td>";
   print "</tr>";
  
}
else {

When one of the buttons is clicked, the form with all its input is submitted through the "action post" part of the form, so all the input needed to perform lookups and determine which columns to include in the output will be passed to the next form being called.

Most forms usually only have two buttons at the bottom of each form labeled [Submit} [Clear/Reset].


If you click on the Demo Help button, a help window appears that discloses the Administrator's user name and password to use with the demo. Once the Admin user name and password are entered, you can gain access to forms that allow administration, like adding or deleting products, establishment of sales/VAT Taxes, Revenue Center, etc. Info to login as administrator for the demo app are:

    Administrator    demouser
    password         demopw

When I'm done with the cart application, I would like to modify it, so the app can also be used with MySQL, MSSQL, and VFP when VFP is ready. I don't know how the port to MySQL is going to go, because I've used a lot of foreign key constraints to enforce referential integrity throughout the app. Referential integrity if a piece of cake using Postgresql. Incidentally, phpPgAdmin Version 3.2 has just been released. I downloaded it and installed it this afternoon. It has a GUI to created constraints for RI; although, my shopping cart app has a program to create all the tables, users, constraints, inserted records, indexes, etc with a simple click of a button. It only requires that the administrator have an empty table setup and ready to go, and of course a user with privileges necessary to create tables, sequences, etc.

I really like the three tier approach and being disconnected from the database server. The app only connects to the db server long enough to fetch/update/insert/delete/etc and then immediately disconnects. This makes the app very stable and scalable.

Regards,

LelandJ