78 lines
2.0 KiB
JavaScript
78 lines
2.0 KiB
JavaScript
var mysql = require('mysql');
|
|
var express = require('express');
|
|
var session = require('express-session');
|
|
var bodyParser = require('body-parser');
|
|
var path = require('path');
|
|
|
|
var connection = mysql.createConnection({
|
|
host : 'localhost',
|
|
user : 'root',
|
|
password : '',
|
|
database : 'fiokok'
|
|
});
|
|
|
|
var app = express();
|
|
app.use(session({
|
|
secret: 'secret',
|
|
resave: true,
|
|
saveUninitialized: true
|
|
}));
|
|
app.use(bodyParser.urlencoded({extended : true}));
|
|
app.use(bodyParser.json());
|
|
|
|
app.get('/', function(request, response) {
|
|
response.sendFile(path.join(__dirname + '/bej.html'));
|
|
});
|
|
|
|
app.post('/auth', function(request, response) {
|
|
var email = request.body.email
|
|
var password = request.body.password;
|
|
if (email && password) {
|
|
connection.query('SELECT * FROM fiokok WHERE email = ? AND password = ?', [email, password], function(error, results, fields) {
|
|
if (results.length > 0) {
|
|
request.session.loggedin = true;
|
|
request.session.email = email;
|
|
response.redirect('/home');
|
|
} else {
|
|
response.send('Helytelen Email vagy Jelszó!');
|
|
}
|
|
response.end();
|
|
});
|
|
} else {
|
|
response.redirect('/siker.html');
|
|
response.end();
|
|
}
|
|
});
|
|
|
|
app.post('/reg.html', function(request, response) {
|
|
var email = request.body.email
|
|
var password = request.body.password;
|
|
if (email && password) {
|
|
connection.query('SELECT * FROM fiokok WHERE email = ? AND password = ?', [email, password], function(error, results, fields) {
|
|
if (results.length > 0) {
|
|
request.session.loggedin = true;
|
|
request.session.email = email;
|
|
response.redirect('/reg.html');
|
|
} else {
|
|
response.send('Helytelen Email vagy Jelszó!');
|
|
}
|
|
response.end();
|
|
});
|
|
} else {
|
|
response.send('Kérlek elentkezz be!');
|
|
response.end();
|
|
}
|
|
});
|
|
|
|
app.get('/home', function(request, response) {
|
|
if (request.session.loggedin) {
|
|
response.send('Üdvözöllek, ' + request.session.email + '!');
|
|
} else {
|
|
response.send('Kérem jelentkezzen be!');
|
|
}
|
|
response.end();
|
|
});
|
|
|
|
app.listen(3000);
|
|
|