Advertisement
Guest User

req.params undfined

a guest
Dec 6th, 2014
484
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. // Setup server
  2. var express    = require('express');
  3. var app        = express();
  4. var path       = require('path');
  5. var db         = require('./db.js');
  6. var bodyParser = require('body-parser');
  7. var methodOverride = require('method-override');
  8.  
  9. // Tools
  10. app.set('view engine', 'ejs');
  11. app.use(methodOverride('_method'));
  12. app.use(bodyParser.json());
  13. app.use(bodyParser.urlencoded());
  14.  
  15. // Listen on port
  16. app.listen(3000);
  17. console.log('Server running');
  18.  
  19. // ROUTE: Homepage
  20. app.get("/", function(req,res) {
  21.   db.query("SELECT * FROM entries", function(err, dbRes) {
  22.     if (!err) {
  23.       res.render('index', { entries: dbRes.rows });  
  24.     }
  25.   });
  26. });
  27.  
  28. // ROUTE: List of all entries
  29. app.get('/entries', function(req,res) {
  30.   db.query('SELECT * FROM entries', function(err, dbRes) {
  31.     if(!err) {
  32.       res.render('entries', { entries: dbRes.rows });
  33.     }
  34.   });
  35. });
  36.  
  37. // ROUTE: Create a new blog entry
  38. app.get("/new", function(req,res) {
  39.   res.render('new');
  40. });
  41.  
  42. app.post('/entries', function(req, res) {
  43.   var params = [
  44.     req.body.article_title,
  45.     req.body.article_body,
  46.     req.body.article_tags
  47.   ];
  48.  
  49.   db.query(
  50.     "INSERT INTO entries (article_title, article_body, article_tags) VALUES ($1, $2, $3)", params, function(err, dbRes) {
  51.       if (!err) {
  52.         res.redirect('/');
  53.       }
  54.     }
  55.   );
  56. });
  57.  
  58. // ROUTE: View an entry
  59. app.get('/:id', function(req, res) {
  60.   console.log(req.params);
  61.   db.query("SELECT * FROM entries WHERE id = $1", [req.params.id], function(err, dbRes) {
  62.     if (!err) {
  63.       res.render('show', { entry: dbRes.rows[0] });
  64.     }
  65.   });
  66. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement