Monday, November 30, 2015

how to retrive data from mysql using nodejs?


Step 1-> create simple your project folde "testapp" under below directory "www"

C:\Bikash\codetest\wamp\www\testapp

create app.js

var mysql = require("mysql");

// First you need to create a connection to the db
var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "",
  database : 'test',
});

con.connect(function(err){
  if(err){
    console.log('Error connecting to Db');
    return;
  }


  console.log('Connection established');
});


function getColour(uid, roomCount, callback)
{

    con.query('SELECT u_name FROM user WHERE u_id = ?', [roomCount], function(err, result)
    {


        if (err)
            callback(err,null);
        else
            callback(null,result[0].u_name);

    });

}

//call Fn for db query with callback
getColour("2",1, function(err,data){
        if (err) {
            // error handling code goes here
            console.log("ERROR : ",err);          
        } else {          
            // code to execute on data retrieval
            console.log("result from db is : ",data);  
        }  

});

con.end(function(err) {
 console.log('Connection has been closed');
});

Step2->open cmd
Step4->C:\Bikash\codetest\wamp\www\testapp>npm install mysql
step5->run like : C:\Bikash\codetest\wamp\www\test>node app.js