express mysql post simple example

npm install mysql express

example.js

var bodyParser = require('body-parser');

var express = require('express');

var mysql = require("mysql");

var con = mysql.createConnection({

host: "localhost",

user: "root",

password: "1234",

database: "rankData"

});

con.connect(function(err) {

if (err) {

console.log('SQL connecting error');

return;

}

console.log('SQL connecting success');

});

var app = express();

app.use(bodyParser.json());

app.use(bodyParser.urlencoded({ extended: false }));

app.get('/', function (req, res) {

res.send('hello world');

})

///someurl/123 ： req.params.text = 123

app.get('/someurl/:text', function (req, res) {

res.send('GOOOOOOOOOD' + req.params.text);

})

// Insert SQL

app.post('/rankAdd', function (req, res, next) {

console.log(req.body);

var sql = {

rank: req.body.rank,

systemUser: req.body.systemUser,

};

console.log(sql);

var qur = con.query('INSERT INTO rankrecord SET ?', sql, function (err, rows) {

if (err) {

console.log(err);

}else{

res.setHeader('Content-Type', 'application/json');

res.send(req.body);

}

});

});

app.listen(3000, function () {

console.log('listening on port 3000!')

})