Node.Js export variable issue

Question

//Connection.js (module) that is require.

var mysql = require ('mysql');

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


exports.con = con;

module.exports  = con.connect ( function (err) {
        if (err) throw err;
        console.log("Connected!");
    });

//controller.js

var connection = require ('./connection'); var mysql = require ('mysql');

console.log(connection.con);
var sql = "Select * from user;";
connection.con.query(sql , function (err,result) {
    if(err) throw  err;
    console.log(result);
});

when I run the connection.js with the same query it works but when using the module in controller.js it gives me the error. //error code

TypeError: Cannot read property 'con' of undefined

explorer · Accepted Answer · 2017-08-08 10:18:13Z

0

Your first attempt is almost right. Except,

module.exports  = con.connect ( function (err) {
  if (err) throw err;
  console.log("Connected!");
});

By doing that, you are replacing, exports with con.connect() call response, which overwrites previously assigned con property. If you remove that, you should be okay!

var mysql = require ('mysql');

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


exports.con = con;

con.connect ( function (err) {
  if (err) throw err;
  console.log("Connected!");
});

For reference check this(shared by @Aky_0788).

answered Aug 8, 2017 at 10:18

explorer

9528 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Farhan Yaseen · Accepted Answer · 2017-08-08 10:58:37Z

0

//Connection.js (module) that is require.

var mysql = require ('mysql');

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

con.connect ( function (err) {
        if (err) throw err;
        console.log("Connected!");
});

exports.con = con;

controller.js

var connection = require ('./connection');
var mysql = require ('mysql');
console.log(connection.con);
var sql = "Select * from user;";
connection.con.query(sql , function (err,result) {
    if(err) throw  err;
    console.log(result);
});

answered Aug 8, 2017 at 10:58

Farhan Yaseen

2,7272 gold badges25 silver badges40 bronze badges

Collectives™ on Stack Overflow

Node.Js export variable issue

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related