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 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119
|
<style type="text/css">
body, html {font-family:Arial, Helvetica, sans-serif;width:100%;margin:0;padding:0;text-align:center;}
h1 {background-color:#600;color:#fff;padding:20px 0;margin:0;}
a {background-color:#600;color:#fff;padding:20px 0;margin:0;}
a img {border:0;}
td {font-size:11px;}
.image {background-color:#eee;border:1px solid #ddd;border-bottom:1px solid #bbb;padding:5px;}
</style>
<?php
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
$sql= "SELECT COUNT(*) AS total FROM combat";
$res = mysql_query('SELECT COUNT(*) AS total FROM combat') OR die(mysql_error());
$row = mysql_fetch_assoc($res);
$nb_id = $row['total'];
mysql_close();
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
$sql= "SELECT COUNT(*) AS total01 FROM photo";
$res = mysql_query('SELECT COUNT(*) AS total01 FROM photo') OR die(mysql_error());
$row = mysql_fetch_assoc($res);
echo $row['total01'];
$nb_id1 = $row['total01'];
mysql_close();
?>
<h1>Classement</h1>
<?php
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
//$sql= "SELECT * FROM combat WHERE ID ORDER BY RAND() LIMIT 2";
$sql= "SELECT * FROM photo ";
//$sql = 'SELECT * FROM photo WHERE ID="$idd"';
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
// on fait une boucle qui va faire un tour pour chaque enregistrement
while($data = mysql_fetch_assoc($req))
{
// on affiche les informations de l'enregistrement en cours
$ID[] = $data['ID'];
$nom[] = $data['nom'];
}
// on ferme la connexion à mysql
mysql_close();
//nb_id1 est le nombre total d'ID de photo
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
//$sql= "SELECT * FROM combat WHERE ID ORDER BY RAND() LIMIT 2";
$sql= "SELECT * FROM combat ";
//$sql = 'SELECT * FROM photo WHERE ID="$idd"';
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
// on fait une boucle qui va faire un tour pour chaque enregistrement
while($data = mysql_fetch_assoc($req))
{
// on affiche les informations de l'enregistrement en cours
$win[] = $data['win_id'];
$loose[] = $data['loose_id'];
}
// on ferme la connexion à mysql
mysql_close();
$tt = $nb_id -1;
$bb = $nb_id1 ;
for ($i = 0; $i <= $tt; $i++) {
}
echo count($win, 1)."<br>";
for ($j = 1; $j <= $bb; $j++) {
$db = mysql_connect('localhost', 'root', '');
mysql_select_db('vote_photo',$db);
$res = mysql_query("SELECT COUNT(*) AS total01 FROM combat WHERE win_id='$j' ") OR die(mysql_error());
$row = mysql_fetch_assoc($res);
echo $row['total01'].' - ' .$j .'<br>';
mysql_close();
}
?>
<br> |
Partager