<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
Keyboard Shortcuts
Shortcut | Action |
---|---|
ctrl + [num] | Toggle nth panel |
ctrl + 0 | Close focused panel |
ctrl + enter | Re-render output. If console visible: run JS in console |
Ctrl + l | Clear the console |
ctrl + / | Toggle comment on selected lines |
ctrl + ] | Indents selected lines |
ctrl + [ | Unindents selected lines |
tab | Code complete & Emmet expand |
ctrl + shift + L | Beautify code in active panel |
ctrl + s | Save & lock current Bin from further changes |
ctrl + shift + s | Open the share options |
ctrl + y | Archive Bin |
Complete list of JS Bin shortcuts |
JS Bin URLs
URL | Action |
---|---|
/ | Show the full rendered output. This content will update in real time as it's updated from the /edit url. |
/edit | Edit the current bin |
/watch | Follow a Code Casting session |
/embed | Create an embeddable version of the bin |
/latest | Load the very latest bin (/latest goes in place of the revision) |
/[username]/last | View the last edited bin for this user |
/[username]/last/edit | Edit the last edited bin for this user |
/[username]/last/watch | Follow the Code Casting session for the latest bin for this user |
/quiet | Remove analytics and edit button from rendered output |
.js | Load only the JavaScript for a bin |
.css | Load only the CSS for a bin |
Except for username prefixed urls, the url may start with http://jsbin.com/abc and the url fragments can be added to the url to view it differently. |