Guest User

Untitled

a guest
Jun 22nd, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.26 KB | None | 0 0
  1. var express = require('express');
  2. var app = express();
  3. var bodyParser = require('body-parser');
  4. var mysql = require('mysql');
  5. var con = mysql.createConnection({
  6. host:"localhost",
  7. user:"root",
  8. passsword:"sree",
  9. database:"emp"
  10. });
  11.  
  12. con.connect((err) =>{
  13. if(err) throw err;
  14. console.log('connected');
  15. })
  16. app.use( bodyParser.json() ); // to support JSON-encoded bodies
  17. app.use(bodyParser.urlencoded({ // to support URL-encoded bodies
  18. extended: true
  19. }));
  20.  
  21. app.use(express.static('public'));
  22.  
  23. app.get('/', function (req, res) {
  24. res.sendFile( __dirname + "/" + "main.html" );
  25. });
  26.  
  27. app.get('/display',function(req, res){
  28. let sql = `SELECT * FROM details ORDER By id`;
  29. operations(sql, res);
  30. })
  31.  
  32. app.post('/edit', (req, res) => {
  33. console.log(req.body);
  34. 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}`;
  35. operations(sql, res);
  36. })
  37. function operations(sql, res){
  38. let response = {};
  39. con.query(sql, function(err, result, fields) {
  40. if(err){
  41. response.successful = false;
  42. console.error(err);
  43. console.log(JSON.stringify(result));
  44. res.send(JSON.stringify(response));
  45. return response;
  46. }else{
  47. if(Array.isArray(result)){
  48. if(result.length>0){
  49. response.data = result;
  50. response.successful = true;
  51.  
  52. res.send(JSON.stringify(response));
  53. return response;
  54. }else{
  55. response.successful = false;
  56.  
  57. res.send(JSON.stringify(response));
  58. return response;
  59. }
  60. }else{
  61. if(result.affectedRows>0){
  62. response.successful = true;
  63.  
  64. res.send(JSON.stringify(response));
  65. return response;
  66. }else{
  67. response.successful = false;
  68.  
  69. res.send(JSON.stringify(response));
  70. return response;
  71. }
  72. }
  73. }
  74. })
  75. }
  76. var server = app.listen(8081);
Add Comment
Please, Sign In to add comment