I have a serverside script name server.js. My directory structure is like this
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);
});