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> |
