Guest User

Untitled

a guest
Jan 12th, 2017
37
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.81 KB | None | 0 0
  1. Client js
  2.  
  3. window.addEventListener('loaded', function {
  4. document.getElementById('submit').addEventListener('submit', function(e) {
  5. e.preventDefault();
  6. var xhr = new XMLHttpRequest();
  7. xhr.open('POST', '/insert', true);
  8. xhr.setRequestHeader('Content-type', 'application/x-www-form-urlencoded');
  9. xhr.onload = function () {
  10. // do something to response
  11. console.log(this.responseText);
  12. };
  13. xhr.send(new FormData(document.getElementById('signup')));
  14. })
  15.  
  16.  
  17.  
  18. server js
  19.  
  20. var http = require('http');
  21. var mysql = require('mysql');
  22. var express = require('express');
  23. var app = express();
  24. var connection = mysql.createConnection({
  25. host: 'localhost',
  26. user: 'root',
  27. password: '12345',
  28. database: 'employee'
  29. });
  30.  
  31. console.log('MySQL Connection details '+connection);
  32.  
  33. app.get('/:id', function(request, response) {
  34. connection.query('SELECT * FROM employee WHERE id='+request.params.id, function(err, rows, fields) {
  35. console.log('Connection result error '+err);
  36. response.end("result"+JSON.stringify(rows))
  37. });
  38. })
  39.  
  40.  
  41. app.post('/insert', function(req, res) {
  42.  
  43. // Add these values to your MySQL database here
  44. connection.query("INSERT into employee (name) VALUES (?)", request.params.name, function(err, result) {
  45. });
  46. });
  47.  
  48. app.use('/client', express.static(__dirname + '/client'));
  49.  
  50. app.listen(8081);
  51.  
  52.  
  53. HTML
  54.  
  55. <!DOCTYPE html>
  56. <html>
  57. <head>
  58. <title></title>
  59. <script type="text/javascript" src="client.js"></script>
  60. </head>
  61. <body>
  62. <div id="container">
  63. <div id="registration">
  64. <form onsubmit="signup()" method="POST" id="signup">
  65. <label>Name <input type="text" name="name" value="foo" id="name"></label>
  66. <input type="submit" value="Sign Up" id="submit"></label>
  67. </form>
  68. </div>
  69. </div>
  70. </body>
  71. </html>
Add Comment
Please, Sign In to add comment