把电影天堂的最新电影名称和观看链接存储到数据库（所有页）

把电影天堂的最新电影名称和观看链接存储到数据库（所有页）

import requests
import json
import re
import timeimport pymysql# 连接数据库
class mysql_conn():def __init__(self):self.db = t('127.0.0.1','root','****','wang')self.cursor = self.db.cursor()def execute_modify_mysql(self,sql):ute(sql)self.dbmit()def __del__(self):self.db.close()sq = mysql_conn()
for k in range(1,178):#主页url = '{}.html'.format(k)headers = {'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36'}response = (url,headers=headers)html = # print(html)res = re.findall('<a href="(.*)" class="ulink">',html)# print(res)for i in res:#详情页url2 = ''+ i# print(url)response2 = (url2,headers=headers)html2 = t.decode('gbk')# print(html2)#影片名# res2 = re.search('<title>(.*)</title>',html2)# up(1))# 影片链接匹配res3 = re.search('<td style="WORD-WRAP: break-word" bgcolor="#fdfddf"><a href="(.*)">',html2)# up(1))#影片链接move_url = up(1)#影片名匹配move= re.search('d/(.*).m',up(1))# up(1))# 影片名move_name = up(1)sql = 'insert into dianying(name,url) values("{}","{}")'.format(move_name,move_url)# print(ute_modify_mysql(sql)time.sleep(2)print('第{}页存储完毕'.format(k))