chapter_soup = BeautifulSoup(html)
city = chapter_soup.find(
'div'
,class_ =
'row-fluid'
).find(
'h1'
).get_text()
province = chapter_soup.find(
'a'
,class_ =
'province'
).get_text()
pmNum = chapter_soup.find(
'div'
,class_ =
'row-fluid'
).find(
'span'
).get_text()
suggest = chapter_soup.find(
'div'
,class_ =
'row-fluid'
).find(
'h2'
).get_text()
rand = chapter_soup.find(
'div'
,class_ =
'row-fluid'
).find(
'h2'
).find_next_sibling(
'h2'
).get_text()
face = chapter_soup.find(
'div'
,class_ =
'span4 pmemoji'
).find(
'h1'
).get_text()
conclusion = chapter_soup.find(
'h1'
,class_ =
'review'
).get_text()
print
city.encode(
'utf-8'
)
cur.execute(
'insert into t_pm values(\''
+city.encode(
'utf-8'
)
+
'\',\''
+province.encode(
'utf-8'
)
+
'\',\''
+pmNum.encode(
'utf-8'
)
+
'\',\''
+suggest.encode(
'utf-8'
)
+
'\',\''
+rand.encode(
'utf-8'
)
+
'\',\''
+conclusion.encode(
'utf-8'
)+
'\')'
)