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
| <?php
include("connection_gescompta.php");
$i=0;
//**************************************************************************************************************************************
// Consultation Generale
if (isset($_POST['Valider']))
{
$Choix = $_POST['Choix'];
//echo $Choix;
if ($Choix == 'Generale')
{
echo '<table><tr>
<th> RAM </th>
<th> ID </th>
<th>DATE </th>
<th>PROJETS / TÂCHES</th>
<th>DESCRIPTION</th>
<th>ETAT DAVANCEMENT </th>
<th>RESPONSABLE </th>
<th>ETAT </th>
<th>MODIFIER</th>
<th>SUPPRIMER</th>
</tr>';
try
{
$date1 = $_POST['date1'];
$date2 = $_POST['date2'];
$reponse = $bdd->query("SELECT
a.id_rah,
a.datejour,
a.projets_taches,
a.description,
a.avancement,
a.entite_responsable,
a.etat_tache
FROM
rah a
where datejour between '$date1' and '$date2' order by a.datejour");
while ($donnees = $reponse->fetch())
{
$i++;
echo '<tr>';
echo '
<td><input type="checkbox" name="checkbox[]" id ="checkbox" value ="<?php echo '.$donnees['id_rah'].'?>" /></td>
<td>'. $donnees['id_rah'].'</td>
<td>'. $donnees['datejour'].'</td>
<td>'. $donnees['projets_taches'].'</td>
<td>'. $donnees['description'].'</td>
<td>'. $donnees['avancement'].'</td>
<td>'. $donnees['entite_responsable'].'</td>
<td>'. $donnees['etat_tache'].'</td>';
echo'<td><a href="modifier_rah.php?modifier='.$donnees['id_rah'].'">Modifier</a></td>';
echo'<td><a href="confirmation_sup_rah.php?supprimer='.$donnees['id_rah'].'"><img src="images/supprimer.jpg"></a></td>';
echo '</tr>';
}
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
}
echo '</table>';
echo '</table>';
/******************************************************/
/*********Formulaire de validation des informations après checkbox***/
echo '<form method="POST" action="consultation_rah.php" name="consultation_rah" enctype="multipart/form-data" >';
echo ' <br/> <br/> <br/>';
echo '<fieldset id="consul_ram" style="width:360px;">';
echo ' <legend><strong>OPTIONS</strong></legend> ';
echo '<p>';
echo '<input type="submit" name="generer_ram" id="generer_ram" value="RAM" /> ';
echo ' <input type="submit" name="Annuler" id="Annuler" value="Annuler" /> ';
echo ' </p>';
echo '</fieldset> <br/>';
echo '</form> ';
} |
Partager