Skip welcome & menu and move to editor
Welcome to JS Bin
Load cached copy from
 
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width">
  <title>JS Bin</title>
</head>
<body>
</body>
</html>
 
var express = require('express');
var app = express();
var bodyParser = require('body-parser');
var mysql = require('mysql');
mysql = mysql.createConnection({
  host: 'localhost',
  user: 'test',
  password: '````',
  database: 'user_db'
});
mysql.connect(function (err) {
  if (err) console.log(err);
  else console.log('Connected');
});
app.use(express.static('public'));
app.get('/', function (req, res) {
  res.sendFile(__dirname + '/index.html');
});
app.use(bodyParser.urlencoded({
  extended: true
}));
app.post('/', function (req, res) {
  var client_login = req.body.login;
  var client_pass = req.body.pass;
  mysql.query('SELECT id, password FROM users WHERE login = ?', client_login, function (error, results, fields) {
    if (!results.length || client_pass === '' ) {
      console.log('Ошибка ввода');
    }
    else {
      var sqlPass = results[0].password;
      if (client_pass === sqlPass) {
        res.redirect(302, '/hello.html');
      }
      else{
        console.log('Ошибка ввода!');
      }
    }
  });
  
});
app.listen(3000);
Output

You can jump to the latest bin by adding /latest to your URL

Dismiss x
public
Bin info
anonymouspro
0viewers