Help with code...

I am trying to make a post request to my first app, but every time I go to make the post, it gives me this error:TypeError: db.getConnection is not a functionI have tried all of stack overflows suggestions, but I still can't seem to get it to work after messing around with the code for the last 2 days. When I start app.js I get no errors, only when I make my post request from my form, the error shows up in my browser. Please help! I am a beginner so please forgive me, but here is what my code looks like...my db.js looks like this....var mysql = require('mysql'); var mainDb = mysql.createPool({ host : process.env.mysql_host, user : process.env.mysql_user, password : process.env.mysql_pwd, database : process.env.mysql_db }); exports.getConnection = function(callback) { mainDb.getConnection(function(err, connection) { if (err) { console.error('error connecting: ' + err.stack); return; } callback(err, connection); }); }; and my register.js code looks like this...​var express = require('express'); var router = express.Router(); var db = require(__dirname, 'models/db'); var bodyParser = require('body-parser'); app.use(bodyParser.urlencoded({ extended: false })); app.use(bodyParser.json()); router.get('/register', function(req, res, next) { res.render('register', { title: 'Register for a free account' }); }); router.post('/register', function(req, res) { var input = JSON.parse(JSON.stringify(req.body)); var today = new Date(); var users = { "username": req.body.username, "email":req.body.email, "password":req.body.password, "created":today, "modified":today }; db.getConnection(function(err, connection) { connection.query('INSERT INTO users SET ? ', users, function(err, result) { connection.release(); if (err) { return console.error(err); } }); }); res.redirect('/index'); }); module.exports = router;

Submitted September 18, 2019 at 04:35AM by enyfour5