Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2019
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. var express = require('express');
  2. var app = express();
  3. app.get('/', function (req, res) {
  4.  
  5. var mysql = require('mysql');
  6.  
  7. var con = mysql.createConnection({
  8. host: "",
  9. user: "",
  10. password: "",
  11. database: ""
  12. });
  13.  
  14. con.connect(function(err) {
  15. if (err) throw err;
  16. //Select all customers and return the result object:
  17. con.query("SELECT * FROM table", function (err, result, fields) {
  18. if (err) throw err;
  19. console.log(result);
  20. });
  21. });
  22.  
  23. res.send('Hello World!');
  24. });
  25. app.listen(3000, function () {
  26. console.log('Example app listening on port 3000!');
  27. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement