app.js

const express = require('express');
const mysql = require('mysql');
const dotenv = require('dotenv');
const path = require('path');
const cookieParser = require('cookie-parser');
const session = require('express-session');

dotenv.config({ path : './.env' });

const app = express();

app.use(session({secret : 'akcbklacb'}));

const db = mysql.createConnection({
    host : process.env.DATABASE_HOST,
    user : process.env.DATABASE_USER,
    password : process.env.DATABASE_PASSWORD,
    database : process.env.DATABASE
})

const publicDirectory = path.join(__dirname, './public');
app.use(express.static(publicDirectory));

//Parse URL encoded bodies from HTML forms
app.use(express.urlencoded({extended : false}));
//Parse JSON bodies
app.use(express.json());
app.use(cookieParser());

app.set('view engine', 'hbs');

db.connect( (error) => {
    if(error)
    {
        console.log(error)
    }
    else
    {
        console.log("MySQL connected...")
    }
});

//Define routes
app.use('/',require('./routes/pages'));
app.use('/auth',require('./routes/auth'));

app.listen(5000, () => {
    console.log("Server started on port 5000")
});