<pre> 
#!/usr/bin/env python3
#=====================================================================================
# Get data from an html form
# Validate the data
# Store in a database
#=====================================================================================
import HTTPparam                        #to obtain HTTP parameters
import pymysql as mydb                  #Mysql 3x database driver
import re                               #regular expressions

print("Content-Type: text/html \n")    #required http response header (w/ extra line)

fn_error,   ln_error,   addr_error          = '','',''
brnd_error, flav_error, top_error, cc_error = '','','',''
msg = '' 

params = HTTPparam.getAll()                         #obtain the http parameters

firstname  = params.get('firstname')  or ""         #text field             
lastname   = params.get('lastname')   or "" 
address    = params.get('address')    or ""         #textarea
brand      = params.get('brand')      or "" 
flavor     = params.get('flavor')     or ""         #could be a list
topping1   = params.get('topping1')   or ""         #checkboxes
topping2   = params.get('topping2')   or "" 
topping3   = params.get('topping3')   or "" 
topping4   = params.get('topping4')   or "" 
creditCard = params.get('creditCard') or ""         #radio button
    
        
"""===================================================================================
 function validate():
      validates the content of the html form input fields (all fields are required)    
==================================================================================="""
def validate():                                     #function validate

    global fn_error,ln_error,addr_error,brnd_error,flav_error,top_error,cc_error
    global msg
        
    if firstname=='' : fn_error   = '*'             
    if lastname==''  : ln_error   = '*'
    if address==''   : addr_error = '*'
    if brand==''     : brnd_error = '*'
    if flavor==''    : flav_error = '*'
    if topping1==''  and topping2=='' and topping3=='' and topping4=='' : top_error = '*'
    if creditCard=='': cc_error  = '*'
        
    if fn_error or ln_error or addr_error or brnd_error or flav_error or top_error or cc_error:
        msg = 'Please correct error fields above' 

"""===================================================================================
 function display():
          display the web form   
==================================================================================="""
def display(): 

    global fn_error,ln_error,addr_error,brnd_error,flav_error,top_error,cc_error
    global msg

    print(F'''
        &lt;!DOCTYPE html>
        &lt;html>
        &lt;head>
        &lt;title>Full HTML entry from&lt;/title>
        &lt;style>                                                                 /* double {{ will print a single one */
            fieldset {{width:580px; height:320px; border-color:gold; border-radius:10px;}} 
            table    {{width:570px; background-color:lightgray; border:1px solid black; border-radius:10px;}}       
            input, textarea, select  {{ border-radius:5px}}
            select   {{width:180px}}                                      
            span     {{color:red}}
         &lt;/style>
        &lt;/head>
        &lt;body bgcolor="lightyellow">
        &lt;h1>&lt;center>The Ice Cream Shop&lt;/center>&lt;/h1>
        &lt;h3>Response is on the same page&lt;/h3>
        &lt;form name="form1" method="POST" action=formToDB.cgi>             &lt;!--the name of the current Python script-->
        &lt;fieldset>
        &lt;legend>Enter Fields Below&lt;/legend>    
        &lt;table>
            &lt;tr>&lt;td>&lt;b>Enter First Name &lt;span> {fn_error} &lt;/span>
                &lt;td>&lt;input type="text" name="firstname" value="{firstname}">
            &lt;tr>&lt;tr>&lt;td>&lt;b>Last Name &lt;span> {ln_error} &lt;/span>
                &lt;td>&lt;input type="text" name="lastname" value="{lastname}">
            &lt;tr>&lt;td>&lt;b>Enter Address &lt;span> {addr_error} &lt;/span>
                &lt;td>&lt;textarea name="address" rows="4" cols="45">{address}&lt;/textarea>
    ''')     
    print('&lt;tr>&lt;td>&lt;b>Choose a Brand &lt;span>' + brnd_error + '&lt;/span>')  #select list (single)
    print('&lt;td>&lt;select name="brand">')                                  
    print('&lt;option value="">---choose from below---&lt;/option>')
    print('&lt;option value="BR"',end='')
    if brand =='BR': print('selected',end='')
    print('>Baskin-Robbins &lt;/option>')
    print('&lt;option value="BJ"',end='')
    if brand =='BJ': print('selected',end='')
    print(">Ben & Jerry's&lt;/option>")
    print('&lt;option value="C"',end='')
    if brand =='C': print('selected',end='')
    print('>Carvel&lt;/option>')
    print('&lt;option value="CS"',end='')
    if brand =='CS': print('selected',end='')
    print('>Cold Stone&lt;/option>')
    print('&lt;option value="HD"',end='')
    if brand =='HD': print('selected',end='')
    print('>Haagen-Dazs&lt;/option>')
    print('&lt;option value="H"',end='')
    if brand =='H': print('selected',end='')
    print(">Hershey's&lt;/option>")
    print('&lt;/select>')
    
    print('&lt;tr>&lt;td>&lt;b>Ice Cream Flavor &lt;span>' + flav_error + '&lt;/span>')     #select list (with multiple option)
    print('&lt;td>&lt;select name="flavor" SIZE="4" multiple>')
    print('&lt;option value="vanilla"',end='')
    if 'vanilla' in flavor: print('selected',end='')
    print('>Vanilla&lt;/option>')
    print('&lt;option value="chocolate"',end='')
    if 'chocolate' in flavor: print('selected',end='')
    print('>Chocolate&lt;/option>')
    print('&lt;option value="strawberry"',end='')
    if 'strawberry' in flavor: print('selected',end='')
    print('>Strawberry&lt;/option>')
    print('&lt;option value="butter-pecan"',end='')
    if 'butter-pecan' in flavor: print('selected',end='')
    print('>Butter Pecan&lt;/option>')
    print('&lt;option value="rocky-road"',end='')
    if 'rocky-road' in flavor: print('selected',end='')
    print('>Rocky Road&lt;/option>')
    print('&lt;option value="french-vanilla"',end='')
    if 'french-vanilla' in flavor: print('selected',end='')
    print('>French Vanilla&lt;/option>')
    print('&lt;option value="pistachio"',end='')
    if 'pistachio' in flavor: print('selected',end='')
    print('>Pistachio&lt;/option>')
    print('&lt;/select>')
    
    print('&lt;tr>&lt;td>&lt;b>Select Topping &lt;span>' + top_error + '&lt;/span>&lt;td>')    #checkbox
    print('&lt;input type="checkbox" name="topping1" value="hotFudge"',end='') 
    if topping1 !='': print('checked',end='')
    print('> Hot Fudge')
    print('&lt;input type="checkbox" name="topping2" value="sprinkles"',end='')
    if topping2 !='': print('checked',end='')
    print('> Sprinkles')
    print('&lt;input type="checkbox" name="topping3" value="nuts"',end='')
    if topping3 !='': print('checked',end='')
    print('> Nuts')
    print('&lt;input type="checkbox" name="topping4" value="whippedCream"',end='')
    if topping4 !='': print('checked',end='')
    print('> Whipped Cream')
    
    print('&lt;tr>&lt;td>&lt;b>Credit Card &lt;span>' + cc_error + '&lt;/span>&lt;td>')        #radio button
    print('&lt;input type="radio" name="creditCard" value="MC"',end='')
    if creditCard =='MC': print('checked',end='')
    print('>   Master Card')
    print('&lt;input type="radio" name="creditCard" value="VISA"',end='') 
    if creditCard =='VISA': print('checked',end='')
    print('> Visa')
    print('&lt;input type="radio" name="creditCard" value="AMEX"',end='') 
    if creditCard =='AMEX': print('checked',end='')
    print('> American Express')
    print('&lt;input type="radio" name="creditCard" value="DISC"',end='') 
    if creditCard =='DISC': print('checked',end='')
    print('> Discover')
    
    print('''
        &lt;tr>
        &lt;td width=140px>
        &lt;tr>
        &lt;td colspan=2>
        &lt;input type="submit" value="  Place Order  "  >
        &lt;input type="reset"  value="Cancel"           >
        &lt;/table>
    ''')
    
    print("&lt;p style='color:red'>" + msg + '&lt;/p>')    
    print("&lt;/fieldset>")
    print("&lt;/form>")
    print("&lt;/body>")
    print("&lt;/html>")

"""===================================================================================
 function saveDB():
          save data to Database    
==================================================================================="""
def saveDB():                                       #save to database
        
    global msg

    if firstname == '': return
    
    flavors = flavor
    if type(flavor) is list:
        flavors = ','.join(flavor)                  #join an array using commas 

    toppings = ''
    if topping1 : toppings += topping1 +','         #join all the values for toppings 
    if topping2 : toppings += topping2 +','
    if topping3 : toppings += topping3 +','
    if topping4 : toppings += topping4 +','
    toppings = re.sub(r",$", "", toppings)          #strip off the last comma for the array 

    sql  = "INSERT INTO cust_order " 
    sql += "VALUES("+ str(0) +",'"+ firstname +"','"+ lastname +"','"+ address    +"'"
    sql +=                    ",'"+ flavors   +"','"+ toppings +"','"+ creditCard +"'," + str(1) +")"

    try:    
        conn  = mydb.connect(host='localhost',user='demo2',password='demo2',database='demo2')   #connect to host

        cursor = conn.cursor()                  #create a cursor

        cursor.execute(sql);                    #execute the sql

        conn.commit()

    except mydb.Error as e:
        (errorNum, errorMsg) = e.args
        msg = 'Database Error - ' + str(errorNum) +' '+ errorMsg
        return     
                              
    msg = "Your order has been saved successfully";    
     
    cursor.close()                           #close the cursor/buffer
    conn.close()                             #close the connection

"""===================================================================================
   Main code
==================================================================================="""
if params   : validate()                    #if something was entered call validate
if msg == '': saveDB()                      #if no errors, save in database
display()                                   #validate form fields                                           
"""================================================================================"""


#=== link to see the python code ================================================
import os
import sys
sys.path.insert(0,'/home/staff/sultan/public_html/cgi-bin/python')
import zCode                          #import func to display the Python code
filename = os.path.abspath(__file__)  #get absolute file name 
zCode.display(filename)               #call it
#================================================================================
</pre>