server.js

const express = require('express');
const path = require('path');
const bodyParser = require('body-parser');
const knex = require('knex');

const db = knex({
    client: 'pg',
    connection: {
        host: '127.0.0.1',
        user: 'postgres',
        password: 'Vpn3579',
        database: 'loginform'
    }
})

const app = express();

let initialPath = path.join(__dirname, "public");

app.use(bodyParser.json());
app.use(express.static(initialPath));

app.get('/', (req, res) => {
    res.sendFile(path.join(initialPath, "index.html"));
})

app.get('/login', (req, res) => {
    res.sendFile(path.join(initialPath, "login.html"));
})

app.get('/register', (req, res) => {
    res.sendFile(path.join(initialPath, "login.html"));
})

app.post('/register-user', (req, res) => {
    const { name, email, password } = req.body;
    db("users").insert({
        name: name, 
        email: email,
        password: password
    })
    .returning(["name","email"])
    .then(data => {
        res.json(data[0])
    })
    .catch(err => {
        if(err.detail.includes('already exists')){
            res.json('email already exists');
        }
    })
})

app.listen(3000, (req, res) => {
    console.log('listening on port 3000....')
})