var mysql = require('mysql');var http = require('http'); var connection = mysql.createConnection({ host: "localhost", user: "akbarali", password: "akbarali", database: "akbarali"}); http.createServer(function(req, res, rows) { res.writeHead(200, { 'Content-Type': 'text/html' }); res.write( '<!DOCTYPE html>' +'<head>' +'<meta charset="utf-8">' +'<title>Maqolalar</title>' +'</head>' +'<body>' +'<table align="center" border="1px">' +'<h1 align="center">Bloglar</h1>'); var stroka = ""; connection.query('SELECT id, name FROM blog WHERE types = "u"', function(err, rows, fields) { if (err) throw err; for (var i in rows) { stroka = '<tr><td>'+rows[i].id+'</td><td>'+rows[i].name+'</td></tr>'; res.write(stroka); } res.write('</table>' +'</body>' +'</html>'); res.end(); });}).listen(3000);
« Mavzuga qaytish