Advertisement
Guest User

Untitled

a guest
Sep 8th, 2017
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. var part = [];
  2. var des = [];
  3. var price = [];
  4. var request = require('request');
  5. var cheerio = require('cheerio');
  6. var mysql = require('mysql');
  7.  
  8. var con = mysql.createConnection({
  9. host: "127.0.0.1",
  10. user: "root",
  11. password: "",
  12. database: "parts"
  13. });
  14.  
  15. request('URL', function(error, response, body) {
  16. if (!error && response.statusCode == 200) {
  17. var $ = cheerio.load(body);
  18. getPartNumber();
  19. getDescription();
  20. getPrice();
  21. con.connect(function(err) {
  22. if (err) throw err;
  23. for (var i = 0; i<part.length; i++){
  24. var sql = "INSERT INTO data_9_17 (partNumber, description, price) VALUES (part[i], des[i], price[i])";
  25. con.query(sql, function (err, result) {
  26. if (err) throw err;
  27. console.log("1 record inserted, ID: " + result.insertId);
  28. });
  29. }
  30. });
  31.  
  32. function getPartNumber() {
  33. $("input[name = 'sku']").each(function() { part.push($(this).val()) });
  34. }
  35.  
  36. function getDescription() {
  37. $(".ellipsis_text").each(function() { des.push($(this).text()) });
  38. }
  39.  
  40. function getPrice() {
  41. $(".sellprice, .dbl").each(function() { price.push($(this).text()) });
  42. }
  43. }
  44. });
  45.  
  46. var query = 'INSERT INTO data_9_17 (partNumber, description, price) VALUES (?, ?, ?)';
  47.  
  48. con.query(query, [part[i], des[i], price[i]], function(err, results) ... )
  49.  
  50. // You will put your variables inside []
  51.  
  52. var sql = "INSERT INTO data_9_17 (partNumber, description, price) VALUES (" + part[i] + ", " + des[i] + ", " + price[i] + ")";
  53.  
  54. var sql = mysql.format("INSERT INTO data_9_17 (partNumber, description, price) VALUES (?, ?, ?)", [part[i], des[i], price[i]);
  55.  
  56. con.query(sql, function (err, result) {
  57. .....
  58. .....
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement