Untitled

var mysql = require('mysql');
var express = require('express');
var app =express();
var country = [], population = [], gdp = [];
var jsonArray;

var connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '12345',
  database: 'rohan'
});
var queryString = 'SELECT * FROM Country';

// Fetching data from database
app.get('/', function(req, res) {
  connection.query(queryString, function(err, rows, fields) {
    if(err) throw err;
    formatData(rows);
    res.send(jsonArray);
    console.log(jsonArray);
  });
});

function formatData(dataArray) {
  for(var i = 0; i < dataArray.length; i++) {
    country[i] = dataArray[i].name;
    population[i] = dataArray[i].population;
    gdp[i] = dataArray[i].GDP;
  }
  jsonArray = [country, population, gdp];
  console.log("in FormatData()...n");
  console.log(jsonArray);
}

app.listen(3000, function() {
  console.log("Server listening on port 3000");
});

<html>
  <head>
    <title>Chart-mysql demo</title>
    <script>
      // code to draw graph
      $("#clients").bind('ajax:success', function(result) {
        console.log("In index.html" +  result);
        alert(result);
        var barData = {
          label:result.country,
          datasets: [
            {
              label: '2010 Customers #',
              fillColor: '#382765',
              populationData:result.population
            }
          ]
        };
       var context = document.getElementById('clients').getContext('2d');
       var clientsChart = new Chart(context).Bar(barData);

      });
    </script>
  </head>

  <body>
    <h1>Country Demographics</h1>
    <script src="Chart.js"></script>
    <script src="app.js"></script>
    <canvas id="clients" width=500 height=400></canvas>
  </body>
</html>