Skip to content

Instantly share code, notes, and snippets.

View angelique-w's full-sized avatar

angelique-w

2 followers · 0 following
View GitHub Profile
@angelique-w
angelique-w / index.html
Created December 5, 2019 14:03
quête redux
<!DOCTYPE html>
<html lang="en">
<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 -->
@angelique-w
angelique-w / index.js
Created December 3, 2019 22:50
quête express 5
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
const bodyParser = require('body-parser');
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({
extended: true
@angelique-w
angelique-w / index.js
Created December 3, 2019 22:50
quête express 5
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
const bodyParser = require('body-parser');
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({
extended: true
@angelique-w
angelique-w / index.js
Created December 3, 2019 22:37
quête express 4
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
const bodyParser = require('body-parser');
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({
extended: true
@angelique-w
angelique-w / index.js
Created December 3, 2019 21:31
quête express 3
const express = require('express');
const app = express();
const port = 3000;
const connection = require('./conf');
const bodyParser = require('body-parser');
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({
extended: true
@angelique-w
angelique-w / index.js
Created December 1, 2019 17:54
quest express 2
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');
@angelique-w
angelique-w / quest-express-1.js
Last active November 28, 2019 08:16
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 idMovie = req.params.id;
@angelique-w
angelique-w / request.http
Created November 25, 2019 21:20
###
GET https://http-practice.herokuapp.com/wilders
Accept: application/json
###
GET https://http-practice.herokuapp.com/wilders?page=2&language=PHP
###
POST https://http-practice.herokuapp.com/wilders
Content-Type: application/x-www-form-urlencoded
@angelique-w
angelique-w / server.js
Created November 25, 2019 20:23
const http = require('http');
const url = require('url');
const port = 8000;
const requestHandler = (request, response) => {
console.log(request.url);
const parsedUrl = url.parse(request.url, true);
const parsedUrlQuery = parsedUrl.query;
console.log(parsedUrlQuery);
if (parsedUrlQuery.name && parsedUrlQuery.city) {
@angelique-w
angelique-w / quest-3-mysql.sql
Created November 19, 2019 16:26
mysql> INSERT INTO school (name, country, capacity) VALUES ('Beauxbatons Academy of Magic', 'France', 550), ('Castelobruxo', 'Brazil', 380), ('Durmstrang Institute', 'Norway', 570), ('Koldovstoretz', 'Russia', 125), ('Mahoutokoro School of Magic', 'Japan', 800), ('Uagadou School of Magic', 'Uganda', 350);
mysql> UPDATE school SET country='Sweden' WHERE id=3;
mysql> UPDATE school SET capacity=700 WHERE id=5;
mysql> DELETE FROM school WHERE name LIKE '%Magic%';
mysql> SELECT * FROM school;
+----+----------------------+----------+---------+