API for Insert Record using MySQL in Node.js

Before You start first go through this link for setting your Node.js API environment.

Here I will show you how to insert one record using MySQL in node.js server. Follow this below procedure.

Write Insert Query in Controller:

For inserting one record in MySQL table write query in “employeecontroller.js” file in “controller” folder.

MySQL query for inserting one record is :

insert into tbl_profile(name,phone,email) values(‘Sitaram’,’12345675443’, ‘abc@gmail.com’)
Now use that query in the “employeecontroller.js” file in the “controller” folder.

Employeecontroller.js:

var db = require('../config/connection'); //reference of connection.js
var employees = {
Create: function (profile,callback) {
return db.query("insert into tbl_profile(name,phone,email) values(?, ?, ?)",
[profile.name,profile.phone,profile.email], callback);
}
}
module.exports=employees;

Route Configuration for insert employee records:

For configuring route for inserting record in to employee profile table. Write route configuration code in “employeeroute.js” file in “route” folder.

Set POST method to insert employee profile details. Now use this following code in your “employeeroute.js” file in the “route” folder.

employeeroute.js:

var express = require('express');
var router = express.Router();
var employees = require('../controller/employeecontroller'); //Call your employee controller...
router.post('/create', function (req, res, next) {
employees.Create(req.body,function (err, rows) {
if (err) {
res.send(err);
}
else {
res.send(rows);
}
})
})
module.exports = router;
OUTPUT:


Now open postman for checking that node.js application. Write your URL and set the method type is POST and pass parameters through body in postman.



Click on the Send button then the output will be shown in the below window.



Check all the CRUD API following below link:

• Get All Records
• Get Record By Id
• Insert Record
• Update Record
• Delete Record