Creating a global sql function

Question

I'm new to javascript and need to know how to create a global function or class that can access by every other page on the website when it is required

mysqlConnection.js

function mysql.connection () {
  const mysql = require('mysql');

  const con = mysql.createConnection({
     host: "hostname",
     user: "username",
     password: "password",
     database: "database",
  });
};

script.js

mysql = require('mysqlConnection.js');
mysql.connection();
con.connect(function (err) {
  if (err) throw err;

  // Query
  con.query(sql, function (err, result) {
    if (err) throw err;
    // Result
  });
});

Possible duplicate of How to provide a mysql database connection in single file in nodejs — Naveen Kumar V
– Naveen Kumar V, Commented Aug 1, 2019 at 9:28

David · Accepted Answer · 2019-08-01 09:31:04Z

1

Use module.exports

Then you could do it like this:

/* config.js */ 

const mysql = require('mysql');

const configDB = mysql.createConnection({
  multipleStatements: true,
  port: 3306,
  host: 'XXXXX',
  user: 'XXXXX',
  password: 'XXXXX',
  database: 'XXXXX',
});

module.exports = configDB;

Then you simply import it to each file where you need it:

/* main.js */

const configDB = require('./config.js');

configDB.query(query, (err, data) => {
 (....)

answered Aug 1, 2019 at 9:31

David

1,19413 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Creating a global sql function

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related