Kode for pg-insert.py

#!/usr/bin/python

import _pg
from cgi import *


print "Content-type: text/html\n\n"

form = FieldStorage()

db= _pg.connect(dbname='wwwelin',host='freja.hiof.no',user='wwwelin',passwd='wwwelin')


def optBarnehage():
    resobj = db.query("SELECT organisasjonsnr,navn FROM barnehage")
    res = resobj.getresult()
    resstr=""
    for n in res:
        resstr=resstr+'<OPTION VALUE="'+str(n[0])+'">'+str(n[1])+'</OPTION>'
    return resstr

if form.has_key("orgnr"):
    #Legg til en ansatt
    try:
        db.query("INSERT INTO ansatt VALUES('"+str(form['personnr'].value)+"','"+str(form['navn'].value)+"','"+str(form['adresse'].value)+"','"+str(form['postnr'].value)+"','"+str(form['tlf_nr'].value)+"',"+str(form['orgnr'].value)+","+str(form['avdeling'].value)+",'"+str(form['stilling'].value)+"','"+str(form['ansatt_siden'].value)+"','"+str(form['utdannelse'].value)+"',"+str(form['timelonn'].value)+");")
        print 'Lagt til....<A HREF="pg-test.py?orgnr='+str(form['orgnr'].value)+'">Gå til barnehage</A>'
    except Exception,args:
        print "Feil!!!! :"+Exception+" "+str(args)
                                              
else:
    print """
    <HTML>
    <HEAD>
      <TITLE>BarnehageInfo</TITLE>
    </HEAD>
    <BODY>
    <H1>Legg til en ansatt barnehage:</H1>
    <FORM ACTION="pg-insert.py" METHOD="GET">
    <SELECT NAME="orgnr">
    %s
    </SELECT><BR>
    Avdeling: <INPUT TYPE="text" name="avdeling"><BR>
    Personnr: <INPUT TYPE="text" name="personnr"><BR>
    Navn: <INPUT TYPE="text" name="navn"><BR>
    Adresse: <INPUT TYPE="text" name="adresse"><BR>
    Postnr: <INPUT TYPE="text" name="postnr"><BR>
    Tlf: <INPUT TYPE="text" name="tlf_nr"><BR>
    Stilling: <INPUT TYPE="text" name="stilling"><BR>
    Ansatt siden: <INPUT TYPE="text" name="ansatt_siden"><BR>
    Utdannelse: <INPUT TYPE="text" name="utdannelse"><BR>
    Timelønn: <INPUT TYPE="text" name="timelonn"><BR>
    <INPUT TYPE="SUBMIT">
    </FROM>
    </BODY>
    </HTML>
    """ % (optBarnehage())
Se resultat