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
|
<form method="get" action="cahier2.php">
<table width="700" border="0">
<tr class="Style2" bgcolor=#DEDEDE>
<td width="100">Date</td>
<td width="500">Titre</td>
</tr>
<tr>
<?
$db_link = mysql_connect("$sql_serveur","$sql_user","$sql_passwd");
// NOMBRE TOTAL D'ENREGISTREMENTS REPONDANT A LA REQUETE
if($show==""){$show="1";}
if($show==1){$requete=mysql_db_query("$sql_bdd","select count(*) from cahier where statut_tache='A faire' order by date_tache ASC",$db_link);}
if($show==2){$requete=mysql_db_query("$sql_bdd","select count(*) from cahier where statut_tache='En attente' order by date_tache ASC",$db_link);}
if($show==3){$requete=mysql_db_query("$sql_bdd","select count(*) from cahier where statut_tache='Fait' order by date_tache ASC",$db_link);}
$nb_total=mysql_result($requete,0,"count(*)");
if($show==1){$requete=mysql_db_query("$sql_bdd","select * from cahier where statut_tache='A faire' order by date_tache ASC limit $debut,$limit",$db_link);}
if($show==2){$requete=mysql_db_query("$sql_bdd","select * from cahier where statut_tache='En attente' order by date_tache ASC limit $debut,$limit",$db_link);}
if($show==3){$requete=mysql_db_query("$sql_bdd","select * from cahier where statut_tache='Fait' order by date_tache ASC limit $debut,$limit",$db_link);}
$num=mysql_num_rows($requete);
// DEFINITION DU MESSAGE A AFFICHER
if ($num==0) {echo " Aucune tâche trouvée.";}
// AFFICHAGE DES RESULTATS
else
{
echo " <b>$nb_total</b> tâche"; if ($nb_total>1) {echo "s";} echo" trouvée"; if ($nb_total>1) {echo "s";}
echo "</tr>";
$i=0;
while($i<$num)
{
$idtache=mysql_result($requete,$i,"id_tache");
$datetache=mysql_result($requete,$i,"date_tache");
$titretache=mysql_result($requete,$i,"titre_tache");
$textetache=mysql_result($requete,$i,"texte_tache");
$statuttache=mysql_result($requete,$i,"statut_tache");
?>
<tr class=Style2 bgcolor=#<? if ($i % 2 == 0) echo "FFFFFF"; else echo "F6F6F6"; ?>>
<td width="100"><input type="checkbox" name="modi[]" value="<?echo"$idtache";?>"><? echo"$datetache"; ?></td>
<td width="500"><? echo"$titretache"; ?></td>
</tr>
<?
if($show!=3)
{
?>
<tr class=Style2 bgcolor=#<? if ($i % 2 == 0) echo "FFFFFF"; else echo "F6F6F6"; ?>>
<td width="600"><? echo"$textetache"; ?></td>
</tr>
<?
}
$i++;
}
}
?>
</table>
<br />
<br />
<br />
<input type="submit" name="Submit" value="Ajouter une tâche" />
</form> |
Partager