Créer une arborescence récursive

Voilà le code générer par le script :

Code:

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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
 
			<nav class="navbar navbar-inverse">
				<div class="navbar-header">
					<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#main-menu">
						<span class="sr-only">Toggle navigation</span>
						<span class="icon-bar"></span>
						<span class="icon-bar"></span>
						<span class="icon-bar"></span>
					</button>
					<a class="navbar-brand hidden-md hidden-lg" href="#">Menu</a>
				</div>
 
				<div class="collapse navbar-collapse" id="main-menu" style="margin-bottom: 0px;">
					<ul class="nav navbar-nav">
 
	<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>			<ul class="dropdown-menu">
		<li class="dropdown"><a data-toggle="dropdown" href="#"><b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">000<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li></li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Accessoire<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Manche longue<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			</ul>
		</li>
		</ul>
	</li>
	<li class="dropdown"><a data-toggle="dropdown" href="#">sa55<b class="caret"></b></a>			<ul class="dropdown-menu">
		<li class="dropdown"><a data-toggle="dropdown" href="#">123<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">1<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li></li>
					<li>0000-00-00 00:00:00</li>
				</ul>
			</li>
			</ul>
		</li>
		</ul>
	</li>
	<li class="dropdown"><a data-toggle="dropdown" href="#">Femme<b class="caret"></b></a>			<ul class="dropdown-menu">
		<li class="dropdown"><a data-toggle="dropdown" href="#">Manche courte<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Col droit<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Chaussure<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Fermeture Zip<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>MTN</li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Long<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
					<li>ALP</li>
				</ul>
			</li>
			</ul>
		</li>
 
				</ul>
			</li>
			</ul>
		</li>
		</ul>
	</li>
	<li class="dropdown"><a data-toggle="dropdown" href="#">Homme<b class="caret"></b></a>			<ul class="dropdown-menu">
		<li class="dropdown"><a data-toggle="dropdown" href="#">Manche courte<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Col rond<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			<li class="dropdown"><a data-toggle="dropdown" href="#">Col v<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Manche longue<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Col rond<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Basket<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Lacets<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
					<li>ALP</li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Ville<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Lacets<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>ALP</li>
				</ul>
			</li>
			<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Long<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>000</li>
				</ul>
			</li>
			</ul>
		</li>
		<li class="dropdown"><a data-toggle="dropdown" href="#">Chaussure<b class="caret"></b></a>				<ul class="dropdown-menu">
			<li class="dropdown"><a data-toggle="dropdown" href="#">Sans<b class="caret"></b></a>					<ul class="dropdown-menu">
					<li>MTN</li>
				</ul>
			</li>
			</ul>
		</li>
		</ul>
	</li>
 
				</div>
			</nav>

Voilà le code avec le php :

Code:

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
<?php
	include('config.php5');
	function afficher_menu($tb, $niv)
	{
		if( empty($niv) ) $niv = 0;
		if( $niv==0 ) {
			echo '<ul class="nav navbar-nav">'."\n";
		}
		// Pour chaque élément du tableau...
		foreach($tb as $key => $value)
		{
			// Si l'élément est un tableau, on appelle la fonction pour qu'elle le parcours
			if(is_array($value))
			{
				echo str_repeat("\t",$niv+1).'<li>'.$key."\n";
				echo str_repeat("\t",$niv+2).'<ul>'."\n";
				 afficher_menu( $value, $niv+1 );
				echo str_repeat("\t",$niv+2).'</ul>'."\n";
				echo str_repeat("\t",$niv+1).'</li>'."\n";
			}
			else //Sinon, c'est un élément à afficher, alors on le liste !
			{
				echo str_repeat("\t",$niv+2).'<li>'.$value.'</li>'."\n";
			}
		}
		if( $niv==0 ) {
			echo '</ul>'."\n";
		}
	}
 
	$sql = mysql_query("SELECT DISTINCT * FROM produit p WHERE codeModele = 'Sans' ORDER BY codeModele,codeSousFamille,codeMarque,codeLigne");
	$tb = array();
	// $req = mysql_query('SELECT * FROM Menu WHERE actif="1" ORDER BY ordre_menu');
		// while( $numero = mysql_fetch_array($req))
		// {
			// $nom = $numero['nom'];
			// $ordre = $numero['ordre_menu'];
		while($data = mysql_fetch_array($sql))
		{
			$modele = $data['codeModele'];
			$sf = $data['codeSousFamille'];
			$marque = $data['codeMarque'];
			$ligne = $data['codeLigne'];
			$libelle = $data['libelle'];
 
			if (!isset($tb[$ligne])){
				$tb[$ligne] = array();
			}
 
			if (!isset($tb[$ligne][$modele])){
				$tb[$modele] = array();
			}
 
			if (!isset($tb[$ligne][$modele][$sf])) {
				$tb[$ligne][$modele][$sf] = array();
			}
 
			// if (!isset($tb[$ligne][$modele][$sf][$marque])) {
				// $tb[$ligne][$modele][$sf][$marque] = array();
			// }
				$tb[$ligne][$modele][$sf][$marque] = $marque;
 
		}
		// }
		afficher_menu( $tb, 0 );
 
?>