software development training in abuja using node.js and mysql

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:

Leave a Reply

Your email address will not be published. Required fields are marked *