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
|
$requete=mysql_db_query("$sql_bdd","select count(*) from fournisseur order by num_fournisseur ASC",$db_link);
$nb_total=mysql_result($requete,0,"count(*)");
$requete=mysql_db_query("$sql_bdd","select * from fournisseur order by num_fournisseur ASC limit $debut,$limit",$db_link);
$num=mysql_num_rows($requete);
// AFFICHAGE DES RESULTATS
else {
$i=0;
while($i<$num)
{
$idprod=mysql_result($requete,$i,"id_prod");
$ref_prod=mysql_result($requete,$i,"ref_prod");
$num_fournisseur=mysql_result($requete,$i,"num_fournisseur");
$date_commande=mysql_result($requete,$i,"date_commande_prod");
$ref_fournisseur=mysql_result($requete,$i,"ref_fournisseur");
$nom_prod=mysql_result($requete,$i,"nom_prod");
$taille_prod=mysql_result($requete,$i,"taille_prod");
$couleur_prod=mysql_result($requete,$i,"couleur_prod");
$prix_achat_prod=mysql_result($requete,$i,"prix_achat_prod");
$qte=mysql_result($requete,$i,"qte_prod");
$statut_prod=mysql_result($requete,$i,"statut_prod");
$commentaire_prod=mysql_result($requete,$i,"commentaire_prod");
?>
<tr class=Style2 bgcolor=#<? if ($i % 2 == 0) echo "FFFFFF"; else echo "F6F6F6"; ?>>
<td width="50"><input type="checkbox" name="checkbox[]" value="OFF" id="<?echo"$idprod";?>"><? echo"$ref_fournisseur"; ?></td>
<td width="210"><? echo"$nom_prod"; ?></td>
<td width="50"><? echo"$taille_prod"; ?></td>
<td width="50"><? echo"$couleur_prod"; ?></td>
<td width="50"><? echo"$prix_achat_prod"; ?></td>
<td width="50"><? echo"$qte"; ?></td>
<td width="50"><? echo"$date_commande"; ?></td>
<td width="210"><? echo"$commentaire_prod"; ?></td>
</tr>
<? $i++;
}
....
<?echo "Modifier le statut des commandes sélectionnées : ";?>
<select name="select_checkbox">
<option>A commander</option>
<option>Commandé</option>
<option>Livré</option>
<option>Indisponible</option>
</select>
function modifier_statut()
{
$val_select=$_REQUEST['select_checkbox'];
return ;
}
<input type="submit" value="OK" onClick="modifier_statut();">
</form> |
