Node JS - "Could not get any response" On Insert Data to Database

Question

I'm trying to Insert some data to my database(mysql) with nodejs and I already did make some code but in postman it displays Could not get any response even though I know that I followed properly some tutorials that I watched.

Here's my code

SendOrder.js (models)

var db=require('../dbconnection');

var Task = {
    addTask:function(Task,callback){
        return db.query("Insert into orders ( order_id, order_no, tbl_id, menu_id, \
            order_quantity, order_discount, order_type, \
            order_amount, menu_name, menu_price ) values(?,?,?,?,?,?,?,?,?,?)",
        [
            Task.order_id, Task.order_no, Task.tbl_id, Task.menu_id,
            Task.order_quantity, Task.order_discount, Task.order_type,
            Task.order_amount, Task.menu_name, Task.menu_price
        ], callback);
    },
}

module.exports=Task;

SendOrder.js (router)

var express = require('express');
var router = express.Router();
var Task = require('../models/SendOrder');

router.post('Send/', function(req, res, next){
        Task.addTask(req.body,function(err,count){
            console.log(req.body);
            if(err)
            {
                res.json(err);
            }
            else{
                res.json(req.body);
            }
        });
});

module.exports = router;

EDIT:

dbconnection.js

var mysql=require('mysql');
var connection=mysql.createConnection({

    host: 'localhost',
    user: 'root',
    password: '',
    database: 'opob',

});

module.exports=connection;

app.js

var createError = require('http-errors');
var express = require('express');
var path = require('path');
var cookieParser = require('cookie-parser');
var logger = require('morgan');
var mysql = require('mysql');
var connection = require('express-myconnection')

var SendOrder = require('./routes/SendOrder');           // SendOrder

var app = express();  

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');

app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use('/SendOrder', SendOrder);                        // SendOrder

// catch 404 and forward to error handler
app.use(function(req, res, next) {
  next(createError(404));
});

// error handler
app.use(function(err, req, res, next) {
  // set locals, only providing error in development
  res.locals.message = err.message;
  res.locals.error = req.app.get('env') === 'development' ? err : {};

  // render the error page
  res.status(err.status || 500);
  res.render('error');
});

module.exports = app;

Answer 1

From whatever you have shared here are the following possibilities:

1. Your IP/PORT that you are trying to hit is wrong. Please cross verify them again.
2. The IP that you are trying to hit is not accessible from the machine where postman is installed (I added this possibility as you are using IP instead of localhost)
3. The third possibility would be server crashing when you hit the Send/ API. If the problem is with your code, most probably this is the reason. In this case, you can check the server console to find crash logs and stack-trace.

As @Hardik has mentioned in the comments is not a wrong URL as that would return 404.

Answer 2

Go to Setting in Postman

1. Off the SSL certificate verification in General tab: (Second option under Request)

2. Off the Global Proxy Configuration and Use System Proxy in Proxy tab:

If both not work, try below code:

if(err)
{
    return res.status(500).json(err);
}
else{
    return res.status(200).json(req.body);
}

Hope, this may help you!

=========== EDITED ==============

Looking at your app.js file. It seems you need to use body-parser package to parse the JSON data from request.

npm install body-parser --save

body-parser extract the entire body portion of an incoming request stream and exposes it on req.body.