FloLog9

1.  /A\./

2.  /\d{2}\/\d{2}\/\d{4}/

3. /\b\d{1}\/\d{2}/

4. /\w{14}/

5. /([https]{5}[a-z0-9/:.]*)/

FloLog9

-- **** Retourne le nom des équipes et le nombre de joueurs par équipe, le tout classé par nombre de joueurs par équipe, de la plus nombreuse à la moins nombreuse. ****

    SELECT count(*) nb_members, team.name team_name
    FROM player
    JOIN team ON team.id=player.team_id
    GROUP BY team.id
    ORDER BY nb_members DESC;

FloLog9

/* hello-wilder.js */

// Define some variables
const movieTitle = 'Harry Potter';
const release = 2001;
const producer = 'Chris Columbus';
const description = movieTitle + ', réalisé par ' + producer + ' en ' + release + '.';

// Display a popup
alert(description);

FloLog9

-- **** noms, prénoms, rôle et équipe de tous les joueurs, classés dans l’ordre alphabétique par équipe ****

SELECT lastname, firstname, role, name team_name
FROM player
JOIN wizard ON wizard.id=player.wizard_id
JOIN team ON team.id=player.team_id
ORDER BY team.name ASC,
role ASC,
wizard.lastname ASC,
wizard.firstname ASC;

FloLog9

+----+----------------------------------------------+----------+----------------+
| id | name                                         | capacity | country        |
+----+----------------------------------------------+----------+----------------+
|  2 | Castelobruxo                                 |      380 | Brazil         |
|  3 | Durmstrang Institure                         |      570 | Sweden         |
|  4 | Hogwartes School of Witchcraft and Wizardry  |      450 | United Kingdom |
|  5 | Ilvermorny School of Witchcraft and Wizardry |      300 | USA            |
|  6 | Koldovstoretz                                |      125 | Russia         |
+----+----------------------------------------------+----------+----------------+

FloLog9

SELECT * 
FROM wizard 
WHERE is_muggle = 0
AND birthday 
BETWEEN '1975-01-01' 
AND '1985-12-12';

+----+-----------+----------+------------+-------------+---------------------------------------+-----------+
| id | firstname | lastname | birthday   | birth_place | biography                             | is_muggle |
+----+-----------+----------+------------+-------------+---------------------------------------+-----------+

FloLog9

<?php

class Personne{
    public $nom = 'Jacques';
    public $prenom = 'Dupont';
    public $adresse = '3 rue Victor Hugo';
    public $dateDeNaissance = '26/04/1995';

    public function afficherInfo(){
        echo $this->nom . '<br>';

FloLog9

<?php
    if ($_POST)
    {
        $error = array();

        if( empty($_POST['user_name']) )
        {
            $error['name2'] = 'Your name cannot be empty.<br>';
            //echo $error['name2'];
        }

FloLog9

<?php

function writeSecretSentence ( string $parametre1, string $parametre2 ): string
{
    return $parametre1 . " s'incline face à " . $parametre2;
}

echo writeSecretSentence('renard', 'lune');

?>

FloLog9

@font-face {
    font-family: 'PartyBusiness';
    src: url('integration/partybusiness.ttf');
}

@font-face {
    font-family: 'aniron';
    src: url('integration/aniro.ttf');
}