Learn Node JS with MySQL APIs Development Beginners Tutorial | Define & Call Stored Procedure Node

In this video we'll see:

Learn Node JS with MySQL APIs Development Beginners Tutorial | Define & Call Stored Procedure Node APIs

const express = require("express");
const bodyParser = require("body-parser");

const app = express();

const PORT = 5000;

// include body parser for body parameters
app.use(bodyParser.json());

// load mysql package
const mysql = require("mysql");

// create mysql connection
const connection = mysql.createConnection({
host: "localhost",
user: "root",
password: "root",
database: "node_db"
});

// check connection
connection.connect(function (error) {

if (error) {
throw error;
} else {
console.log("We are now successfully connected with mysql database");
}
});


// get all data api
app.get("/users", function (request, response) {

// query
connection.query("SELECT * from tbl_users", function(error, results, fields){

if(error){
throw error;
}else{
response.json(results);
//console.log(fields);
}
});
});

// get data via id
app.get("/user/:id", function(request, response){

var userID = request.params.id;

// query
connection.query("SELECT * from tbl_users WHERE id = ?", [userID], function(error, results, fields){

if(error){
throw error;
}else{
response.json(results);
}
});
});


// calling stored procedure
app.get("/user-detail/:id", function (request, response) {

var user_id = request.params.id;

connection.query("CALL get_user_detail(?)", [user_id], function (error, result, fields) {

if (error) {
throw error;
} else {

response.json(result[0]);
}
});
});

// delete data
app.delete("/user", function(request, response){

var user_id = request.body.user_id;

connection.query("DELETE from tbl_users WHERE id = ?", [user_id], function(error, result, fields){

if(error){

throw error;
}else{

response.json({
status : 1,
message: "User has been deleted successfully",
data: result
});
}
});
});

app.get("/", function (request, response) {

response.send("Welcome to Initial stage of MySQL");
});

app.listen(PORT, function () {

console.log("Server is running at 5000 port");
});

SOCIAL :
===============
Subscribe : https://www.youtube.com/owthub
FACEBOOK : https://www.facebook.com/owthub
TWITTER: https://twitter.com/owthub
BLOG: https://onlinewebtutorhub.blogspot.in/
UDEMY: https://www.udemy.com/user/online-web-tutor

Other Tutorials
===============
Wordpress Customizations:
---------------------------------
Wordpress Theme (Hindi): https://goo.gl/MZ8maF
Wordpress Widget (Hindi): https://goo.gl/Dc2htn
Wordpress Plugin (English): https://goo.gl/BA7dYG
Wordpress Theme Options (English): https://goo.gl/Vjv3Ub
Wordpress JSON Rest API (English): https://goo.gl/SVQRQR
Wordpress JSON Rest API (Hindi): https://goo.gl/NNWfKa
and many more...

Javascript framework:
----------------------------------
Learn backbone.js here! (English) : https://goo.gl/Qd2Pcs
Learn Vue JS here ! (Hindi): https://goo.gl/MVtsmh

PHP Frameworks:
----------------------------------
Laravel tutorial (Hindi): https://goo.gl/Nh9qJk
CakePHP tutorial (Hindi): https://goo.gl/uRsS3G

Tags:
----------------------------------
node,
node.js,
node api,
node with express apis,
node express with mysql apis,
node mysql,
mysql node apis,
node mysql api tutorial,
node restful api tutorial with mysql,
express mysql node api,
node express apis,
node restful apis with mysql,
learn node js with mysql,
node js express and mysql,
restful node apis development tutorial,
node js apis development tutorial from scratch,
node express tutorial,
create restful api nodejs mysql,
online web tutor,
online web tutor node js express mysql,
online web tutor node restful apis development,


Thanks
Online Web Tutor
Keep learning and Sharing :)