index.js

require('dotenv').config();
const express = require('express');
const app = express();
const port = process.env.PORT || 3000;

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: process.env.DB_HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASSWORD,
  database: process.env.DB_NAME
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to database: ', err);
    return;
  }
  console.log('Connected to database');
});

app.get('/', (req, res) => {
  connection.query('SELECT * FROM formulario', (err, rows) => {
    if (err) throw err;
    console.log('Data received from Db:\n');
    console.log(rows);
    res.send(rows);
  });
});

app.listen(port, () => {
  console.log(`Server running at http://localhost:${port}`);
});