Optimiser code PHP

Marsh Posté le 10-10-2009 à 10:07:27

Bonjour,

J'ai crée un code PHP me permettant d'extraire de ma base de données des statistiques... Voici à quoi ressemble actuellement mon code :

Citation :

<table>
<tr>
<td><img class="blank" src="design/dossier/counter-env.jpg" width="145" height="50"></td>
<td><h3>ex : Environnement</h3></td>
</tr>
<tr>
<td><img class="blank" src="design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="design/blank.gif" width="435" height="1"></td>
</tr>
</table>

<table class="tabstats">
<tr>
<td><img class="blank" src="design/blank.gif" height="1"></td>
<td><img class="blank" src="design/blank.gif" height="1"></td> <td><img class="blank" src="design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="design/absstat.jpg"></td>
<td><a href="emissions-dioxyde-carbone/"><img class="barmap" src="design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT emdiox FROM bddpays WHERE pays='France'",
mysql_real_escape_string($emdiox));

$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Emissions de dioxyde de carbone industrielle (milliers de tonnes) : ".$row['emdiox']."</li></ul>";
}
?>
</td>
<td class="right">2000</td>
</tr>
<tr>
<td><img class="blank" src="design/absstat.jpg"></td>
<td><a href="nombre-reserves-biosphere/"><img class="barmap" src="design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT reservbio FROM bddpays WHERE pays='France'",
mysql_real_escape_string($reservbio));

$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de réserves de biosphère (unités) : ".$row['reservbio']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="design/absstat.jpg"></td>
<td><a href="/taux-deforestation/"><img class="barmap" src="design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT txdefores FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txdefores));

$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de déforestation (%) : ".$row['txdefores']."</li></ul>";
}
?>
</td>
<td class="right">2000</td>
</tr>
</table>
<p><img class="blank" src="design/dossier/counter-popmond.jpg" width="1" height="45"></p>

<table>
<tr>
<td><img class="blank" src="design/dossier/counter-geo.jpg" width="145" height="50"></td>
<td><h3>ex2 Géographie</h3></td>
</tr>
<tr>
<td><img class="blank" src="design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="design/blank.gif" width="435" height="1"></td>
</tr>
</table>

<table class="tabstats">
<tr>
<td><img class="blank" src="design/blank.gif" height="1"></td>
<td><img class="blank" src="design/blank.gif" height="1"></td> <td><img class="blank" src="design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="design/absstat.jpg"></td>
<td><a href="/longueur-littoral/"><img class="barmap" src="design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT lglit FROM bddpays WHERE pays='France'",
mysql_real_escape_string($lglit));

$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Longueur du littoral (km) : ".$row['lglit']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="design/absstat.jpg"></td>
<td><a href="/superficie-totale/"><img class="barmap" src="design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT suptot FROM bddpays WHERE pays='France'",
mysql_real_escape_string($suptot));

$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Superficie totale (km²) : ".$row['suptot']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
</table>

<p><img class="blank" src="design/dossier/counter-popmond.jpg" width="1" height="45"><img class="blank" src="design/dossier/counter-popmond.jpg" width="1" height="45"></p>

Comme vous pouvez le remarquer, je n'ai réussi qu'à faire des répétitions avec toutes les demandes de connection à la base et j'ai peur qu'avec ça mon hébergeur ne réagisse pas bien ! Croyez vous qu'il existe un moyen de ratraicir ce code ? Je pensais peut être à mieux méler les tableau dans le PHP mais n'étant pas experte avec ce langage, vous comprendrez la raison de ce post.

Merci beaucoup à ceux et/ou celles qui pourraient m'aider
A bientôt

Marsh Posté le 10-10-2009 à 10:07:27

Marsh Posté le 10-10-2009 à 11:28:45

Euh déjà simple question : tu fais une liste ul par item ?

parce que là, t'as 15 items, t'as 15 listes à chaque fois ... (et non une liste des 15 items ...)

Après, les puristes ici te diront que mélanger l'exécution de requêtes et l'affichage HTML saimal

Point de vue des boucles : je ne vois pas trop ce que tu peux améliorer, il faudra de toutes façons à un moment où à un autre faire les boucles pour afficher les items.

Ce que tu peux faire cependant, c'est préparer tes requêtes et tes dataset en amont du code, pour n'avoir au final que de l'affichage dans cette page (et non exécution + affichage).

càd

Code :

<?php
// récupération des émissions
$query = sprintf("SELECT emdiox FROM bddpays WHERE pays='France'", mysql_real_escape_string($emdiox));
$emissions = mysql_query($query);
// récupération des réserves
$query = sprintf("SELECT reservbio FROM bddpays WHERE pays='France'", mysql_real_escape_string($reservbio));
$reserves = mysql_query($query);
// récupération des taux de déforestation
$query = sprintf("SELECT txdefores FROM bddpays WHERE pays='France'", mysql_real_escape_string($txdefores));
$taux_def = mysql_query($query);
// récupération des longeurus des littoraux
$query = sprintf("SELECT lglit FROM bddpays WHERE pays='France'", mysql_real_escape_string($lglit));
$longueurs = mysql_query($query);
// récupération superficie totale
$query = sprintf("SELECT suptot FROM bddpays WHERE pays='France'",
mysql_real_escape_string($suptot));
$superficie_totale = mysql_query($query);
// et maintenant on affiche
?>
<table>
<tr>
<td><img class="blank" src="design/dossier/counter-env.jpg" width="145" height="50"></td>
<td><h3>ex : Environnement</h3></td>
</tr>
<tr>
<td><img class="blank" src="design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="design/blank.gif" height="1"></td>
<td><img class="blank" src="design/blank.gif" height="1"></td> <td><img class="blank" src="design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="design/absstat.jpg"></td>
<td><a href="emissions-dioxyde-carbone/"><img class="barmap" src="design/graph.jpg"></a></td>
<td>
<ul>
<?php
while ($row = mysql_fetch_assoc($emissions)) {
echo "<li>Emissions de dioxyde de carbone industrielle (milliers de tonnes) : ".$row['emdiox']."</ul>";
}
?>
</ul>
</td>
<td class="right">2000</td>
[...]

Je n'ai mis qu'un exemple ici. Et j'ai mis tous les items dans une seule liste.
Mais bon, là encore on ne connait pas le reste du code, si ça se trouve ya p-ê moyen de mettre les requêtes SQL ailleurs et de faire des belles fonctions GetEmissions() par exemple ...

---------------
NewsletTux - outil de mailing list en PHP MySQL

Marsh Posté le 10-10-2009 à 13:54:32

Effectivement, je fais bien une liste <ul> par item, je n'ai pas trouvé d'autre moyen pour que les images, le texte, le résultat de la requête et la date soit exactement alignés (alors j'ai bidouillé le tableau html et le css pour que le contenu soit aligné horizontalement à mon résultat).

Merci pour cette nouvelle version de code, il reste cependant assez conséquent... Puisse que je n'affiche qu'un seul "pays" par page, n'y-a-t-il pas de moyens de "concaténer" le tout ?

Du genre

Code :

// récupération de toutes les stats dun pays
$query = sprintf("SELECT reservbio, emissdiox, lglitt FROM bddpays WHERE pays='France'", mysql_real_escape_string($reservbio, emissdiox, lglitt));
$toutes_les_stats= mysql_query($query);

Marsh Posté le 10-10-2009 à 16:11:48

Ne connaissant pas la structure de ta table, et n'ayant pas plus d'aperçu, je ne peux pas dire "oui" avec certitude.

Rapatrier plusieurs champs dans une requête est tout à fait faisable, et c'est même mieux de prendre 3 champs plutôt que de faire 3 requêtes, mais ne sachant pas vraiment ce que tu vas afficher après ...

Je n'avais pas fait attention, dans tes requêtes, qu'elles allaient toutes prélever des données dans la même table (shame on me). Mais si on considère que pour 1 pays (France) tu rapatries 3 données pour remplir 3 cellules de tableau, c'est même bien mieux, en effet.

et tu n'as plus qu'à faire un while($rox = mysql_fetch_array($toutes_les_stats))
{
... ici tu affiches les colonnes prévues
}

Attention cependant à ne pas mélanger tableau et mise en forme ...

---------------
NewsletTux - outil de mailing list en PHP MySQL

Marsh Posté le 10-10-2009 à 18:57:38

Je ne comprends pas ceci:

Code :

($rox = mysql_fetch_array($toutes_les_stats))
{
... ici tu affiches les colonnes prévues
}

Sinon pour tout expliquer ma base est en fait une simple feuille excel avec en colonne les stats (txdef, emissdiox...) et en ligne les pays (france, us, portugal...). Dans ma méthode je demande de chercher txdef de pays france, puis je recommence ainsi de suite emissdiox de pays france... La raison de mon post était de simplifier le code des pages qui afficheront les résultats de toutes ces requêtes car je la trouvais un peu lourde comme le montre ceci : (!)

Code :

<table class="tabstats">
<tr>
<td><img class="blank" src="/design/dossier/counter-ali.jpg" width="145" height="50"></td>
<td><h3>Agriculture</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td> <td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/agriculture/aide-alimentaire/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT aidealim FROM bddpays WHERE pays='France'",
mysql_real_escape_string($aidealim));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Aide alimentaire (non céréalière) (tonnes) : ".$row['aidealim']." </li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/agriculture/consommation-engrais/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT consoeng FROM bddpays WHERE pays='France'",
mysql_real_escape_string($consoeng));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Consommation d'engrais (totale, par an) (tonnes) : ".$row['consoeng']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/agriculture/indice-production-agricole/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT indprodag FROM bddpays WHERE pays='France'",
mysql_real_escape_string($indprodag));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Indice de la production agricole (1989-91 = 100) : ".$row['indprodag']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/production-agricole/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT prodag FROM bddpays WHERE pays='France'",
mysql_real_escape_string($prodag));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Production agricole : indice de variation (1989-91 = 100) : ".$row['prodag']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT cultperm FROM bddpays WHERE pays='France'",
mysql_real_escape_string($cultperm));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Superficie des cultures permanentes (%) : ".$row['cultperm']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/agriculture/superficie-terres-cultivables/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT tercult FROM bddpays WHERE pays='France'",
mysql_real_escape_string($tercult));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Superficie des terres cultivables (%) : ".$row['tercult']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-commer.jpg" width="145" height="50"></td>
<td><h3>Commerce</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td> <td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/commerce/balance-commerciale/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT balcom FROM bddpays WHERE pays='France'",
mysql_real_escape_string($balcom));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Balance commerciale (% des importations) : ".$row['balcom']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT expelec FROM bddpays WHERE pays='France'",
mysql_real_escape_string($expelec));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Exportations d'électricité (milliards de kilowattheures) : ".$row['expelec']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT expgaz FROM bddpays WHERE pays='France'",
mysql_real_escape_string($expgaz));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Exportations de gaz naturel (milliards de m³) : ".$row['expgaz']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/economie/exportations-petrole/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT exppet FROM bddpays WHERE pays='France'",
mysql_real_escape_string($exppet));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Exportations de pétrole (milliers de barils par an) : ".$row['exppet']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT impelec FROM bddpays WHERE pays='France'",
mysql_real_escape_string($impelec));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Importations d'électricité (milliards de kilowattheures) : ".$row['impelec']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT impgaz FROM bddpays WHERE pays='France'",
mysql_real_escape_string($impgaz));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Importations de gaz naturel (milliards de m³) : ".$row['impgaz']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/economie/importations-petrole/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT imppet FROM bddpays WHERE pays='France'",
mysql_real_escape_string($imppet));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Importations de pétrole (milliers de barils par an) : ".$row['imppet']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/commerce/valeur-importations/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT valimp FROM bddpays WHERE pays='France'",
mysql_real_escape_string($valimp));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Valeur des exportations (en millions de dollars) : ".$row['valimp']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/commerce/valeur-exportations/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT valexp FROM bddpays WHERE pays='France'",
mysql_real_escape_string($valexp));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Valeur des importations (en millions de dollars) : ".$row['valexp']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-commun.jpg" width="145" height="50"></td>
<td><h3>Communications</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/communications/nombre-portables-mobiles/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT nbmobiles FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nbmobiles));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de mobiles (‰) : ".$row['nbmobiles']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/communications/nombre-ordinateurs/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT nbordi FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nbordi));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre d'ordinateurs (‰) : ".$row['nbordi']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT nbquot FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nbquot));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de quotidiens (unités) : ".$row['nbquot']."</li></ul>";
}
?>
</td>
<td class="right">1996</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/communications/nombre-serveurs-internet/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT nbserv FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nbserv));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de serveurs Internet (pour 10.000 habitants) : ".$row['nbserv']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/communications/nombre-telephones/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT nbphone FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nbphone));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de téléphones (‰) : ".$row['nbphone']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/communications/nombre-televiseurs/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT nbtv FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nbtv));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de télévisions (‰) : ".$row['nbtv']."</li></ul>";
}
?>
</td>
<td class="right">2000</td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-poleco.jpg" width="145" height="50"></td>
<td><h3>Economie</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td> <td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT capcentral FROM bddpays WHERE pays='France'",
mysql_real_escape_string($capcentral));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Capacité des centrales nucléaires (mégawatts) : ".$row['capcentral']."</li></ul>";
}
?>
</td>
<td class="right">2006</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/economie/depenses-publiques/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT deppub FROM bddpays WHERE pays='France'",
mysql_real_escape_string($deppub));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Dépenses publiques (millions de dollars) : ".$row['deppub']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT depdef FROM bddpays WHERE pays='France'",
mysql_real_escape_string($depdef));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Dépenses publiques consacrées à la défense, raportées au PIB (%) : ".$row['depdef']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT deped FROM bddpays WHERE pays='France'",
mysql_real_escape_string($deped));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Dépenses publiques consacrées à l'éducation, raportées au PIB (%) : ".$row['deped']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT deprech FROM bddpays WHERE pays='France'",
mysql_real_escape_string($deprech));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Dépenses publiques consacrées à la recherche, raportées au PIB (%) : ".$row['deprech']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT depsant FROM bddpays WHERE pays='France'",
mysql_real_escape_string($depsant));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Dépenses publiques consacrées à la santé, raportées au PIB (%) : ".$row['depsant']."</li></ul>";
}
?>
</td>
<td class="right">2001</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT effarmee FROM bddpays WHERE pays='France'",
mysql_real_escape_string($effarmee));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Effectifs de l'armée (milliers) : ".$row['effarmee']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT nbcentral FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nbcentral));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de centrales nucléaires (unités) : ".$row['nbcentral']."</li></ul>";
}
?>
</td>
<td class="right">2006</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/economie/nombre-touristes/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT nbtourist FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nbtourist));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de touristes (milliers) : ".$row['nbtourist']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT pib FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pib));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Produit Intérieur Brut (PIB) (en millions de dollars) : ".$row['pib']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/pib-habitant/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT pibhab FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pibhab));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>PIB par habitant (dollars) : ".$row['pibhab']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT pibag FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pibag));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part de l'agriculture dans le PIB (%) : ".$row['pibag']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT pibind FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pibind));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part du secteur de l'industrie dans le PIB (%) : ".$row['pibind']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT pibserv FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pibserv));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part du secteur des services dans le PIB (%) : ".$row['pibserv']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT pnb FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pnb));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Produit National Brut (PNB) (en millions de dollars) : ".$row['pnb']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/economie/pnb-habitant/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT pnbhab FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pnbhab));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>PNB par habitant (dollars) : ".$row['pnbhab']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT partexport FROM bddpays WHERE pays='France'",
mysql_real_escape_string($partexport));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Principaux partenaires à l'exportation : ".$row['partexport']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT partimport FROM bddpays WHERE pays='France'",
mysql_real_escape_string($partimport));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Principaux partenaires à l'exportation : ".$row['partimport']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT export FROM bddpays WHERE pays='France'",
mysql_real_escape_string($export));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Produits exportés : ".$row['export']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT import FROM bddpays WHERE pays='France'",
mysql_real_escape_string($import));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Produits importés : ".$row['import']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT indserv FROM bddpays WHERE pays='France'",
mysql_real_escape_string($indserv));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Industries et services : ".$row['indserv']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT ag FROM bddpays WHERE pays='France'",
mysql_real_escape_string($ag));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Agriculture : ".$row['ag']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT ressnat FROM bddpays WHERE pays='France'",
mysql_real_escape_string($ressnat));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Ressources naturelles : ".$row['ressnat']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/economie/recettes-publiques/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT recpub FROM bddpays WHERE pays='France'",
mysql_real_escape_string($recpub));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Recettes publiques (en millions de dollars) : ".$row['recpub']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/economie/solde-budgetaire/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT soldbudg FROM bddpays WHERE pays='France'",
mysql_real_escape_string($soldbudg));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Solde budgétaire (% du PIB) : ".$row['soldbudg']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/taux-chomage/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT txchom FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txchom));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de chômage (%) : ".$row['txchom']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/economie/taux-croissance-pib/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT txcroisspib FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txcroisspib));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de croissance du PIB (%) : ".$row['txcroisspib']."</li></ul>";
}
?>
</td>
<td class="right"> 2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT unitmon FROM bddpays WHERE pays='France'",
mysql_real_escape_string($unitmon));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Unité monétaire : ".$row['unitmon']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-edu.jpg" width="145" height="50"></td>
<td><h3>Education</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td> <td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/education/duree-scolarite-obligatoire/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT durscolobli FROM bddpays WHERE pays='France'",
mysql_real_escape_string($durscolobli));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Durée de la scolarité obligatoire (années) : ".$row['durscolobli']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/education/esperance-vie-scolaire/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT espviescol FROM bddpays WHERE pays='France'",
mysql_real_escape_string($espviescol));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Espérance de vie scolaire (années) : ".$row['espviescol']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/taux-alphabetisation/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT txalpha FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txalpha));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux d'alphabétisation (%) : ".$row['txalpha']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT txalphahom FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txalphahom));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux d'alphabétisation des hommes (%) : ".$row['txalphahom']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT txalphafem FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txalphafem));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux d'alphabétisation des femmes (%) : ".$row['txalphafem']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-env.jpg" width="145" height="50"></td>
<td><h3>Environnement</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td> <td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/environnement/emissions-dioxyde-carbone/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT emdiox FROM bddpays WHERE pays='France'",
mysql_real_escape_string($emdiox));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Emissions de dioxyde de carbone industrielle (milliers de tonnes) : ".$row['emdiox']."</li></ul>";
}
?>
</td>
<td class="right">2000</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/environnement/nombre-reserves-biosphere/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT reservbio FROM bddpays WHERE pays='France'",
mysql_real_escape_string($reservbio));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de réserves de biosphère (unités) : ".$row['reservbio']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/taux-deforestation/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT txdefores FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txdefores));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de déforestation (%) : ".$row['txdefores']."</li></ul>";
}
?>
</td>
<td class="right">2000</td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-geo.jpg" width="145" height="50"></td>
<td><h3>Géographie</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td> <td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/geographie/longueur-littoral/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT lglit FROM bddpays WHERE pays='France'",
mysql_real_escape_string($lglit));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Longueur du littoral (km) : ".$row['lglit']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/superficie-totale/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT suptot FROM bddpays WHERE pays='France'",
mysql_real_escape_string($suptot));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Superficie totale (km²) : ".$row['suptot']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-pol.jpg" width="145" height="50"></td>
<td>
<h3>Politique</h3>
</td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT regpol FROM bddpays WHERE pays='France'",
mysql_real_escape_string($regpol));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Régime politique : ".$row['regpol']."</li></ul>";
}
?>
</td>
<td> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT const FROM bddpays WHERE pays='France'",
mysql_real_escape_string($const));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Constitution en vigueur : ".$row['const']."</li></ul>";
}
?>
</td>
<td> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT indep FROM bddpays WHERE pays='France'",
mysql_real_escape_string($indep));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Indépendance : ".$row['indep']."</li></ul>";
}
?>
</td>
<td> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT droitvote FROM bddpays WHERE pays='France'",
mysql_real_escape_string($droitvote));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Droit de vote : ".$row['droitvote']."</li></ul>";
}
?>
</td>
<td> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT code FROM bddpays WHERE pays='France'",
mysql_real_escape_string($code));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Code ISO : ".$row['code']."</li></ul>";
}
?>
</td>
<td> </td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-popmond.jpg" width="145" height="50"></td>
<td><h3>Population</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT nomoff FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nomoff));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nom officiel : ".$row['nomoff']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT capitale FROM bddpays WHERE pays='France'",
mysql_real_escape_string($capitale));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Capitale : ".$row['capitale']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/age-moyen/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT agemoy FROM bddpays WHERE pays='France'",
mysql_real_escape_string($agemoy));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Age moyen (unités) : ".$row['agemoy']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/balance-migratoire/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT balmig FROM bddpays WHERE pays='France'",
mysql_real_escape_string($balmig));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Balance migratoire (migrants pour 1000 habitants) : ".$row['balmig']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/densite-population/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT denspop FROM bddpays WHERE pays='France'",
mysql_real_escape_string($denspop));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Densité de la population (habitants pour km²) : ".$row['denspop']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/esperance-vie/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT espvie FROM bddpays WHERE pays='France'",
mysql_real_escape_string($espvie));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Espérance de vie (moyenne) (années) : ".$row['espvie']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT espviehom FROM bddpays WHERE pays='France'",
mysql_real_escape_string($espviehom));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Espérance de vie des hommes (années) : ".$row['espviehom']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT espviefem FROM bddpays WHERE pays='France'",
mysql_real_escape_string($espviefem));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Espérance de vie des femmes (années) : ".$row['espviefem']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/idh/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT idh FROM bddpays WHERE pays='France'",
mysql_real_escape_string($idh));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Indice de Développement Humain (IDH) (unités) : ".$row['idh']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/indice-pauvrete-humaine/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT iph FROM bddpays WHERE pays='France'",
mysql_real_escape_string($iph));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Indice de Pauvreté Humaine (IPH) (unités) : ".$row['iph']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT isdh FROM bddpays WHERE pays='France'",
mysql_real_escape_string($isdh));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Indice Sexospécifique de Développement Humain (ISDH) (unités) : ".$row['isdh']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT lang FROM bddpays WHERE pays='France'",
mysql_real_escape_string($lang));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Langue(s) officielle(s) : ".$row['lang']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/population/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT pop FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pop));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Population : ".$row['pop']."</li></ul>";
}
?>
</td>
<td class="right">2008</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/population-2025/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT pop2025 FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pop2025));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Population (projection démographique 2025) (unités) : ".$row['pop2025']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/population-2050/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT pop2050 FROM bddpays WHERE pays='France'",
mysql_real_escape_string($pop2050));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Population (projection démographique 2050) (unités) : ".$row['pop2050']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/economie/population-active/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT popact FROM bddpays WHERE pays='France'",
mysql_real_escape_string($popact));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Population active (unités) : ".$row['popact']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/part-population-rurale/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT poprur FROM bddpays WHERE pays='France'",
mysql_real_escape_string($poprur));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part de la population rurale (%) : ".$row['poprur']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/part-population-urbaine/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT popurb FROM bddpays WHERE pays='France'",
mysql_real_escape_string($popurb));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part de la population urbaine (%) : ".$row['popurb']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT undollar FROM bddpays WHERE pays='France'",
mysql_real_escape_string($undollar));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part de la population vivant avec moins d'un dollar par jour (%) : ".$row['undollar']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT seuilpauv FROM bddpays WHERE pays='France'",
mysql_real_escape_string($seuilpauv));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part de la population vivant en dessous du seuil de pauvreté (%) : ".$row['seuilpauv']."</li></ul>";
}
?>
</td>
<td class="right">1998</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT relig FROM bddpays WHERE pays='France'",
mysql_real_escape_string($relig));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Religion(s) principale(s) : ".$row['relig']."</li></ul>";
}
?>
</td>
<td class="right"> </td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT tpsdouble FROM bddpays WHERE pays='France'",
mysql_real_escape_string($tpsdouble));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Temps de doublement de la population (années) : ".$row['tpsdouble']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/taux-croissance-population/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT txcroisspop FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txcroisspop));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de croissance de la population (%) : ".$row['txcroisspop']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/taux-fecondite/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT txfecon FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txfecon));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de fécondité (nombre) : ".$row['txfecon']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT txmascu FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txmascu));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de masculanité (nombre d'hommes pour 100 femmes) : ".$row['txmascu']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/taux-mortalite/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT txmort FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txmort));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de mortalité (‰) : ".$row['txmort']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/indicateurs-de-base/taux-mortalite-infantile/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT mortinf FROM bddpays WHERE pays='France'",
mysql_real_escape_string($mortinf));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de mortalité infantine (‰) : ".$row['mortinf']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/taux-natalite/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT txnata FROM bddpays WHERE pays='France'",
mysql_real_escape_string($txnata));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Taux de natalité (‰) : ".$row['txnata']."</li></ul>";
}
?>
</td>
<td class="right">2007</td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-san.jpg" width="145" height="50"></td>
<td><h3>Santé</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td> <td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT eaupot FROM bddpays WHERE pays='France'",
mysql_real_escape_string($eaupot));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part de la population ayant accès à l'eau potable (%) : ".$row['eaupot']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td>
<?php
$query = sprintf("SELECT sanit FROM bddpays WHERE pays='France'",
mysql_real_escape_string($sanit));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part de la population ayant accès aux installations sanitaires (%) : ".$row['sanit']."</li></ul>";
}
?>
</td>
<td class="right">2004</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/sante/apport-calorique/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT appcalo FROM bddpays WHERE pays='France'",
mysql_real_escape_string($appcalo));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Apport calorique (en moyenne, par jour et par personne) (calories par jour) : ".$row['appcalo']."</li></ul>";
}
?>
</td>
<td class="right">1996</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/sante/apport-proteines/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT appprot FROM bddpays WHERE pays='France'",
mysql_real_escape_string($appprot));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Apport en protéines (par jour et par personne) (grammes par jour) : ".$row['appprot']."</li></ul>";
}
?>
</td>
<td class="right">1992</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/sante/nombre-malades-sida/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT malasida FROM bddpays WHERE pays='France'",
mysql_real_escape_string($malasida));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de malades (recensés) du sida (unités) : ".$row['malasida']."</li></ul>";
}
?>
</td>
<td class="right">2003</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/population/population-sous-alimentee/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT popssalim FROM bddpays WHERE pays='France'",
mysql_real_escape_string($popssalim));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Part de la population sous-alimentée (%) : ".$row['popssalim']."</li></ul>";
}
?>
</td>
<td class="right">1997</td>
</tr>
</table>
<p><img class="blank" src="/design/dossier/counter-popmond.jpg" width="1" height="45"></p>
<table>
<tr>
<td><img class="blank" src="/design/dossier/counter-tra.jpg" width="145" height="50"></td>
<td><h3>Transports</h3></td>
</tr>
<tr>
<td><img class="blank" src="/design/blank.gif" width="145" height="1"></td>
<td><img class="blank" src="/design/blank.gif" width="435" height="1"></td>
</tr>
</table>
<table class="tabstats">
<tr>
<td><img class="blank" src="/design/blank.gif" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1"></td> <td><img class="blank" src="/design/blank.gif" width="492" height="1"></td>
<td><img class="blank" src="/design/blank.gif" height="1" width="40"></td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/transports/longueur-reseau-ferroviaire/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT resferro FROM bddpays WHERE pays='France'",
mysql_real_escape_string($resferro));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Longueur du réseau ferroviaire (km) : ".$row['resferro']."</li></ul>";
}
?>
</td>
<td class="right">2005</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/transports/longueur-reseau-routier/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT resrout FROM bddpays WHERE pays='France'",
mysql_real_escape_string($resrout));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Longueur du réseau routier (km) : ".$row['resrout']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
<tr>
<td><img class="blank" src="/design/absstat.jpg"></td>
<td><a href="/statistiques-mondiales/transports/nombre-voitures-particulieres/"><img class="barmap" src="/design/graph.jpg"></a></td>
<td>
<?php
$query = sprintf("SELECT nbvoiture FROM bddpays WHERE pays='France'",
mysql_real_escape_string($nbvoiture));
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result)) {
echo "<ul><li>Nombre de voitures (‰) : ".$row['nbvoiture']."</li></ul>";
}
?>
</td>
<td class="right">2002</td>
</tr>
</table>

Marsh Posté le 11-10-2009 à 09:53:39

Ouais, relecture faire, je ne vois pas l'intérêt non plus de tes mysql_real_escape vu qu'il n'y a aucun %s dans tes sprintf ...
En clair : tu échappes une variable (dans le but de l'insérer dans la requête SQL) mais jamais tu ne l'insères ...

Bon puis faudrait mettre en ligne un exemple, là moi avec tous ces td (et surtout des horribles spacers) j'ai du mal à imaginer.

mais typiquement, tu peux faire qqch comme ceci :

Code :

<?php
// ta requête avec les 3 champs
$query = sprintf("SELECT reservbio, emissdiox, lglitt FROM bddpays WHERE pays='France'" );
$statistiques = mysql_query($query);
?>
<table>
<thead>
<tr>
<th>Pays</th>
<th>Réserve bio</th>
<th>Emissisdiox</th>
<th>lg littoral</th>
</tr>
</thead>
<tbody>
<?php
while($stat = mysql_fetch_array($statistiques))
{
echo ' <tr>
<td>'.$stat['pays'].'</td>
<td>'.$stat['reservbio'].'</td>
<td>'.$stat['emissdiox'].'</td>
<td>'.$stat['lglitt'].'</td>
</tr>';
}
?>
</tbody>
</table>

Et avec les ajustements qu'il faut ... Mais encore, sans exemple "en ligne" difficile de voir.

---------------
NewsletTux - outil de mailing list en PHP MySQL

Marsh Posté le 11-10-2009 à 11:53:58

Merci beaucoup pour ceci, je vais me pencher la dessus pour voir ce que ça donne mais ca m'a l'air déjà bien plus clean...

Si vous souhaitez voir un exemple, cliquez http://www.geopopulation.com/test/

A noter que les "cases" de ma base de données sont au format "text" et pas en "nombre" dans le but d'afficher ceci 1.000.000 au lieu de cela 1000000

Marsh Posté le 11-10-2009 à 21:43:38

ouais, enfin ça tu peux le faire avec la fonction number_format( de PHP.

---------------
NewsletTux - outil de mailing list en PHP MySQL

Marsh Posté le 12-10-2009 à 08:38:43

au passage, ton utilisation de sprintf est farfelue...tu n'as aucune variable dans le 1er argument, et pourtant tu passes systématiquement en deuxième argument mysql_real_escape_string d'une variable qui n'existe pas... [:autobot]

http://fr2.php.net/manual/en/function.sprintf.php

[edit]

Ah ben je suis en retard là [:joce]

Message édité par skeye le 12-10-2009 à 08:39:06

---------------
Can't buy what I want because it's free -

Marsh Posté le 12-10-2009 à 19:00:28

Le premier code était vraiment horrible en effet ! Merci pour vos lumières...

Une petite question encore, j'en profite comme je suis ici et ce code est ma toute première utilisation de PHP, ou est ce que je dois insérer number_format( si je veux que mes résutats de requêtes s'affichent sous la forme 1.000.000 (séparateur de milliers : point) ?

Marsh Posté le 12-10-2009 à 19:00:28

Marsh Posté le 12-10-2009 à 19:58:29

$nombre_format_francais = number_format($number, 2, ',', '.');

---------------
NewsletTux - outil de mailing list en PHP MySQL

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed

Name *

Email *

URL

Message *