存mysql数据库

最新推荐文章于 2024-09-16 12:57:44 发布

Mr.冷小陌

最新推荐文章于 2024-09-16 12:57:44 发布

阅读量87

点赞数

分类专栏：爬虫文章标签：存mysql

本文链接：https://blog.csdn.net/lxp_mocheng/article/details/102951396

版权

爬虫专栏收录该内容

13 篇文章 0 订阅

订阅专栏

import requests
import pymysql
# 连接mysql
conn = pymysql.connect(user='root',host='localhost',port=3306,password='',database='bbb',charset='utf8')
cur = conn.cursor()

url = 'https://api.bilibili.com/x/player/pagelist?aid=56917423&jsonp=jsonp'
headers = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.70 Safari/537.36'
}
res = requests.get(url=url, headers=headers)

data = res.json()
for var in data['data']:
    s = '<iframe src="//player.bilibili.com/player.html?aid=56917423&cid=%s&page=%s" scrolling="no" border="0" frameborder="no" framespacing="0" allowfullscreen="true"> </iframe>'
    cid = var['cid']
    page = var['page']
    print(var)

# 存mysql
    sql = "insert into bili values('%s')" % aim
    cur.execute(sql)
    conn.commit()
    print(aim)