Serverwork/get.js at master · teddy2021/Serverwork · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
const mysql = require('mysql');

// Get

const con = mysql.createConnection({
	host:'localhost',
	user:'serveradmin',
	password: 'Cm%!35Oa3C7^l',
	database:'chat'
});


exports.get = function (req, res){


	if(req.url == '/Pages'){
		con.query('SELECT * FROM rooms', (err, result) => {
			if(err){
				res.writeHead(500, {'Content-Type': 'text/html'});
				throw err;
			}
			else{
				res.writeHead(200, {'Content-Type' : 'application/json'});
				res.write(JSON.stringify(result));
				res.end();
			}
		});
	}
	else if(req.url == '/Messages'){
		con.query('SELECT * FROM ? ORDER BY dt', req.title, (err, result) => {
			if(err){
				res.writeHead(500, {'Content-Type': 'text/html'});
				res.end();
				throw err;
			}
			else{
				res.writeHead(200, {'Content-Type': 'application/json'});
				res.write(JSON.stringify(result));
				res.end();
			}
		});
	}
}