#coding=utf8 import sys import json import requests import MySQLdb reload(sys) sys.setdefaultencoding('utf-8') conn= MySQLdb.connect( host='localhost', port = 3306, user='root', passwd='root', db ='df', ) cur = conn.cursor() sqli="insert into image(image_url) values(%s)" def extract_image(resp): o = json.loads(resp) result = o['result'] for r in result: #print r['image'] if(r.has_key('image')): print r['image'] cur.execute(sqli,(r['image'])) for i in range(0,2000,10): print i url = 'http://www.yidianzixun.com/api/q/?path=channel|news-list-for-channel&channel_id=u241&fields=docid&fields=category&fields=date&fields=image&fields=image_urls&fields=like&fields=source&fields=title&fields=url&fields=comment_count&fields=summary&fields=up&cstart='+str(i)+'&cend='+str(i+10)+'&version=999999&infinite=true' response = requests.get(url).text extract_image(response) cur.close() conn.commit() conn.close()