Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import bs4
- from urllib.request import urlopen as uReq
- from bs4 import BeautifulSoup as soup
- import mysql.connector
- cnx = mysql.connector.connect(user='root', password='Kradz579032!!',
- host='127.0.0.1',
- database='aliexpressapidb')
- cursor = cnx.cursor()
- add_data = ("INSERT INTO productdetails"
- "(description) "
- "VALUES (%s)")
- my_url = 'https://www.aliexpress.com/item/Cheap-Necklace-Jewelry-Alloy-Men-Vintage-Personality-Pendant-Creativity-Simple-Accessories-Symbol-Necklace-Wholesale-Fashion/32879629913.html?spm=a2g01.11147086.layer-iabdzn.4.4a716140Ix00VA&scm=1007.16233.91830.0&scm_id=1007.16233.91830.0&scm-url=1007.16233.91830.0&pvid=acdbf117-c0fb-458f-b8a9-ea73bc0d174b'
- uClient = uReq(my_url)
- page_html = uClient.read()
- uClient.close()
- page_soup = soup(page_html, "html.parser")
- description = page_soup.findAll("div", {"class": "ui-box-body"})
- #print(description)
- data_insert = description
- cursor.execute(add_data, data_insert)
- cnx.commit()
- cursor.close()
- cnx.close()
Add Comment
Please, Sign In to add comment