var request = require('request');
var cheerio = require('cheerio');
var fs = require('fs');
var mysql = require('mysql');
var htmlspecialchars = require('htmlspecialchars');

var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "",
  database: "data2015"
});


i = 0;
while (i < 205) {
i++;


request('https://election.news.lk/general-election-2015/results/results/'+i , function(err , res, body) {


  if (!err && res.statusCode === 200) {
    var $ =  cheerio.load(body);
    var data = $('.election_table').each(function (i, elem) {
        // Range Name
      var data1 = $(this).text();
      console.log(data1);


      // var sql = "INSERT INTO `parties` (`id`, `name`) VALUES (NULL, '"+htmlspecialchars(data1)+"');";
      // con.query(sql, function (err, result) {
      //   if (err) throw err;
      //   console.log("1 record inserted");
      //
      // });
    });
    // var data1 = $('.header').text();
    // console.log(data1);
    // console.log("");
    // console.log(data);


  }
});

}