webApp.js

var express = require('express');
var mysql = require('mysql');
var app = express();
var bodyParser = require("body-parser");

app.use(bodyParser.urlencoded({extended: true}));
app.use(express.static(__dirname + "/public"));
app.set("view engine", "ejs");
 
var connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',     // your root username
    password : '1234',
    database : 'join_us'   // the name of your db
  });

app.get("/", function(req, res){
var q = 'SELECT COUNT(*) as count FROM users';
connection.query(q, function (error, results) {
    if (error) throw error;
    //var msg = "We have " + results[0].count + " users";
    var count = results[0].count
    //res.send(msg);
    res.render("home", {count_data: count});   
    });
    
}); 

app.post('/register', function (req, res) {
  var person = { 
    email: req.body.email 
  };

  connection.query('INSERT INTO users SET ?', person, function (err, result) {
    console.log(err);
    console.log(result);
    res.redirect("/");
  });
}); 

app.listen(8080, function () {
 console.log('App listening on port 8080!');
});