Read parameters from client account

1 files changed, 22 insertions, 0 deletions

diff --git a/clients.js b/clients.js
new file mode 100644
index 00000000..f75b5d52
--- /dev/null
+++ b/clients.js
@@ -0,0 +1,22 @@
+var http = require('http');
+var mysql = require('mysql');
+var url = require('url');
+
+http.createServer(function (req, res) {
+  res.writeHead(200, { 'Content-Type': 'text/plain' });
+  var client = url.parse(req.url, true).query.client;
+
+  var connection = mysql.createConnection({
+    host     : 'localhost',
+    user     : 'root',
+    password : 'MPJzfq97',
+    database:  'vanbtc'
+  });
+
+  connection.connect();
+  connection.query("SELECT * FROM users WHERE login = ?", [client], function(err, rows) {
+    res.write(JSON.stringify(rows));
+    connection.end();
+    res.end();
+  });
+}).listen(8000);