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
| <body>
<div id="resultat-global-cont">
<!-- Resultat par team -->
<div id="resultat-main-cont">
<div id="title-result-cont">titre du tableau</div>
<div id="result-main-cont">
<div id="result-title-cont">
<div id="result-title-box1">titre colonne 1</div><div id="result-title-box2">titre colonne 2</div><div id="result-title-box3">titre colonne 3</div>
<div id="result-title-box4">titre colonne 4</div><div id="result-title-box5">titre colonne 5</div>
</div>
<?php
define('DB_SERVER', 'localhost'); // serveur mysql
define('DB_SERVER_USERNAME', 'root'); // nom d'utilisateur
define('DB_SERVER_PASSWORD', ''); // mot de passe
define('DB_DATABASE', 'classement'); // nom de la base
$connect = mysql_connect(DB_SERVER, DB_SERVER_USERNAME,
DB_SERVER_PASSWORD)
or die('Impossible de se connecter : ' . mysql_error());
// sélection de la base de données
mysql_select_db(DB_DATABASE, $connect);
$sql = "SELECT * FROM general";
$req = mysql_query($sql);
while($resultat = mysql_fetch_assoc($req)){
$cpt = 1;
foreach ($resultat as $valeur)
{
echo '<div id="result-line-cont"><div id="box'.$cpt.'-cont">'.$valeur.'</div></div>';
$cpt++;
}
}
?>
<div id="result-line-cont">
<div id="result-box1-cont"></div>
<div id="result-box2-cont"></div>
<div id="result-box3-cont"></div>
<div id="result-box4-cont"></div>
</div>
<div id="result-line-cont">
<div id="result-box1-cont"></div>
<div id="result-box2-cont"></div>
<div id="result-box3-cont"></div>
<div id="result-box4-cont"></div>
</div>
<div id="result-line-cont">
<div id="result-box1-cont"></div>
<div id="result-box2-cont"></div>
<div id="result-box3-cont"></div>
<div id="result-box4-cont"></div>
</div>
<div id="result-line-cont">
<div id="result-box1-cont"></div>
<div id="result-box2-cont"></div>
<div id="result-box3-cont"></div>
<div id="result-box4-cont"></div>
</div>
<div id="result-line-cont">
<div id="result-box1-cont"></div>
<div id="result-box2-cont"></div>
<div id="result-box3-cont"></div>
<div id="result-box4-cont"></div>
</div>
</div>
</div>
</body> |