clemderome

/GRUYEREINSTANCEID/deletesnippet?index=0

clemderome

1: https://xss-game.appspot.com/level1/frame?query=<script>+alert('alert')</script>

2: <a href='#' onerror="alert('alert');/>

clemderome

// Typage proposé par typescript:
// users: any[]

interface User {
    name: string; 
    age?: number;
    birthday?: string;
}

const prettyPrintWilder = (users: User[]): void =>  {

clemderome

mysql> SELECT t.name, COUNT(*) AS nb_players 
FROM player p JOIN team t ON t.id = p.team_id 
GROUP BY team_id 
ORDER BY nb_players DESC;
+------------+------------+
| name       | nb_players |
+------------+------------+
| Gryffindor |         36 |
| Slytherin  |         21 |
| Ravenclaw  |         15 |

clemderome

mysql> SELECT w.lastname, w.firstname, p.role, t.name
    -> FROM wild_db_quest.player p
    -> JOIN wild_db_quest.wizard w
    -> ON w.id = p.wizard_id
    -> JOIN wild_db_quest.team t
    -> ON t.id = p.team_id
    -> ORDER BY t.name, p.role, w.lastname, w.firstname;
+-----------------+-------------+--------+------------+
| lastname        | firstname   | role   | name       |
+-----------------+-------------+--------+------------+

clemderome

app.delete('/api/movie/:id', (req, res) => {
  const idMovie = req.params.id
  connection.query('DELETE FROM movie WHERE id = ?', [idMovie], err => {
    if (err) {
      res.status(500).send("Erreur lors de la supression d'un employé");
    } else {
      res.sendStatus(200);
    }
  });
});

clemderome

const express = require('express');
const connection = require('./conf');

const app = express();
const port = 3000;

app.use(express.json());
app.use(express.urlencoded({
  extended: true
}));

clemderome

const express = require('express');
const connection = require('./conf');

const app = express();
const port = 3000;

app.use(express.json());
app.use(express.urlencoded({
  extended: true
}));