DB to HTML

node.js

const express = require('express');
const morgan = require('morgan');
const fs = require("fs");
const {Pool, Client} = require('pg');
const bodyParser = require('body-parser');

const contents = fs.readFileSync("user.json");
const jsonContent = JSON.parse(contents);

const app = express();
const port = 3000;

app.use(morgan('short'));

app.use(bodyParser.urlencoded({extended: false}));
app.use(express.static('./public'));

const client = new Client({
    user: 'postgres',
    host: '127.0.0.1',
    database: 'nodeTest',
    port: 5432,
});
client.connect();

app.post('/car_create', (req, res) => {
    const make = req.body.create_make;
    const model = req.body.create_model;

    client.query(`INSERT INTO cars (make, model) VALUES ($1, $2) RETURNING car_id , "make", "model"`, [make, model], (error, results) => {
        if (error) {
            throw error
        }
        res.status(201).send(`Car is : ${results.rows[0].car_id}`);
        res.end();
    });
});