app.js

/*eslint-env node*/

//------------------------------------------------------------------------------
// node.js starter application for Bluemix
//------------------------------------------------------------------------------

// This application uses express as its web server
// for more info, see: http://expressjs.com

var express = require('express');
var mysql = require('mysql');



// cfenv provides access to your Cloud Foundry environment
// for more info, see: https://www.npmjs.com/package/cfenv
var cfenv = require('cfenv');

// create a new express server
var app = express();

// serve the files out of ./public as our main files
app.use(express.static(__dirname + '/public'));

// get the app environment from Cloud Foundry
var appEnv = cfenv.getAppEnv();

// start server on the specified port and binding host
app.listen(appEnv.port, '0.0.0.0', function() {
  // print a message when the server starts listening
  console.log("server starting on " + appEnv.url);
});


var con = mysql.createConnection({
  host: "us-cdbr-iron-east-04.cleardb.net",
  user: "bc0e03c958a64f",
  password: "b7c08b6f",
  database: "ad_f2305b724dae531"
});

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


app.get('/submit', function (req, res) {
  con.connect(function(err){
    if(err){
      //console.log('Error connecting to Db');
      return;
    }
    //console.log('Connection established');
    });
   var queryString = 'insert into node_test (name,city) values ("'+req.query.name+'","'+req.query.city+'")' ;
	con.query(queryString, function(err) {
		if (err) throw err;
	});
	res.end("Successful insertion!");
	con.end();

});