Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var express = require('express');
- var app = express();
- var bodyParser = require('body-parser');
- var mysql = require('mysql');
- var con = mysql.createConnection({
- host:"localhost",
- user:"root",
- passsword:"sree",
- database:"emp"
- });
- con.connect((err) =>{
- if(err) throw err;
- console.log('connected');
- })
- app.use( bodyParser.json() ); // to support JSON-encoded bodies
- app.use(bodyParser.urlencoded({ // to support URL-encoded bodies
- extended: true
- }));
- app.use(express.static('public'));
- app.get('/', function (req, res) {
- res.sendFile( __dirname + "/" + "main.html" );
- });
- app.get('/display',function(req, res){
- let sql = `SELECT * FROM details ORDER By id`;
- operations(sql, res);
- })
- app.post('/edit', (req, res) => {
- console.log(req.body);
- let sql = `UPDATE details SET name='${req.body.emName}', designation='${req.body.emDes}', company='${req.body.emCom}', email='${req.body.emEmail}' WHERE id=${req.body.emId}`;
- operations(sql, res);
- })
- function operations(sql, res){
- let response = {};
- con.query(sql, function(err, result, fields) {
- if(err){
- response.successful = false;
- console.error(err);
- console.log(JSON.stringify(result));
- res.send(JSON.stringify(response));
- return response;
- }else{
- if(Array.isArray(result)){
- if(result.length>0){
- response.data = result;
- response.successful = true;
- res.send(JSON.stringify(response));
- return response;
- }else{
- response.successful = false;
- res.send(JSON.stringify(response));
- return response;
- }
- }else{
- if(result.affectedRows>0){
- response.successful = true;
- res.send(JSON.stringify(response));
- return response;
- }else{
- response.successful = false;
- res.send(JSON.stringify(response));
- return response;
- }
- }
- }
- })
- }
- var server = app.listen(8081);
Add Comment
Please, Sign In to add comment