Delete from database in Python

Question

I have deleteuser.py where i need to delete one user, here is the code:

# Import modules for CGI handling
import MySQLdb
import cgi, cgitb

# Open database connection
db = MySQLdb.connect("localhost", "root", "", "moviedb" )

# prepare a cursor object using cursor() method
cursor = db.cursor()

# Create instance of FieldStorage 
form = cgi.FieldStorage() 

# Get data from fields
iduser = form.getvalue('iddelete')

# execute SQL query using execute() method.
try:
    cursor.execute("""DELETE FROM user WHERE
         ID = '%s'""",(iduser))
    # Commit your changes in the database
    db.commit()
except:
    db.rollback()

# disconnect from server
db.close()

print "Content-Type: text/plain;charset=utf-8"
print

I have no error but it doesn`t work. The database is still the same.

Thank you

You're carefully hiding all possible errors with that catch-all except block. Remove that so you can see what is actually going wrong. Never, ever, blindly catch and swallow exceptions. — Daniel Roseman
– Daniel Roseman, Commented May 4, 2016 at 19:50
i have removed try-catch, now i have this error: End of script output before headers — Gina
– Gina, Commented May 4, 2016 at 20:16
thank you, that helped me a lot. now i have the answer posted — Gina
– Gina, Commented May 4, 2016 at 20:41

Gina · Accepted Answer · 2016-05-04 20:40:55Z

1

here is the answer:

#!/Python27/python
# -*- coding: UTF-8 -*-


# Import modules for CGI handling
import MySQLdb
import cgi, cgitb

# Open database connection
db = MySQLdb.connect("localhost", "root", "", "moviedb" )

# prepare a cursor object using cursor() method
cursor = db.cursor()

# Create instance of FieldStorage 
form = cgi.FieldStorage() 

# Get data from fields
iduser = form.getvalue('iddelete')

# execute SQL query using execute() method.
query = "delete from user where id = '%s' " % iduser
cursor.execute(query)
    # Commit your changes in the database
db.commit()

# disconnect from server
db.close()

print "Content-Type: text/plain;charset=utf-8"
print

answered May 4, 2016 at 20:40

Gina

1031 gold badge2 silver badges9 bronze badges

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

2 Comments

Joel Over a year ago

Thank you for posting your answer. However, don't forget to be specific about what the error was and exactly how you resolved it so that other than benefit from your answer in the future.

mvp Over a year ago

Now, imagine what happens if iduser obtained from cgi is NULL; DROP TABLE user.

Collectives™ on Stack Overflow

Delete from database in Python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related