Advertisement
Guest User

Untitled

a guest
Dec 9th, 2018
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. var express = require("express");
  2. var app = express();
  3. var path = require("path");
  4. var mysql = require('mysql');
  5. var bodyParser = require('body-parser');
  6. app.use(bodyParser.urlencoded({ extended: false }));
  7. app.use(bodyParser.json());
  8. var con = mysql.createConnection({
  9. host: "localhost",
  10. user: "root",
  11. password: "",
  12. database: "databas"
  13. });
  14. app.get('/',function(req,res){
  15. res.sendFile(path.join(__dirsteamid+'/index.html'));
  16. });
  17. app.post('/submit',function(req,res){
  18.  
  19. var steamid=req.body.steamid;
  20. var namn=req.body.namn;
  21. var usersteamid=req.body.usersteamid;
  22. res.write('echo "' + req.body.steamid+'".\n');
  23. res.write('echo "' + req.body.namn+'".\n');
  24.  
  25. con.connect(function(err) {
  26. if (err) throw err;
  27. var sql = "INSERT INTO whitelist (steamid, namn) VALUES ('"+steamid+"', '"+namn+"')";
  28. con.query(sql, function (err, result) {
  29. if (err) throw err;
  30. console.log("1 record inserted");
  31. res.end();
  32. });
  33. });
  34. })
  35. app.listen(3000);
  36. console.log("Running at Port 3000");
  37.  
  38. <html>
  39. <head>
  40. <title> test </title>
  41. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  42. </head>
  43. <body>
  44. <form action="/submit" method="POST">
  45. <fieldset>
  46. <label for="steamid">steamid: </label>
  47. <input type="text" id="steamid" steamid="steamid" autofocus />
  48. <br/>
  49. <label for="namn">namn: </label>
  50. <input type="namn" id="namn" steamid="namn" />
  51. <br/>
  52. <input type="submit" value="Whitelist" />
  53. </fieldset>
  54. </form>
  55. </body>
  56. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement