app.js

//YE SERVER SIDE KA CODE HAI IDK HOW TO TAKE THE DATA I GOT IN getCourses() TO CLIENT SIDE TO DISPLAY
var express = require('express');
var mysql = require('mysql');
var app = express();
var bodyParser = require('body-parser');
var cookieParser = require('cookie-parser');
var session = require('express-session');
var validator = require('express-validator');


app.use(express.static('public'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: true }));
app.use(validator());
app.use(cookieParser());
app.use(session({
    secret: 'thisismysecretkey',
    saveUninitialized: true,
    resave: true
}));




var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'vle'
});



connection.connect(function (error) {
    if (!!error) {
        console.log('Error');
    }
    else {
        console.log('Connected');

    }
});


//function sessionCheck(req, res, next) {

//   if (req.session)
//   {
//        return next;
//   }
//   else {
//       res.redirect('/');
//   } }


app.get("/", function (req, res) {
    console.log("homepage loaded");
    res.sendFile(__dirname + "/public/page_HomePage.html");

});

app.get("/signup", function (req, res) {

    res.redirect("sign-up.html");

});

//GET STUDENT COURSES FROM DB TO DISPLAY

function getCourses(user, res) {
    //getting user id
    var user_id = "";
    var courses = [];
    connection.query('SELECT id FROM students WHERE username = ?', [user], function (error, feilds) {
        if (!!error) {
            console.log("Error : Finding user in DB");
            console.log(error);
        }
        else {
            if (feilds.length) {

                user_id = feilds[0].id;
                //finding courses in enrollments

                connection.query('SELECT courses_id FROM enrollments WHERE students_id = ?', [user_id], function (error, feilds) {
                    if (!!error) {
                        console.log("Error : Finding user in DB");
                        console.log(error);
                    }
                    else {
                        if (feilds.length) {
                            //inserting all course_ids to caousre object
                            for (var i = 0; i < feilds.length; i++) {
                                courses.push(feilds[i].courses_id);
                                console.log(feilds[i].courses_id);
                                connection.query('SELECT name,image FROM courses WHERE id = ?', [feilds[i].courses_id], function (error, feilds) {
                                    if (!!error) {
                                        console.log("Error : Finding user in DB");
                                        console.log(error);
                                    }
                                    else
                                    {

                                    }
                                });

                            }


                        }
                    }
                });

            }
        }
    });




}


app.post('/register', function (req, res) {
    req.check('email', 'Invalid Email Address').isEmail();
    req.check('password', 'Password should be atleast 6 letters long').isLength({ min: 6 });
    req.check('password', 'Passwords dont match').equals(req.body.passwordConfirmation);
    var errors = req.validationErrors();
    if (errors) {
        req.session.errors = errors;
        req, session.success = false;
    }
    else {
        req.session.success = true;
    }
    var user = req.body.userName;
    var first = req.body.firstName;
    var last = req.body.lastName;
    var em = req.body.email;
    var pas = req.body.password;
    var pas1 = req.body.passwordConfirmation;
    var available = false;



    connection.query('SELECT username FROM students WHERE username = ?', [user], function (error, feilds) {
        if (!!error) {
            console.log("Error : Finding user in DB");
            console.log(error);
        }
        else {
            if (feilds.length) {

                console.log('Username not Available');
                res.redirect('sign-up.html');
            }
            else if (!feilds.length) {
                connection.query('SELECT username FROM tutors WHERE username = ?', [user], function (error, feilds) {
                    if (!!error) {
                        console.log("Error : Finding user in DB");
                        console.log(error);
                    }
                    else {
                        if (feilds.length) {

                            console.log('Username not Available');
                            res.redirect('sign-up.html');
                        }
                    }
                });
            }
            else {

                if (pas == pas1) {
                    var que = "INSERT INTO students (email,username,password,first_name,last_name) VALUES (?,?,?,?,?)";
                    var check = connection.query(que, [em, user, pas, first, last], function (err, rows) {
                        if (!!err) {

                            console.log("Could not insert into DB", err);
                        }
                        else {
                            console.log('Successful INSERTION');
                            res.redirect('/login.html');
                            //console.log("Data inserted:::::", rows.insertId);
                        }


                    });
                    // console.log('connection----------------------',check);
                }
                else {
                    console.log("Password Mismatch!");
                    res.redirect('public/sign-up.html');
                }


            }


        }
    });
});

app.get('/logout', function (req, res) {
    req.session.destroy();
    console.log('Session DESTROYED');
    res.redirect("Page_HomePage.html");
});


app.get('/login', function (req, res) {
    session = req.session;
    if (session.uniqueID) {
        console.log('Session found');
        res.redirect('/website-student-dashboard.html');
    }
    else {
        console.log('Session NOT found');
        res.redirect("login.html");
    }

});


app.post('/login', function (req, res) {
    var user = req.body.username;
    var pas = req.body.password;
    var found = false;
    session = req.session;
    if (user != null && pas != null) {
        if (!found) {
            connection.query('SELECT username,password FROM students WHERE username = ?', [user], function (error, feilds) {
                if (!!error) {
                    console.log("Error : Finding user in DB for Login");
                }
                else {
                    if (feilds.length && (feilds[0].password == pas)) {
                        console.log('User logged in as student');
                        found = true;
                        session.uniqueID = req.body.username;
                        console.log('Session created :', session.uniqueID);
                        res.redirect('/website-student-dashboard.html');
                        //getCourses(user, res);
                    }

                }
            });
        }
        if (!found) {
            connection.query('SELECT username,password FROM tutors WHERE username = ?', [user], function (error, feilds) {
                if (!!error) {
                    console.log("Error : Finding user in DB for Login");
                }
                else {
                    if (feilds.length && (feilds[0].password == pas)) {
                        console.log('User logged in as tutor');
                        found = true;
                        session.uniqueID = req.body.username;
                        console.log('Session created :', session.uniqueID);
                        res.redirect('/website-instructor-dashboard.html');

                    }

                }
            });
        }
        else {
            console.log('Invalid username/password');
            res.redirect('login.html');
        }

    }
    else {
        console.log('Please enter username and password');
    }

});


app.listen(3000);