[<PropertyGroup>const express = require('express'); const dotenv = require("dotenv"); var path = require("path"); dotenv.config({ path: ".env" }); const app = express(); app.use(express.json()); app.use(express.static(path.join(__dirname, 'public'))); const mysql = require('mysql2'); const connection = mysql.createConnection({ host: process.env.HOST, user: process.env.DB_USER, password: process.env.PASS, database: process.env.DB }); connection.connect((err) => { if (err) { console.log("Error connecting to the database", err); }else { console.log("Connected to the database!"); } }) app.get('/data', (req, res) => { const sql = 'SELECT Min, Max, HeadHousehold, Single, MarriedSeperately, MarriedJointly FROM Tax'; connection.query(sql, (err, data) => { if (err) return res.json(err); return res.json(data); }) }) app.get('/', function (req, res) { res.sendFile(path.join(__dirname, 'public', 'index.html')); }); #17
