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
|
while($article = pg_fetch_array($toute_selection,$ID_CPT[$ID_CPT]))
{
$array_selection[$article[$ID_CPT]]['bdd_utilisateur'] = $article['bdd_utilisateur'];
$array_selection[$article[$ID_CPT]]['bdd_date'] = $article['bdd_date'];
$array_selection[$article[$ID_CPT]]['bdd_heure'] = $article['bdd_heure'];
$array_selection[$article[$ID_CPT]]['bdd_appli'] = $article['bdd_appli'];
$array_selection[$article[$ID_CPT]]['bdd_env'] = $article['bdd_env'];
$array_selection[$article[$ID_CPT]]['bdd_serveur'] = $article['bdd_serveur'];
$array_selection[$article[$ID_CPT]]['bdd_adresseip'] = $article['bdd_adresseip'];
$array_selection[$article[$ID_CPT]]['bdd_base'] = $article['bdd_base'];
$array_selection[$article[$ID_CPT]]['bdd_status'] = $article['bdd_status'];
$array_selection[$article[$ID_CPT]]['bdd_rep'] = $article['bdd_rep'];
$array_selection[$article[$ID_CPT]]['bdd_pourcent'] = $article['bdd_pourcent'];
$ID_CPT = $ID_CPT + 1;
echo '<P></P>';
print_r ($ID_CPT);
echo '<br></br>';
echo '<P></P>';
//print_r ($array_selection);
echo '<br></br>';
//$ID_CPT = $ID_CPT + 1;
};
// maintenant que les opérations PHP sont finies, on affiche le résultat
echo '<BR></BR>';
echo '<table height=80% cellpadding=5 cellspacing=5 colspan=2 center=1 >';
echo '<thread>';
echo '<tr><th>Utilisateur</th><th>Date</th><th>Heure</th><th>Environnement</th><th>Application</th><th>Serveur</th><th>Adresse IP</th><th>Base</th><th>Etat de la base</th><th>Répertoire</th><th>% Utilisé</th></tr>';
echo '</thread>';
echo '<tbody>';
foreach($array_selection as $ID_CPT => $a)
{
//echo '<p></p>';
//echo 'bdd_date';
//echo '<p></p>';
//print_r ($bdd_id);
//echo '<p></p>';
//echo 'a';
//echo '<p></p>';
//print_r ($a);
//echo '<p></p>';
echo '<tr width="100" align="center" >';
if ($a['bdd_status'] == "start" )
{
//echo ' <td>'.$a['bdd_nbr'].'</td>';
echo '<td><a href="autrepage.php?user=.$a[bdd_utilisateur_id]">'.htmlspecialchars($a['bdd_utilisateur']).'</a></td>';
//echo ' <td>'.$a['bdd_utilisateur'].'</td>';
echo ' <td>'.substr($a['bdd_date'],8,2).'/'.substr($a['bdd_date'],5,2).'/'.substr($a['bdd_date'],0,4).'</td>';
echo ' <td>'.$a['bdd_heure'].'</td>';
echo ' <td>'.$a['bdd_env'].'</td>';
echo ' <td>'.$a['bdd_appli'].'</td>';
echo ' <td>'.$a['bdd_serveur'].'</td>';
echo ' <td>'.$a['bdd_adresseip'].'</td>';
echo ' <td>'.$a['bdd_base'].'</td>';
echo ' <td> <img src= "ok.bmp" height=15 /></td>';
echo ' <td height=10% >'.$a['bdd_rep'].'</td>';
if ($a['bdd_pourcent'] < "85%" )
{
echo '<td ><font color=#419F2E> '.$a['bdd_pourcent'].'</font></td>';
}
else
{
echo '<td><span style="text-decoration:blink"><font color=#E70739><b>'.$a['bdd_pourcent'].'</BLINK></font></b></span></td>';
}
}
else
{
//echo ' <td><font color=#CCCCCC>'.$a['bdd_nbr'].'</font></td>';
echo ' <td><font color=#CCCCCC>'.$a['bdd_utilisateur'].'</font></td>';
echo ' <td><font color=#CCCCCC>'.substr($a['bdd_date'],8,2).'/'.substr($a['bdd_date'],5,2).'/'.substr($a['bdd_date'],0,4).'</font></td>';
echo ' <td><font color=#CCCCCC>'.$a['bdd_heure'].'</font></td>';
echo ' <td><font color=#CCCCCC>'.$a['bdd_env'].'</font></td>';
echo ' <td><font color=#CCCCCC>'.$a['bdd_appli'].'</font></td>';
echo ' <td><font color=#CCCCCC>'.$a['bdd_serveur'].'</font></td>';
echo ' <td><font color=#CCCCCC>'.$a['bdd_adresseip'].'</font></td>';
echo ' <td><font color=#CCCCCC>'.$a['bdd_base'].'</font></td>';
echo '<td > <img src= "KO.bmp" height=15 /> </td>';
echo '<td height=10% ><font color=#CCCCCC>'.$a['bdd_rep'].'</font></td>';
if ($a['bdd_pourcent'] < "85%" )
{
echo '<td ><font color=#419F2E> '.$a['bdd_pourcent'].'</font></td>';
}
else
{
echo '<td><font color=#E70739>'.$a['bdd_pourcent'].'</td>';
}
}
echo ' </tr>';
};
echo '</tbody>';
echo '</table>'; |
Partager