store the data instead of printing it - in to a mysql-db

[Guest sayhello]

want to store the data - instead of printing out

there fore i set up a mysqldb on the suse

Code:

import urllib

import urlparse

import re

 

url = "http://search.cpan.org/author/?W"

html = urllib.urlopen(url).read()

for lk, capname, name in re.findall('<a href="(/~.*?/)"><b>(.*?)</b></

a><br/><small>(.*?)</small>', html):

alk = urlparse.urljoin(url, lk)

 

data = { 'url':alk, 'name':name, 'cname':capname }

 

phtml = urllib.urlopen(alk).read()

memail = re.search('<a href="mailto:(.*?)">', phtml)

if memail:

data['email'] = memail.group(1)

 

print data

 

Continue reading...