<?php $host = "localhost"; $user = "root"; $passwd = ""; $database = "test"; // Requête de connexion $link = mysql_connect($host, $user,$passwd); mysql_query("SET NAMES UTF8"); // Vérification de la connexion à la BDD if(!$link){die('Erreur de connexion au serveur');} $select_db = mysql_select_db($database); if(!$select_db){die('Erreur de connexion à la base');} $nbrebatiment=mysql_query("SELECT nom_batiment AS BATIMENT FROM inventaire GROUP BY nom_batiment") or die(mysql_error());$nbre= mysql_num_rows($nbrebatiment); echo ''; echo '---- Matériel | Nbre par Bâtiment | '; $Q = \"SELECT type_ensemble AS TYP FROM inventaire GROUP BY TYP\"; $R = mysql_query($Q)or die(mysql_error()); while($A = mysql_fetch_assoc($R)) { echo '---- '.$A['TYP'].', '; $Q1 = \"SELECT nom_batiment AS BAT FROM inventaire GROUP BY BAT\"; $R1 = mysql_query($Q1)or die(mysql_error()); while($A1 = mysql_fetch_assoc($R1)) { echo ''.$A1['BAT'].', '; } echo '---- '; $Q2 = \"SELECT element AS ELE FROM inventaire GROUP BY ELE\"; $R2 = mysql_query($Q2)or die(mysql_error()); while ($A2 = mysql_fetch_assoc($R2)) { echo ''.$A2['ELE'].', '; $R3 = mysql_query($Q1)or die(mysql_error()); while($A3 = mysql_fetch_assoc($R3)) { $Q4 = \"SELECT SUM(nombre) AS NB FROM inventaire WHERE nom_batiment='\".$A3['BAT'].\"' AND element='\".$A2['ELE'].\"' AND type_ensemble='\".$A['TYP'].\"'\"; $R4 = mysql_query($Q4)or die(mysql_error()); while($A4 = mysql_fetch_assoc($R4)) { if(isset($A4['NB'])) { echo ''.$A4['NB'].', '; } else { echo '0, '; } } } echo ''; } } echo ' '; ?>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionwhile (list($key, $value) = each($arr)) { echo "Clé : $key; Valeur : $value \n"; }
foreach ($arr as $key => $value) { echo "Clé : $key; Valeur : $value \n"; }
mysql_fetch_array
<col style= \"width:70%\"><col style=\"width:30%\"> ---- Matériel | Nbre | <?php include('config.php'); $reqEnsemble =mysql_query(\"SELECT type_ensemble AS ENSEMBLE, COUNT(element) AS NBRE_ELEMENT FROM inventaire GROUP BY ENSEMBLE ORDER BY ENSEMBLE\") or die(mysql_error()); while ($req1 = mysql_fetch_assoc($reqEnsemble)) { echo '---- '; echo ''.htmlentities($req1['ENSEMBLE']).', '; $ensemble = mysql_real_escape_string($req1['ENSEMBLE']); $reqbat=mysql_query(\"SELECT nom_batiment AS BATIMENT FROM inventaire WHERE type_ensemble='\".$ensemble.\"' GROUP BY BATIMENT ORDER BY BATIMENT\") or die(mysql_error()); while($bat= mysql_fetch_assoc($reqbat)) { echo ''.htmlentities($bat['BATIMENT']).', '; } echo ''; $ensemble = mysql_real_escape_string($req1['ENSEMBLE']); $reqElement=mysql_query(\"SELECT type_ensemble AS ENSEMBLE, COUNT(element) AS NBRE_ELEMENT, element AS ELEMENT FROM inventaire WHERE type_ensemble = '$ensemble' GROUP BY ELEMENT ORDER BY ENSEMBLE\"); while ($req2 = mysql_fetch_assoc($reqElement)) { echo '---- '; echo ''.htmlentities($req2['ELEMENT']).', '; echo ''.htmlentities($req2['NBRE_ELEMENT']).', '; echo ''; } } ?>
<?php $host = "localhost"; $user = "root"; $passwd = ""; $database = "test"; // Requête de connexion $link = mysql_connect($host, $user,$passwd); mysql_query("SET NAMES UTF8"); // Vérification de la connexion à la BDD if(!$link){die('Erreur de connexion au serveur');} $select_db = mysql_select_db($database); if(!$select_db){die('Erreur de connexion à la base');} ?> <?php $nbrebatiment=mysql_query(\"SELECT nom_batiment AS BATIMENT FROM inventaire GROUP BY nom_batiment\") or die(mysql_error());$nbre= mysql_num_rows($nbrebatiment); ?> ---- Matériel | " style ="color: RGB(0, 0, 100%); background-color:#8CC6D7;">Nbre par Bâtiment | <?php // Requête 1 : les ensembles $reqEnsemble=mysql_query(\"SELECT type_ensemble AS ENSEMBLE, COUNT(element) AS NBRE_ELEMENT FROM inventaire GROUP BY ENSEMBLE ORDER BY ENSEMBLE\") or die(mysql_error()); // Boucle 1: On détermine chaque ensemble while ($req1 = mysql_fetch_assoc($reqEnsemble)) { echo '---- '; // On affiche le nom du 1er ensemble echo ''.htmlentities($req1['ENSEMBLE']).', '; // La variable $ensemble = nom du l'ensemble de la première requête / Boucle 1 $ensemble = mysql_real_escape_string($req1['ENSEMBLE']); // Requête 2 : On détermine le nom des bâtiments correspondant à l'ensemble de la boucle 1 $reqbat=mysql_query(\"SELECT nom_batiment AS BATIMENT FROM inventaire WHERE type_ensemble='\".$ensemble.\"' GROUP BY BATIMENT ORDER BY BATIMENT\") or die(mysql_error()); // Boucle 2: Affichage des batiments dans l'ensemble while($bat= mysql_fetch_assoc($reqbat)) { echo ''.htmlentities($bat['BATIMENT']).', '; } echo ''; // On re-défini la variable $ensemble $ensemble = mysql_real_escape_string($req1['ENSEMBLE']); // Requête 3 : On détermine les éléments et leurs nombres $reqElement=mysql_query(\"SELECT type_ensemble AS ENSEMBLE, nombre AS NBRE_ELEMENT, element AS ELEMENT FROM inventaire WHERE type_ensemble = '$ensemble' GROUP BY ELEMENT ORDER BY ENSEMBLE\"); // Boucle 3: Affichage de la requête 3 while ($req2 = mysql_fetch_assoc($reqElement)) { echo '---- '; echo ''.htmlentities($req2['ELEMENT']).', '; echo ''.htmlentities($req2['NBRE_ELEMENT']).', '; echo ''; } } ?>
<?php $host = "localhost"; $user = "root"; $passwd = ""; $database = "test"; // Requête de connexion $link = mysql_connect($host, $user,$passwd); mysql_query("SET NAMES UTF8"); // Vérification de la connexion à la BDD if(!$link){die('Erreur de connexion au serveur');} $select_db = mysql_select_db($database); if(!$select_db){die('Erreur de connexion à la base');} ?> <?php $nbrebatiment=mysql_query(\"SELECT nom_batiment AS BATIMENT FROM inventaire GROUP BY nom_batiment\") or die(mysql_error());$nbre= mysql_num_rows($nbrebatiment); ?> ---- Matériel | " style ="color: RGB(0, 0, 100%); background-color:#8CC6D7;">Nbre par Bâtiment | <?php // Requête 1 : les ensembles $reqEnsemble=mysql_query(\"SELECT type_ensemble AS ENSEMBLE FROM inventaire GROUP BY ENSEMBLE ORDER BY ENSEMBLE\") or die(mysql_error()); // Boucle 1: On détermine chaque ensemble while ($req1 = mysql_fetch_assoc($reqEnsemble)) { echo '---- '; // On affiche le nom du 1er ensemble echo ''.htmlentities($req1['ENSEMBLE']).', '; // La variable $ensemble = nom du l'ensemble de la première requête / Boucle 1 $ensemble = mysql_real_escape_string($req1['ENSEMBLE']); // Requête 2 : On détermine le nom des bâtiments correspondant à l'ensemble de la boucle 1 $reqbat=mysql_query(\"SELECT nom_batiment AS BATIMENT FROM inventaire WHERE type_ensemble='\".$ensemble.\"' GROUP BY BATIMENT ORDER BY BATIMENT\") or die(mysql_error()); // Boucle 2: Affichage des batiments dans l'ensemble while($bat= mysql_fetch_assoc($reqbat)) { echo ''.htmlentities($bat['BATIMENT']).', '; } echo ''; // Requête 3 : On détermine les éléments et leurs nombres $reqElement=mysql_query(\"SELECT element AS ELEMENT FROM inventaire WHERE type_ensemble = '$ensemble' GROUP BY ELEMENT ORDER BY ELEMENT\"); // Boucle 3: Affichage de la requête 3 while ($req2 = mysql_fetch_assoc($reqElement)) { $element = mysql_real_escape_string($req2['ELEMENT']); echo '---- '; echo ''.htmlentities($req2['ELEMENT']).', '; $reqNbElement =mysql_query(\"SELECT nombre AS NB FROM inventaire WHERE element='\".$element.\"' GROUP BY nom_batiment\"); while($NbElement = mysql_fetch_assoc($reqNbElement)) { echo ''.$NbElement['NB'].', '; } echo ''; } } ?>