pythonprogramming/pythonprogramming.net-website

PythonProgramming.net example website

pythonprogramming.net-website's Issues

MySQLdb._escape_string() broken in Python 2.7

I was having a bunch of trouble getting the registration page to work and someone on stackoverflow (http://stackoverflow.com/questions/3617052/escape-string-python-for-mysql) suggested an alternate way after I found a bunch of posts relating to the escape_string currently being broken. I edited __init__.py registration page with the following and was able to get it to work.

sql_check_reg = "SELECT * FROM users WHERE username = (%s)"
x = c.execute(sql_check_reg, (username,))

and:

sql_insert_reg = "INSERT INTO users (username, password, email) VALUES (%s, %s, %s)"
c.execute(sql_insert_reg, (username, password, email))

Maybe you could verify that this is in fact a good method and not susceptible to sql injection?

How to get the text of tkinter checkbutton

`cb_list =['pencil','pen','book','bag','watch','glasses','passport','clothes','shoes','cap']

try:

r = 0

cl = 1
for op in cb_list:
cb = Checkbutton(checkbutton_frame, text=op, relief=RIDGE)
cb.grid(row=r, column=cl, sticky="W")
r = r + 1
except Exception as e:
logging.basicConfig(filename=LOG_FILENAME, level=logging.ERROR)
logging.error(e)
# print (e)`

I need a logic for get selected checkbuttons text
I tried searching but everywhere they are returning the state of checkbox instead of text

Please help