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:
QR codes have evolved from a niche tracking technology to an indispensable digital connector, seamlessly…
Artificial Intelligence (AI) has made remarkable progress in recent years, transforming industries such as healthcare,…
Climate change is one of the most pressing challenges of our time, with rising global…
In the last few decades, technology has become so embedded in our daily lives that…
In recent years, drones have become more than just cool gadgets or tools for tech…
Looking to build mobile apps in Abuja? Choosing the right framework is crucial for performance,…