Transfer data from webpage form to database

Pete..... helten0007 at yahoo.com
Tue Nov 23 20:28:13 CET 2004


Hi, yeah It's try I want to change it to a python.cgi.script. And thanks for 
your input.....

I use the api pgsql
So the first thing I do is to import the following and connect to the 
server:

#!/pack/python-2.3.2/bin/python2.3
from pyPgSQL import PgSQL
import cgi
import cgitb
cgitb.enable()

form = cgi.FieldStorage()  ( I added this )
connect = PgSQL.connect(user="vvvvv", password="zzzzz", host="xxx.xxx.xx", 
database="yyyyy")

Do I then have to write:

PgSQL.query(''' INSERT into form
                         Select persons.idpersons, person.username, 
persons.surname, phone.phone  (And so on ) ( its what the specific tables 
are called in my database)
                         From persons, phone                             ( 
And so on )
                         Where persons.name = 'Name'%s
                          AND persons.surname ='Surname'%s
                          AND persons.username = 'Username'%s ''' 
(And so on with the rest)
                           % (form['name'].value, form['surname'].value, 
form['username'].value))

I dont think I get it quite right, any help would be highly appreciated. 
Thanks for all help...


Below is the code from my webpage form:

<form action="default.asp" method="post">
    <p>Name:<br><input type="text" name="name"></p>
    <p>Surname:<br><input type="text" name="surnavn"></p>
    <p>Username:<br><input type="text" name="username"></p>
    <p>Password:<br><input type="text" name="password"></p>
    <p>Adresse:<br><input type="text" name="adresse"></p>
    <p>Zipcode:<br><input type="text" name="zipcode"></p>
    <p>City:<br><input type="text" name="city"></p>
    <p>Phone:<br><input type="text" name="phone"></p
    <p>Mail:<br><input type="text" name="mail"></p>


    <p> What is your profession? <p>
    <INPUT TYPE=CHECKBOX NAME="Profession" VALUE="Student" CHECKED> Student
    <INPUT TYPE=CHECKBOX NAME="Profession" VALUE="Teacher" CHECKED> Teacher
    <INPUT TYPE=CHECKBOX NAME="Profession" VALUE="Teacher Assistent" 
CHECKED> Teacher Assistent
    <p><input type="submit" value="Submit"></p>
</body> </html>'''






More information about the Python-list mailing list