Python开发个人专属表情包网站，表情在手，天下我有

import requests
import re
import pymysq

import requests
import re
import pymysql
# 连接数据库
db = pymysql.connect(host = '127.0.0.1',port = 3306,db = 'db',user = 'root',passwd = 'root'


    
,charset = 'utf8')
# 创建游标
cursor = db.cursor()
# cursor.execute('select * from images')
# print(cursor.fetchall())
# 小驼峰
# 注释  获取图片列表
def getImagesList(page):
    # 获取斗图网源代码
    html = requests.get('http://www.doutula.com/photo/list/?page={}'.format(page)).text
    # 正则表达式  通配符  .*?  匹配所有   分组匹配
    reg = r'data-original="(.*?)".*?alt="(.*?)"'
    # 增加匹配效率的  S 多行匹配
    reg = re.compile(reg,re.S)
    imagesList = re.findall(reg,html)
    for i in imagesList:
        image_url = i[0]
        image_title = i[1]
        # format 字符串格式化  %s
        cursor.execute("insert into images(`name`,`imageUrl`) values('{}','{}') ".format(image_title,image_url))
        print('正在保存 %s'%image_title)
        db.commit()
# range 范围      1<=X<1000
for i in range(1,1001):
    print('第{}页'.format(i))
    getImagesList(i)

from flask import Flask
from flask import render_template
from flask import request
import pymysql
# 404 页面未找到
app = Flask(__name__)
# 装饰器



    
@app.route('/')  # route 路由
def index():
    # return "hello world"
    return render_template('index.html')
@app.route('/search')
def search():
    # 接收用户关键字
    keyword = request.args.get('kw')
    count = request.args.get('count')
    cursor.execute("select * from images where name like '%{}%'".format(keyword))
    data = cursor.fetchmany(int(count))
    return render_template('index.html',images = data)
# 程序的入口
if __name__ == '__main__':
    db = pymysql.connect(host='127.0.0.1', port=3306, db='db', user='root', passwd='root', charset='utf8',cursorclass = pymysql.cursors.DictCursor)
    # 创建游标
    cursor = db.cursor()
    # 调试模式
    # port  端口号 默认5000
    app.run(debug=True,port=8000)