總體參考
https://blog.csdn.net/u013055678/article/details/74898051?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase

1.flask

1.flask向前端傳值

jinja引擎在任何地方都可以使用模板深浮，比如

@route('/')
def index():
  return render_template("index.html", name=name)

var a = '{{ name }}'

2.flask像前端傳值時(shí)json轉(zhuǎn)換

比如傳遞list纪挎，如果不直接轉(zhuǎn)換,list[0]就會(huì)顯示[苛吱，并且所有的逗號(hào)都會(huì)占位
所以使用json.dumps()進(jìn)行轉(zhuǎn)換
另外數(shù)據(jù)的傳輸最好使用ajax請(qǐng)求

3.flask連接mysql

原文鏈接：https://blog.csdn.net/BankxiY/article/details/101023383
使用pymysql庫(kù)

def func(sql,m='r'):
    conn = pymysql.connect (host='127.0.0.1', port=3306, user='root', password='123456', db='networkproject', charset='utf8')
    # 得到一個(gè)可以執(zhí)行SQL語(yǔ)句的光標(biāo)對(duì)象
    cursor = conn.cursor()  # 執(zhí)行完畢返回的結(jié)果集默認(rèn)以元組顯示
    try:
        cursor.execute (sql)
        if m == 'r':
            data = cursor.fetchall ()
        elif m == 'w':
            py.commit ()
            data = cursor.rowcount
    except:
        data = False
        py.rollback ()
    cursor.close()
    conn.close ()
    return data
# 首頁(yè),將mysql中表的值讀出并傳到網(wǎng)頁(yè)----查
@app.route ('/')
def index():
    data = func ('select * from stu')
    return render_template ('sqldata.html',userlist=data)

2.echarts

3.BUG

1.No 'Access-Control-Allow-Origin' header is present on the requested resource'

def Response_headers(content):
    resp = Response(content)
    resp.headers['Access-Control-Allow-Origin'] = '*'
    return resp

@app.route('/echarts')
def echarts():
    datas = {
        "data":[
            {"name":"allpe","num":100},
            {"name":"peach","num":123},
            {"name":"Pear","num":234},
            {"name":"avocado","num":20},
            {"name":"cantaloupe","num":1},
            {"name":"Banana","num":77},
            {"name":"Grape","num":43},
            {"name":"apricot","num":0}
        ]
    }
    content = json.dumps(datas)
    resp = Response_headers(content)
    return resp

2.Max retries exceeded with url

應(yīng)該是開(kāi)的網(wǎng)頁(yè)太多了

3.Nonetype' object is not iterable

https://www.cnblogs.com/classics/p/11165596.html
1.nonetype錯(cuò)誤一般都是因?yàn)楂@取的數(shù)據(jù)是空，也就是數(shù)據(jù)的爬取過(guò)程出現(xiàn)了錯(cuò)誤
2.或者編碼出現(xiàn)了問(wèn)題導(dǎo)致正則匹配為空