def find_img(hreflist):
print(len(hreflist))
#datalist = []
titlelist = []
# dbname = sex_picture
db_name = 'sex_picture'
for i in hreflist:
html = open_url(i)
srclist = []
soup = BeautifulSoup(html, 'lxml')
titles = soup.find('h1').get_text().strip()
title = titles.replace('[', '').replace(']', '')
#cursor.execute("DROP TABLE IF EXISTS `"+title+"`")
sql = """CREATE TABLE IF NOT EXISTS `""" + title + """`(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
href CHAR(100) NOT NULL,
likenumber INT,
collect INT,
see INT
)"""
cursor_datas(sql, db_name)
#strip去除多余的空格(\n)
titlelist.append(title.strip())
for each in soup.select('div[class=f14] > img'):
src = each.get('src').strip()
srclist.append(src)
for e in srclist:
data = "INSERT IGNORE INTO `" + title + "`(`href`,`likenumber`,`collect`,`see`) VALUES ('" + str(
e) + "',0,0,0);"
cursor_datas(data, db_name)
def signin():
#从数据库取图片数据
# alltable = 'show tables'
# dbname='sex_picture'
# datas = cursor_datas(alltable,dbname)
# tablesname = tuple(datas[::-1])
# datalist=[]
# for i in tablesname:
# alldata = "SELECT * FROM `"+i[0]+"`;"
# data =cursor_datas(alldata,dbname)
# datalist.append(data)
# a = datalist
# b = tablesname
# data = list(zip(a, b))
#从网页post用户数据
subvalue = request.form['subvalue']
username = request.form['username']
password = request.form['password']
email = request.form['email']
tel = request.form['tel']
print(subvalue)
if subvalue == '注册':
# 获取当前时间
t = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
#print(f"name:{name}")
sql = "SELECT * FROM userlist WHERE name = '%s' " % (username)
dbname = 'user-info'
# 执行SQL语句
results = cursor_datas(sql, dbname)
# 往数据库写数据
ins = "INSERT INTO `userlist`(`name`,`password`,`email`,`tel`,`time`) VALUES ('" + \
username+"','"+password+"','"+email+"','"+tel+"','"+t+"');"
cursor_datas(ins, dbname)
print(username)
return jsonify('注册成功', username)
else:
at = '@'
if at in username:
sql = "SELECT * FROM userlist WHERE email = '%s' " % (username)
else:
sql = "SELECT * FROM userlist WHERE name = '%s' " % (username)
# 执行SQL语句
dbname = 'user-info'
results = cursor_datas(sql, dbname)
if results == ():
return jsonify(('用户名不存在请检查后在输入', ))
else:
for i in results:
name = i[1]
pasd = i[4]
if password == pasd:
print(name)
return jsonify('登陆成功', name)
else:
# print(f'results:{results}')
return jsonify(('账号或密码错误请重新登陆', ))
def creatmsgboard():
dbname = 'user-info'
t = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
msg = request.form['comment']
name = request.form['username']
top, down = '0', '0'
# 往数据库存数据
ins = "INSERT INTO `messageboard`(`name`,`message`,`time`,`top`,`down`)VALUE('" + name + "','" + msg + "','" + t + "','" + top + "','" + down + "');"
cursor_datas(ins, dbname)
#从数据库取数据
sql = "SELECT * FROM messageboard;"
datas = cursor_datas(sql, dbname)
#datas[-1] 每次请求最后一项数据
return jsonify(datas[-1])
def message():
dbname='user-info'
name = request.form['username']
#从数据库取数据
sql = "SELECT * FROM messageboard;"
datas = cursor_datas(sql,dbname)
data = tuple(datas[::-1])
return render_template('messageboard.html', data=data, username=name)
def getmore():
alltable = 'show tables'
dbname='sex_picture'
datas = cursor_datas(alltable,dbname)
tablesname = tuple(datas[::-1])
datalist=[]
for i in tablesname:
alldata = "SELECT * FROM `"+i[0]+"`;"
data =cursor_datas(alldata,dbname)
datalist.append(data)
a = datalist
b = tablesname
alldata = list(zip(a, b))
max = request.form['numbmax']
data = alldata[0:50*max]
return jsonify(data)
def ajax_insertdb():
title = request.form['name']
href = request.form['href']
likenumber = '0'
print(title,href)
data = "UPDATE '%s' SET likenumber = likenumber + 1 WHERE href = '%s' "%(title,href)
#data = "UPDATE "+title+" SET likenumber = likenumber + 1 WHERE href = "+href+""
dbname='sex_picture'
req = cursor_datas(data,dbname)
return jsonify(req)
def get_name():
#获取登陆用户信息
ip = request.remote_addr
useragent = request.headers.get('User-Agent')
print(ip, useragent)
#从数据库取图片数据
alltable = 'show tables'
dbname = 'sex_picture'
datas = cursor_datas(alltable, dbname)
tablesname = tuple(datas[::-1])
datalist = []
for i in tablesname:
alldata = "SELECT * FROM `" + i[0] + "`;"
data = cursor_datas(alldata, dbname)
datalist.append(data)
a = datalist
b = tablesname
data = list(zip(a, b))
#data = alldata[0:50]
return render_template('picture.html', data=data)
def ajax_cheak2():
name = request.form['name']
#print(f"name:{name}")
sql = "SELECT * FROM userlist WHERE email = '%s' " % (name)
dbname = 'user-info'
# 执行SQL语句
results = cursor_datas(sql, dbname)
reqmail = {}
for i in results:
reqmail = i[2]
#print(f'results:{results}')
return jsonify(reqmail)
def messageinfo():
content = request.form['content']
dowhat = request.form['dowhat']
D = int(dowhat)
sql = ''
if D == 666:
sql = "UPDATE messageboard SET top = top + 1 WHERE message = '%s' " % (content)
elif D == 333:
sql = "DELETE FROM messageboard WHERE message = '%s'" % (content)
else:
sql = "UPDATE messageboard SET down = down + 1 WHERE message = '%s' " % (content)
dbname='user-info'
data = cursor_datas(sql,dbname)
return jsonify(data)
def ajax_cheak():
name = request.form['name']
#print(f"name:{name}")
at = '@'
if at in name:
sql = "SELECT * FROM userlist WHERE email = '%s' " % (name)
else:
sql = "SELECT * FROM userlist WHERE name = '%s' " % (name)
# 执行SQL语句
dbname = 'user-info'
results = cursor_datas(sql, dbname)
reqname = []
for i in results:
reqname.append(i[1] + i[2])
#print(f'results:{results}')
return jsonify(reqname)
def ajax_insertdb():
title = request.form['name']
href = request.form['href']
stateN = request.form['stateN']
print(stateN)
data = ''
#print(title,href,likenumber)
if stateN == '333':
data = "DELETE FROM " + title + " WHERE href = '%s'" % (href)
elif stateN == '888':
data = "UPDATE " + title + " SET see = see+1 WHERE href = '%s' " % (
href)
else:
data = "UPDATE " + title + " SET likenumber = likenumber+1 WHERE href = '%s' " % (
href)
dbname = 'sex_picture'
req = cursor_datas(data, dbname)
return jsonify(req)
def signin():
alltable = 'show tables'
dbname='sex_picture'
datas = cursor_datas(alltable,dbname)
tablesname = tuple(datas[::-1])
datalist=[]
for i in tablesname:
alldata = "SELECT * FROM `"+i[0]+"`;"
data =cursor_datas(alldata,dbname)
datalist.append(data)
a = datalist
b = tablesname
data = list(zip(a, b))
subvalue = request.form['submit']
username = request.form['username']
password = request.form['password']
email = request.form['email']
tel = request.form['tel']
print(subvalue)
if subvalue == '注册':
# 获取当前时间
t = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
#print(f"name:{name}")
sql = "SELECT * FROM userlist WHERE name = '%s' " % (username )
dbname='user-info'
# 执行SQL语句
results = cursor_datas(sql,dbname)
if len(results) >0:
return render_template('picture.html', data=data, username=username)
else:
# 往数据库写数据
ins = "INSERT INTO `userlist`(`name`,`password`,`email`,`tel`,`time`) VALUES ('" + \
username+"','"+password+"','"+email+"','"+tel+"','"+t+"');"
cursor_datas(ins,dbname)
print(username)
return render_template('picture.html', data=data, username=username)
else:
at = '@'
if at in username :
sql = "SELECT * FROM userlist WHERE email = '%s' " % (username)
else:
sql = "SELECT * FROM userlist WHERE name = '%s' " % (username)
# 执行SQL语句
dbname='user-info'
results = cursor_datas(sql,dbname)
if results == ():
return render_template('form.html', msg=('用户名不存在请检查后在输入'))
else:
for i in results:
name = i[1]
pasd = i[4]
if password == pasd:
print(name)
return render_template('picture.html', data=data, username=name)
else:
# print(f'results:{results}')
return render_template('form.html', msg=('账号或密码错误请重新登陆'))
