Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var part = [];
- var des = [];
- var price = [];
- var request = require('request');
- var cheerio = require('cheerio');
- var mysql = require('mysql');
- var con = mysql.createConnection({
- host: "127.0.0.1",
- user: "root",
- password: "",
- database: "parts"
- });
- request('URL', function(error, response, body) {
- if (!error && response.statusCode == 200) {
- var $ = cheerio.load(body);
- getPartNumber();
- getDescription();
- getPrice();
- con.connect(function(err) {
- if (err) throw err;
- for (var i = 0; i<part.length; i++){
- var sql = "INSERT INTO data_9_17 (partNumber, description, price) VALUES (part[i], des[i], price[i])";
- con.query(sql, function (err, result) {
- if (err) throw err;
- console.log("1 record inserted, ID: " + result.insertId);
- });
- }
- });
- function getPartNumber() {
- $("input[name = 'sku']").each(function() { part.push($(this).val()) });
- }
- function getDescription() {
- $(".ellipsis_text").each(function() { des.push($(this).text()) });
- }
- function getPrice() {
- $(".sellprice, .dbl").each(function() { price.push($(this).text()) });
- }
- }
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement