Guest User

Untitled

a guest
Jul 10th, 2018
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.37 KB | None | 0 0
  1. <form action="http://192.168.56.152:8080/submit" method="post">
  2. <div class="form-row">
  3. <div class="form-group col-md-6">
  4. <label for="firstname">Firstname</label>
  5. <input type="text" name="fname" class="form-control" id="formfirstname" placeholder="First Name">
  6. </div>
  7. <div class="form-group col-md-6">
  8. <label for="lastname">Last Name</label>
  9. <input type="text" name="lname" class="form-control" id="formlastname" placeholder="Last Name">
  10. </div>
  11. </div>
  12.  
  13.  
  14. <div class="form-row">
  15. <div class="form-group col-md-6">
  16. <label for="classify">Classification</label>
  17. <input type="text" name="classification" class="form-control" id="formclassify" placeholder="Junior">
  18. </div>
  19. <div class="form-group col-md-4">
  20. <label for="age">Age</label>
  21. <select id="inputState" name="state" class="form-control">
  22. <option selected="">16</option>
  23. <option>17</option>
  24. <option>18</option>
  25. <option>18</option>
  26. <option>20</option>
  27. <option>21</option>
  28. <option>22</option>
  29. <option>23</option>
  30. </select>
  31. </div>
  32. <div class="form-group col-md-2">
  33. <label for="uin">UIN</label>
  34. <input type="number" nam="number" class="form-control" id="uin">
  35. </div>
  36. </div>
  37.  
  38. <button type="submit" class="btn btn-primary">Submit</button>
  39. </form>
  40.  
  41. var mysql = require('mysql');
  42.  
  43. var connetion = mysql.createConnection({ //creating connetion to database
  44. host:"localhost",
  45. user: "root",
  46. password: "password!",
  47. database: "student_info"
  48. });
  49.  
  50. connetion.connect(function (err) {
  51. if(err) throw err;
  52. console.log("connection made!");
  53. });
  54.  
  55. module.exports = connetion;
  56.  
  57. const express = require('express');
  58. const bodyParser = require("body-parser");
  59. const application = express();
  60. const database = require('./connectplus');
  61. application.use(bodyParser.urlencoded({extended: true}))
  62. application.use(bodyParser.json());
  63.  
  64. application.post('/submit', function(req,res) {
  65. const firstName = req.body.fname;
  66. const lastName = req.body.lname;
  67. res.send('You sent the name "' + firstName + ' ' + lastName + '".');
  68.  
  69. // Later you use database query like this
  70. // database.query('SELECT now()');
  71. });
Add Comment
Please, Sign In to add comment