-
Notifications
You must be signed in to change notification settings - Fork 0
/
register.js
65 lines (41 loc) · 1.03 KB
/
register.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
var express = require('express');
var mysql = require('mysql');
var router=express.Router();
var cookieParser = require('cookie-parser');
var fs= require('fs');
const bodyParser = require('body-parser');
router.use(cookieParser());
router.post('/',function(req,res){
var connection = mysql.createConnection({
host:'localhost',
user:'root',
password: 'vishal',
database: 'airline'
});
connection.connect(function(err) {
if (err) throw err;
console.log("Connected!");
});
var flightno = req.body.flightno;
console.log(flightno);
console.log("Register Here");
var sql = "select * from flight where flightno=?"
connection.query(sql,[flightno],function(err,result){
if(err) throw err;
else
{
console.log("Here you go");
console.log(result);
}
res.writeHead(200, {
'Content-Type': 'text/html'});
res.write(result[0].flightno);
res.write('<br>');
res.write(result[0].flightname);
fs.readFile("Flighty/register.html",function(err,content)
{ res.end(content)});
//res.end();
connection.end();
});
});
module.exports = router;