#python mysql注册模块
import pymysql
import hashlib
def uimg(uname,upwd_sha1):
uname = input('请输入用户名:')
upwd = input('请输入密码:')
s1 = hashlib.sha1()
s1.update(upwd.encode())
upwd_sha1 = s1.hexdigest()
return uname,upwd_sha1
def mysql_register(upwd_sha1,uname):
try:
uimg(uname, upwd_sha1)
conn = pymysql.connect(host="localhost",port="3306",user="root",password="5200",database="userimg",charset="utf8")
cur = conn.cursor()
sql = 'select count(*) from userimg where uname=%s'
cur.execute(sql, [uname])
res = cur.fetchone()
if res[0] == 1:
print('用户名已经存在,注册失败,mysql')
else:
sql = 'insert into img(name,pwd) VALUES (%s,%s)'
res = cur.execute(sql,[uname,upwd_sha1])
con
#python#mysql注册模块出现‘name ‘uname’ is not defined```’报错(未解决)
最新推荐文章于 2023-08-04 14:19:06 发布