var Client = require('/usr/local/lib/node_modules/mysql').Client;
var client = new Client();
client.user = 'root';
client.password = '';
console.log('Connecting to MySQL...');
client.query('USE tiny_shop'); //如果MySQL已建立库表。
http = require("http");
var server = http.createServer(function(request, response) {
response.writeHeader(200, {"Content-Type": "text/html"});
client.query('SELECT * FROM tags', function selectCb(err, results, fields) {
if (err) {
throw err;
}
var data = '';
for (var i=0; i<results.length; i++) {
var firstResult = results[i];
data += 'id: ' + firstResult['id']+'tag: ' + firstResult['tag'];
}
response.write(data);
response.end()
});
});
server.listen(8080);
var sys = require("util");
sys.puts("Server running at http://localhost:8080/"); //模块文件放在 /usr/local/lib/node_modules 这个目录下。