Guest User

Untitled

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