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()) });
- }
- }
- });
- var query = 'INSERT INTO data_9_17 (partNumber, description, price) VALUES (?, ?, ?)';
- con.query(query, [part[i], des[i], price[i]], function(err, results) ... )
- // You will put your variables inside []
- var sql = "INSERT INTO data_9_17 (partNumber, description, price) VALUES (" + part[i] + ", " + des[i] + ", " + price[i] + ")";
- var sql = mysql.format("INSERT INTO data_9_17 (partNumber, description, price) VALUES (?, ?, ?)", [part[i], des[i], price[i]);
- con.query(sql, function (err, result) {
- .....
- .....
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement