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 --yWe 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 passwordNext 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:
Latest tech news and coding tips.
Every application that stores and manages data relies on a set of basic operations known…
PHP remains one of the most widely used server-side programming languages, powering platforms such as…
Danfo.js is an open-source JavaScript library designed for data manipulation, analysis, and machine learning. It provides…
JavaScript's async and await keywords revolutionized asynchronous programming by making asynchronous code look and behave more like synchronous code.…
Pretty Good Privacy (PGP) is one of the most widely used encryption systems for securing emails,…
Database migration is one of the most challenging tasks in software engineering. While both PostgreSQL…