<code>
var
express =
require
(
'express'
);
var
app = express();
app.get(
'/shorten'
,
function
(req, res) {
var
mysql =
require
(
'mysql'
);
var
connection = mysql.createConnection({
host :
'121.42.209.162'
,
user :
'root'
,
password :
'password'
,
database :
'mydatabase'
});
connection.connect(
function
(err) {
if
(err) {
console.error(
'error connecting: '
+ err.stack);
return
;
}
console.log(
'connected as id '
+ connection.threadId);
});
var
long=req.query.long;
console.log(long);
connection.query(
"SELECT * FROM url WHERE long='"
+long+
"'"
,
function
(err, rows) {
if
(err){
console.log(err.code);
console.log(err.fatal);
res.send(
"fail"
);
}
else
{
res.send(
"ok"
);
}
});
connection.
end
();
});
var
server = app.listen(3000,
function
() {
var
host = server.address().address;
var
port = server.address().port;
console.log(
'Example app listening at http://%s:%s'
, host, port);
});</code>