title: How to pass Javascript variables in MySQL query
body: <p>I've done some research and I'm getting conflicting answers, so here it goes. Do you have to pass JS variables into PHP first or can you insert them directly into a MySQL table? I have this running in node.js, thanks!</p>
  
  <pre><code>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 &amp;&amp; response.statusCode == 200) {
          var $ = cheerio.load(body);
          getPartNumber();
          getDescription();
          getPrice();
          con.connect(function(err) {
          if (err) throw err;
          for (var i = 0; i&lt;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()) });
  }
  }
  });
  </code></pre>