Show data in a table using Express.JS

app.js

const express = require('express')
const app = express()

app.set('view engine', 'pug');
app.set('views','./views');

app.get('/', function (req, res) {
  var users = [];
  
  var mysql = require('mysql')
  var connection = mysql.createConnection({
    host     : '********',
    user     : '********',
    password : '********',
    database : '********'
  });

  connection.connect()

  connection.query('select * from users', function (err, rows, fields) {
    for (var i = 0; i < rows.length; i++) {
      // Create an object to save current row's data
      var person = {
        'id':rows[i].id,
        'name':rows[i].name
      }
      // Add object into array
      users.push(person);
    }
    res.render('index', {"users": users});
  })
  
  connection.end()
})

app.listen(3000, () => console.log('Example app listening on port 3000!'))

index.pug

doctype html
html(lang="en")
  head
    title ExpressJS Example with MySQL
  body
    h1 Amazing example
    
    table
      for user in users
        tr
          td= user.id
          td= user.name

schema.sql

create table users(
  id serial primary key AUTO_INCREMENT, 
  name varchar(50)
);

INSERT INTO users (name) VALUES ('John Doe');
INSERT INTO users (name) VALUES ('Jane Doe');