MYSql CGI Script

Question

Below Code is my CGI Script, where am trying to do a insert Command.

#! C:\Python27\python.exe -u

import cgi
import MySQLdb
import xml.sax.saxutils


query = cgi.parse()
db = MySQLdb.connect(


host = "127.0.0.1",
user = "root",
passwd = "mysql123",
db = "welcome")

print 'Content-type: text/plain\n\n<?xml version="1.0" encoding="utf-8"?>\n<result>'

try:
c = db.cursor()
c.execute("insert into welcome.registrations values ('test','test',now())")
print '\t<update>true</update>'
except:
print '\t<update>false</update>'


print "</result>"

when i run the go to the url - .com/cgi-bin/reg.cgi, am not finding any insert operation done in mysql DB

I meant there is some problem with your apache configuration — Aravind.HU
– Aravind.HU, Commented Apr 6, 2013 at 8:00
You might look into using a web lightweight framework such as flask or bottle. Using cgi seems like a massive headache. — Nathan Villaescusa
– Nathan Villaescusa, Commented Apr 6, 2013 at 8:06

Nathan Villaescusa · Accepted Answer · 2013-04-06 08:01:21Z

1

You need to do db.commit() after c.execute().

Or you could do:

with db:
    c = db.cursor()
    c.execute("insert into welcome.registrations values ('test','test',now())")

answered Apr 6, 2013 at 8:01

Nathan Villaescusa

17.7k4 gold badges55 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

akshayb · Accepted Answer · 2013-04-06 09:08:36Z

0

make sure you do a db.commit() after every insert (or in the end, any will work ):

try:
c = db.cursor()
c.execute("insert into welcome.registrations values ('test','test',now())")
db.commit()
db.close() # Make sure you close the connection else multiple connections will result in hanging of mysql server.

answered Apr 6, 2013 at 9:08

akshayb

1,2392 gold badges22 silver badges45 bronze badges

Collectives™ on Stack Overflow

MYSql CGI Script

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related