A registration form is used to collect data from potential users of your website.
This is necessary, especially if you want these users to subscribe to a certain service in which they would have to login to access.
In this tutorial, we will look at how to create a registration form using Node.js and MySQL.
Let’s begin …
First, we create a MySQL database
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`password` varchar(300) NOT NULL,
`date_time` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
What we want to do next is to create a package.json file where will install the dependencies that are necessary for this project to work.
//Create a package.json file
npm init --y
We will install other dependencies as follows:
npm install express --save // use express sever
npm install mysql //use mysql module
npm install nodemon //watch for file changes
npm install cryptr //encrypt our password
Next we create an index.html file where we will write our HTML code
<html>
<body>
<form action="/register-controller" method="POST">
First Name: <input type="text" name="name">
Email: <input type="text" name="email">
Paswword: <input type="password" name="password">
<input type="submit" value="Submit">
</form>
</body>
</html>
Next we create a config.js file where we will make the database connection.
var mysql = require('mysql');
var connection = mysql.createPool({
host : 'localhost',
user : 'root',
password : '',
database : 'test2',
port: '8080'
});
connection.getConnection(function(err){
if(!err) {
console.log("Database is connected");
} else {
console.log(`Error while connecting with database ${err}` );
}
});
module.exports = connection;
Moving forward, we create a controller file that will insert our collected data into the database.
var Cryptr = require('cryptr');
var express=require("express");
var connection = require('./config');
cryptr = new Cryptr('myTotalySecretKey');
module.exports.register=function(req,res){
var today = new Date();
var encryptedString = cryptr.encrypt(req.body.password);
var users={
"name":req.body.name,
"email":req.body.email,
"password":req.body.password,
"created_at":today,
"updated_at":today
}
connection.query('INSERT INTO users SET ?',users, function (error, results, fields) {
//connection.release()
if (error) {
res.json({
status:false,
message:'there are some error with query'
})
}else{
res.json({
status:true,
data:results,
message:'user registered successfully'
})
}
});
}
Your result should look like this:
When debugging JavaScript, you’ll often encounter ReferenceError and TypeError. While both indicate something went wrong,…
When selecting DOM elements in JavaScript, two common methods are document.querySelector() and document.getElementById(). But which…
When starting a JavaScript project, one of the first decisions you’ll face is: Should I…
Software development is one of the most valuable skills you can learn. From building websites…
In JavaScript, arrays are used to store multiple values in a single variable. While JavaScript…
Containerization is a lightweight form of virtualization that packages an application and its dependencies into…