Guest User

Untitled

a guest
Oct 20th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. //IMPORTS
  2. var http = require('http');
  3. var mysql = require('mysql');
  4. //---------------------------------------------------
  5.  
  6. //HTTP RESPONSE
  7. http.createServer(function (req, res) {
  8. fetchActors(res);
  9. }).listen(8080);
  10. //---------------------------------------------------
  11.  
  12. //MISCS
  13.  
  14. //Database connection string
  15. var db = mysql.createConnection({
  16. host: "localhost",
  17. user: "root",
  18. password: "*********",
  19. database: "sakila"
  20. });
  21.  
  22. //Connection to database
  23. db.connect(function(err) {
  24. if (err) throw err;
  25. console.log("Connected to Database!");
  26. });
  27.  
  28. //-----------------------------------------------------
  29.  
  30. //FUNCTIONS
  31.  
  32. //Exectues queries on declared db (it can be extended if you want to use more than one db)
  33. function executeQuery(sql, cb) {
  34. db.query(sql, function (err, result, fields) {
  35. if (err) throw err;
  36. cb(result);
  37. });
  38. }
  39.  
  40. //Prints actors table
  41. function fetchActors(res){
  42. executeQuery("SELECT * FROM actor", function(result){
  43. res.write("<table>");
  44. res.write("<tr>");
  45. for(var column in result[0]){
  46. res.write("<td><label>" + column + "</label></td>");
  47. }
  48. res.write("</tr>");
  49. for(var row in result){
  50. res.write("<tr>");
  51. for(var column in result[row]){
  52. res.write("<td><label>" + result[row][column] + "</label></td>");
  53. }
  54. res.write("</tr>");
  55. }
  56. res.write("</table>");
  57. });
  58. }
Add Comment
Please, Sign In to add comment