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
| mysql_select_db($database_Local_PHP2, $Local_PHP2);
$query_objet = "SELECT * FROM objet WHERE id_classe=2 ORDER BY id_classe ASC";
$objet = mysql_query($query_objet, $Local_PHP2) or die(mysql_error());
$row_objet = mysql_fetch_assoc($objet);
$totalRows_objet = mysql_num_rows($objet);
mysql_select_db($database_Local_PHP2, $Local_PHP2);
$query_classe = "SELECT * FROM classe WHERE id_classe =2 ORDER BY classe ASC";
$classe = mysql_query($query_classe, $Local_PHP2) or die(mysql_error());
$row_classe = mysql_fetch_assoc($classe);
$totalRows_classe = mysql_num_rows($classe);
mysql_select_db($database_Local_PHP2, $Local_PHP2);
$query_objet2 = "SELECT * FROM objet WHERE id_classe=3 ORDER BY id_classe ASC";
$objet2 = mysql_query($query_objet2, $Local_PHP2) or die(mysql_error());
$row_objet2 = mysql_fetch_assoc($objet2);
$totalRows_objet2 = mysql_num_rows($objet2);
mysql_select_db($database_Local_PHP2, $Local_PHP2);
$query_classe2 = "SELECT * FROM classe WHERE id_classe =3 ORDER BY classe ASC";
$classe2 = mysql_query($query_classe2, $Local_PHP2) or die(mysql_error());
$row_classe2 = mysql_fetch_assoc($classe2);
$totalRows_classe2 = mysql_num_rows($classe2);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Document sans titre</title>
</head>
<body>
<select name="objet">
<?php
do {
?>
<optgroup label="<?php echo $row_classe['classe']?>">
<?php
} while ($row_classe = mysql_fetch_assoc($classe));
$rows = mysql_num_rows($classe);
if($rows > 0) {
mysql_data_seek($classe, 0);
$row_classe = mysql_fetch_assoc($classe);
}
?>
<?php
do {
?>
<option value="<?php echo $row_objet['id_objet']?>"><?php echo $row_objet['objet']?></option>
<?php
} while ($row_objet = mysql_fetch_assoc($objet));
$rows = mysql_num_rows($objet);
if($rows > 0) {
mysql_data_seek($objet, 0);
$row_objet = mysql_fetch_assoc($objet);
}
?>
</optgroup>
<?php
do {
?>
<optgroup label="<?php echo $row_classe2['classe']?>">
<?php
} while ($row_classe2 = mysql_fetch_assoc($classe2));
$rows = mysql_num_rows($classe2);
if($rows > 0) {
mysql_data_seek($classe2, 0);
$row_classe2 = mysql_fetch_assoc($classe2);
}
?>
<?php
do {
?>
<option value="<?php echo $row_objet2['id_objet']?>"><?php echo $row_objet2['objet']?></option>
<?php
} while ($row_objet2 = mysql_fetch_assoc($objet2));
$rows = mysql_num_rows($objet2);
if($rows > 0) {
mysql_data_seek($objet2, 0);
$row_objet2 = mysql_fetch_assoc($objet2);
}
?>
</optgroup>
</select>
</body>
</html>
<?php
mysql_free_result($objet);
mysql_free_result($classe);
?> |
Sous-catégorie dans formulaire liste avec BDD
Répondre avec citation
j'ai codé à la volée sans vérifier 
Partager