This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const express = require('express'); | |
const app = express(); | |
const port = 3000; | |
const connection = require('./conf.js') | |
const bodyParser = require('body-parser'); | |
app.use(bodyParser.json()); | |
app.use(bodyParser.urlencoded({ | |
extended: true | |
})); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Trouve l'expression régulière qui cherche la seule occurrence du deuxième prénom de Néo (soit le A. de "Thomas A. Anderson). | |
/A\./g | |
Trouve l'expression régulière qui cherche la date contenue dans le document. | |
\d{2}\/\d{2}\/\d{4} | |
Trouve l'expression qui cherche la note contenue dans le texte, sans pour autant sélectionner une partie de la date (tu peux t'aider du caractère espace avant la note). | |
\b\d{1}\/\d{2} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const express = require('express'); | |
const app = express(); | |
const port = 3000; | |
const connection = require('./conf'); | |
app.get('/api/movies', (req, res) => { | |
connection.query('SELECT * from movie', (err, results) => { | |
if (err) { | |
res.status(500).send('Erreur lors de la récupération des films'); | |
} else { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const express = require('express'); | |
const app = express(); | |
const port = 3000; | |
app.get('/api/movies', (req, res) => { | |
res.send('Récupération de tous les films'); | |
}); | |
app.get('/api/movies/:id', (req, res) => { | |
const movieid = req.params.id |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const express = require('express'); | |
const app = express(); | |
const port = 3100; | |
app.get('/api/movies', (req, res) => { | |
res.send('Récupération de tous les films'); | |
}); | |
app.get('/api/movies/:id', (req, res) => { | |
const movieid = req.params.id |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const http = require('http'); | |
const port = 3000; | |
const requestHandler = (request, response) => { | |
console.log(request.url); | |
if (request.url.includes('/contact')) { | |
response.end('Nous ne sommes pas joignables pour le moment !') | |
} | |
else if (request.url.includes('/display')) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Modifier le nom du film ayant l'ID 5, en le remplaçant par "Men in Black": | |
UPDATE movie | |
SET name= 'Men in Black' | |
WHERE id='5' | |
Modifier le nom et le poster du film ayant l'ID 8, en remplaçant le nom par "Deadpool" et le poster par l'url suivante : "https://upload.wikimedia.org/wikipedia/en/thumb/2/23/Deadpool_%282016_poster%29.png/220px-Deadpool_%282016_poster%29.png" | |
UPDATE movie | |
SET name= 'Deadpool', poster = 'https://upload.wikimedia.org/wikipedia/en/thumb/2/23/Deadpool_%282016_poster%29.png/220px-Deadpool_%282016_poster%29.png%22' | |
WHERE id='8' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Ajouter un film sans spécifier les noms des colonnes dans la requête: | |
INSERT INTO movie VALUES (null, 'La cité de la Peur', 'https://pmcdn.priceminister.com/photo/Cite-De-La-Peur-La-VHS-239798630_ML.jpg', 'sehr gut') | |
Ajouter un film en spécifiant toutes les colonnes sauf l'ID: | |
INSERT INTO movie (name, poster, comment) VALUES ('La cité de la Peur', 'https://pmcdn.priceminister.com/photo/Cite-De-La-Peur-La-VHS-239798630_ML.jpg', 'sehr gut') | |
Ajouter 3 films dans une même requête en spécifiant toutes les colonnes sauf l'ID: | |
INSERT INTO movie (name, poster, comment) VALUES ('Good Will Hunting', 'http://fr.web.img4.acsta.net/medias/00/05/30/000530_af.jpg', 'inspiring'), ('Breaking the Waves', 'https://images-na.ssl-images-amazon.com/images/I/7191nscjUwL._SY445_.jpg', 'Disturbing'), ('Les Visiteurs', 'http://fr.web.img6.acsta.net/medias/nmedia/18/36/07/69/18659413.jpg', 'Family classic') | |
Ajouter un film en spécifiant uniquement son nom: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
L'ensemble des données de la table: | |
SELECT * FROM `movie` | |
Uniquement les noms des films: | |
SELECT name FROM `movie` | |
L'ID et le poster des films: | |
SELECT id, poster FROM `movie` | |
Le poster et le commentaire, mais en renommant la colonne "commentaire" en "avis_spectateur": |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html> | |
<head> | |
<meta charset="utf-8" /> | |
<meta http-equiv="X-UA-Compatible" content="IE=edge"> | |
<title>Counter Redux</title> | |
<meta name="viewport" content="width=device-width, initial-scale=1"> | |
<!-- Redux CDN --> | |
<script src="https://cdnjs.cloudflare.com/ajax/libs/redux/4.0.1/redux.min.js"></script> |