dbms/sever.js at master · Isha-kumar/dbms · GitHub

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
66
67
68
69
70
var mysql = require('mysql')
var express = require('express')
var app = express()
var path = require('path')

app.listen(8080, function(err){
    if (err) throw err;
});

var con = mysql.createConnection({
    host : "localhost",
    user : "root",
    password : "goodgame",
    database : "college_mag"
})

app.set('views',  path.join(__dirname + '/views'))
app.set('view engine', 'ejs')
app.use( express.static( "assets" ) );

app.get('/',function(req, res){
    res.render('home')
    res.end()
})

app.get('/home',function(req, res){
    res.render('home')
})

// app.get('/student_login',function(req, res){

//     res.sendFile()
// })

// app.post('/student_check', function(req, res){
//     sql = ``
//     con.query(sql, function(err, result, fields){

//     })
// })


app.get('/admin', function(req, res){
    res.render('admin',{data: 'Admin Login'})
})

// app.post('/student_check', function(req, res){
//     sql = `select pwd from student where username = ${req.body.username}`
//     con.query(sql, function(err, result, fields){


//     })
// })


// app.get('/registration', function(req, res){
//     sql = ``
// })

// app.post('/enter_data', function(req, res){
//     sql = `insert into student values (${req.body.username}, ${req.body.pwd}, ${req.body.contact}, ${req.body.email}, ${req.body.address}, ${req.body.dob});`
//     con.query(sql, function(err){

//     })
// })

// app.get('/artical_upload', function(req, res){

// })