main.js

var express = require('express');
var mysql = require('mysql');



var router = express.Router();
var connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'djscrave',
  database: 'canicule'
});
connection.connect();

/* GET home page. */
router.get('/', function (req, res, next) {
  res.render('index', { title: 'Express' });
});


/* Action en POST */
router.post('/store', function (req, res, next) {
  console.log(req.body.title);
  connection.query('SELECT * FROM movies', function (error, results, fields) {
    res.json(results);
  });
  connection.end();

  res.redirect('/'); //redirection
});


router.get('/movies', function (req, res, next) {
  connection.query('SELECT * FROM movies', function (error, results, fields) {
    res.json(results);
  });
  connection.end();
});




module.exports = router;