1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| <?php
// Connexion au serveur MySQL
$server = "localhost";
$login = "root";
$mdp = "";
$db = "Truc";
$link = mysqli_connect($server, $login, $mdp, $db) or die("Error ".mysqli_error($link));
/*
$rq_a="SELECT COUNT(scenario) AS nb_fini, scenario, timestamp FROM partie_enreg WHERE label='fin-partie' AND partie_enreg.course='Truc - Formation et démonstration' GROUP BY scenario HAVING nb_fini > 1";
$rq_b="SELECT COUNT(scenario) AS nb_P, scenario FROM partie_enreg WHERE label='fin-partie' AND intitule='echec' AND partie_enreg.course='Truc - Formation et démonstration' GROUP BY scenario HAVING nb_P> 1";
$rq_c="SELECT COUNT(scenario) AS nb_jouees, scenario FROM partie where joueur IN (SELECT id FROM joueur WHERE course='Truc - Formation et démonstration') GROUP BY scenario HAVING COUNT(scenario) > 1";
$rq="SELECT partie_fini.timestamp, partie_fini.scenario,(partie_fini.nb_fini-partie_perdue.nb_P) AS R, (partie_jouee.nb_jouees-partie_fini.nb_fini) AS I, partie_perdue.nb_P AS P from (".$rq_a.") as partie_fini, (".$rq_b.") as partie_perdue, (SELECT COUNT(scenario) AS nb_jouees, scenario FROM partie where joueur IN (".$rq_c.") as partie_jouee WHERE partie_fini.scenario = partie_jouee.scenario AND partie_fini.scenario=partie_perdue.scenario ORDER BY partie_fini.scenario";
*/
$rq2="SELECT partie_fini.timestamp,partie_fini.scenario,(partie_fini.nb_fini-partie_perdue.nb_P) AS R, (partie_jouee.nb_jouees-partie_fini.nb_fini) AS I, partie_perdue.nb_P AS P
from (SELECT COUNT(scenario) AS nb_fini, scenario, timestamp
FROM partie_enreg WHERE label='fin-partie' AND partie_enreg.course='Truc - Formation et démonstration'
GROUP BY scenario
HAVING nb_fini > 1) as partie_fini,
(SELECT COUNT(scenario) AS nb_P, scenario
FROM partie_enreg WHERE label='fin-partie' AND intitule='echec' AND partie_enreg.course='Truc - Formation et démonstration'
GROUP BY scenario
HAVING nb_P> 1) as partie_perdue,
(SELECT COUNT(scenario) AS nb_jouees, scenario
FROM partie where joueur IN (SELECT id FROM joueur WHERE course='Truc - Formation et démonstration') GROUP BY scenario
HAVING COUNT(scenario) > 1) as partie_jouee
WHERE partie_fini.scenario = partie_jouee.scenario AND partie_fini.scenario=partie_perdue.scenario
ORDER BY partie_fini.scenario
";
//$sql = " SELECT * FROM enregistrement where partie < 800";
//var_dump($rq);
//var_dump(mysqli_query($link, $rq2));
if($res = mysqli_query($link, $rq2)) {
var_dump (mysqli_num_rows($res));
while ($row = mysqli_fetch_array($res)) {
echo "test";
echo '<tr>';
echo' <td class="col-1">'.$row["partie_fini.timestamp"].'</td>
<td class="col-2">'.$row["partie_fini.scenario"].'</td>
<td class="col-3">'.$row["R"].'</td>
<td class="col-4">'.$row["I"].'</td>
<td class="col-5">'.$row["P"].'</td>
</tr>';
}
}
?> |
Partager