Guest User

Untitled

a guest
Oct 31st, 2018
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.03 KB | None | 0 0
  1. _http_outgoing.js:470
  2. throw new ERR_HTTP_HEADERS_SENT('set');
  3. ^
  4.  
  5. Error [ERR_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
  6. at ServerResponse.setHeader (_http_outgoing.js:470:11)
  7. at Array.write (/media/selin/Data/Documents/WORK/My Projects/Web Developing/GitHub/IgorZaviryukhaA2Lab/lesson_5/5-2_News/node_modules/finalhandler/index.js:285:9)
  8. at listener (/media/selin/Data/Documents/WORK/My Projects/Web Developing/GitHub/IgorZaviryukhaA2Lab/lesson_5/5-2_News/node_modules/on-finished/index.js:169:15)
  9. at onFinish (/media/selin/Data/Documents/WORK/My Projects/Web Developing/GitHub/IgorZaviryukhaA2Lab/lesson_5/5-2_News/node_modules/on-finished/index.js:100:5)
  10. at callback (/media/selin/Data/Documents/WORK/My Projects/Web Developing/GitHub/IgorZaviryukhaA2Lab/lesson_5/5-2_News/node_modules/ee-first/index.js:55:10)
  11. at IncomingMessage.onevent (/media/selin/Data/Documents/WORK/My Projects/Web Developing/GitHub/IgorZaviryukhaA2Lab/lesson_5/5-2_News/node_modules/ee-first/index.js:93:5)
  12. at IncomingMessage.emit (events.js:182:13)
  13. at endReadableNT (_stream_readable.js:1094:12)
  14. at process._tickCallback (internal/process/next_tick.js:63:19)
  15.  
  16. const
  17. express = require('express'), //include express module
  18. Url = require('url'), //include url module
  19. bodyParser = require('body-parser'), //for post requests
  20. mysql = require('mysql'), //include mySQL module
  21. app = express(), //server
  22.  
  23. connection = mysql.createConnection({ //connecting to database
  24. host: '127.0.0.1', //ip adress
  25. user: 'admin', //name of user in mySQL
  26. password: '123', //user password
  27. database: 'news' //database name
  28. });
  29.  
  30. connection.connect(function(err) { //establishing connecting to DB
  31. if (err) throw err; //if we have some exception
  32. console.log('Connected!'); //if everything is OK
  33. });
  34.  
  35. app.set('view engine', 'ejs'); //connect ejs to application
  36. app.use('/public', express.static('public')); //using static folder for css and more
  37. app.use(bodyParser.urlencoded({ extended: true })); //using body parser for POST requests
  38.  
  39. //generate root page for user
  40. app.get('/', function(request,response) {
  41. connection.query('SELECT title, text, date FROM news', function(err, result) {
  42. if (err) throw err;
  43. response.render('index', { posts: result });
  44. response.end();
  45. });
  46. });
  47.  
  48. app.post('/', function(request, response) {
  49. connection.query('SELECT password FROM moderator', function(err, result) {
  50. if (err) throw err;
  51. if (!req.body) return sendStatus(400);
  52. var password = result[0].password;
  53.  
  54. if (password === request.body.password) {
  55. response.render('index', { moderator: true });
  56. response.end();
  57. } else {
  58. response.render('index', { moderator: false });
  59. response.end();
  60. }
  61. });
  62. });
  63.  
  64. app.listen(8080); //listening to the port
  65.  
  66. response.render('index', { moderator: true });
  67.  
  68. response.render('index', { moderator: false });
Add Comment
Please, Sign In to add comment