0

I have a serverside script name server.js. My directory structure is like this

enter image description here

I want to export a variable from server.js and trying to import it from users.js. But all I get is blank variable.

I have tried with a simple variable like

const hello="helloworld";
module.exports=hello;

But after printing the variable on users.js I get a "{}" on the page.

server.js code

var sql = require("mssql");

//SQL server config
var config = {
    user: 'sa',
    password: '*****',
    server: 'DESKTOP-45', 
    database: 'Testdb' 
};
// connect to your database
sql.connect(config, function (err) {

  if (err) {
      console.log(err);
  }else{
      console.log("sql server connected");
  }

});

app.use('/',require('./routes/index'));
app.use('/users',require('./routes/users'));

const request = new sql.Request();
module.exports=request;

users.js code

const sqlrequest = require('../server.js');
sqlrequest.query('select * from tbl_registration', function (err, recordset) {

            if (err) console.log(err);
            res.send(recordset.recordset);       
        });
Dipto Roy
  • 163
  • 1
  • 14

0 Answers0