Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- HTML
- <!DOCTYPE html>
- <html>
- <head>
- <title></title>
- <script type="text/javascript" src="client.js"></script>
- </head>
- <body>
- <div id="container">
- <div id="registration">
- <form action = "/insert" id="signup">
- <label>Name <input type="text" name="name" value="foo" id="name"></label>
- <input type="submit" value="Sign Up" id="submit"></label>
- </form>
- </div>
- </div>
- </body>
- </html>
- CLIENTJS
- window.addEventListener('load', function() {
- document.getElementById('signup').addEventListener('submit', function(e) {
- e.preventDefault();
- var xhr = new XMLHttpRequest();
- xhr.open('POST', '/insert', true);
- xhr.onload = function () {
- // do something to response
- console.log(this.responseText);
- };
- xhr.send(new FormData(document.getElementById('signup')));
- });
- });
- SERVERJS
- var http = require('http');
- var mysql = require('mysql');
- var express = require('express');
- var app = express();
- var bodyParser = require('body-parser');
- var bodyparser=bodyParser.urlencoded({extended: false});
- var connection = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- password: '12345',
- database: 'employee'
- });
- console.log('MySQL Connection details ');
- app.get('/:id', function(request, response) {
- connection.query('SELECT * FROM employee WHERE id='+request.params.id, function(err, rows, fields) {
- console.log('Connection result error '+err);
- response.end("result"+JSON.stringify(rows))
- });
- })
- app.post('/insert',function(req, res) {
- var post = req.params.name;
- console.log(post);
- var query =connection.query('INSERT INTO employee(name)VALUES("'+post+'")', function(err, result) {
- console.log(err);
- });
- });
- app.use('/client', express.static(__dirname + '/client'));
- app.listen(8081);
Add Comment
Please, Sign In to add comment