$req_co = $bdd->prepare("SELECT * FROM combat_connexion WHERE id_joueur1 = " . $id . " 

                            OR id_joueur2 = " . $id . " 

                            OR id_joueur3 = " . $id . " 

                            OR id_joueur4 = " . $id . " 

                            OR id_joueur5 = " . $id . " 

                            OR id_joueur6 = " . $id . " ");

                        $req_co->execute();

                        $donnee = $req_co->fetch();



while(!isset($donnee['id_joueur1']) OR !isset($donnee['id_joueur2']) OR !isset($donnee['id_joueur3']) OR !isset($donnee['id_joueur4']) OR !isset($donnee['id_joueur5']) OR !isset($donnee['id_joueur6']))



{

<?php 



define("DEFAULT_HEALTH", 100);



function try_to_start_a_fight() {

   $results = fetch(

       "SELECT level, COUNT(*) AS count, GROUP_CONCAT(id) AS player_ids

       FROM players

       WHERE looking_for_a_fight = 1

       GROUP BY level

       HAVING count = 6;"

   );



   if (empty($results)) {

       return null;

   }

   else {

       $level = $results[0]['level'];

       $player_ids = $results[0]['player_ids'];

       $game_id = create_game($level, $player_ids);

       return $game_id;

   }

}





function create_game($level, $player_ids) {

   $game_id = insert("INSERT INTO games (level) VALUES(?)", $level);

   players_stops_looking_for_a_fight($player_ids);

   foreach ($player_ids as $player_id) {

       insert(

           "INSERT INTO fighters (game_id, player_id, health, max_health)

           VALUES (?, ?, ?, ?)",

           $game_id,

           $player_id,

           DEFAULT_HEALTH,

           DEFAULT_HEALTH

       );

   };



   return $game_id;

}





function player_starts_looking_for_a_fight($player_id) {

   query(

       "UPDATE players

       SET looking_for_a_fight = 1

       WHERE id = ?",

       $player_id

   );



   return $try_to_start_a_fight();

}





function players_stops_looking_for_a_fight($player_ids) {

   query(

       "UPDATE players

       SET looking_for_a_fight = 1

       WHERE id IN (?)",

       join(", ", $player_ids)

   );

}



/*

CREATE TABLE players (

   `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

   name VARCHAR(255) NOT NULL,

   level INT NOT NULL,

   looking_for_a_fight TINYINT NOT NULL

) ENGINE=InnoDB;



CREATE TABLE games (

   `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

   level INT NOT NULL,

) ENGINE=InnoDB;



CREATE TABLE fighters (

   `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

   game_id INT NOT NULL,

   player_id INT NOT NULL,

   health INT NOT NULL,

   max_health INT NOT NULL,

) ENGINE=InnoDB;



INSERT INTO players (id, name, level, looking_for_a_fight) VALUES(NULL, "Corwin", 1, 1);

INSERT INTO players (id, name, level, looking_for_a_fight) VALUES(NULL, "Mandor", 1, 1);

INSERT INTO players (id, name, level, looking_for_a_fight) VALUES(NULL, "Random", 1, 1);

INSERT INTO players (id, name, level, looking_for_a_fight) VALUES(NULL, "Eric", 1, 1);

INSERT INTO players (id, name, level, looking_for_a_fight) VALUES(NULL, "Caine", 1, 1);

INSERT INTO players (id, name, level, looking_for_a_fight) VALUES(NULL, "Benedict", 1, 1);

<?php

$name = "Romain";

$age = 28;

print("Je m'appelle ? et j'ai ? ans.", $name, $age);