The page takes name from user and stores his/her details in database along with the time when he joined.
The queries used to create database and table:
DROP DATABASE names IF EXISTS;
CREATE DATABASE names;
USE names;
CREATE TABLE list_names(
name VARCHAR(200),
created_at TIMESTAMP DEFAULT NOW()
);
express
- for web application server framework.sql
- To connect to out database.bodyParser
- To parse incoming requests.ejs
- To use embedded javaScript.faker
- To insert fake data to check.
Faker can be used to generate data. Refer this for more information.
- See
data.js
file to know how I generated fake data.