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
|
function generer_arborescence($pere = NULL)
{
if ( $pere === NULL ) {
$sql = 'SELECT rubrique_id, rubrique_label '
. 'FROM rubriques '
. 'WHERE rubrique_pere IS NULL' ;
} else {
$sql = 'SELECT rubrique_id, rubrique_label, rubrique_pere '
. 'FROM rubriques '
. 'WHERE rubrique_pere = ' . $pere ;
}
$rs = mysql_query($sql) ;
$buffer = '' ;
while ( $tuple = mysql_fetch_object($rs) ) {
$buffer .= '<rubrique label="' . htmlentities($rs->rubrique_label) . '">'
. generer_arborescence($rs->rubrique_id)
. '</rubrique>' ;
}
return $pere === NULL
? "<?xml version='1.0' ?><menu>$buffer</menu>"
: $buffer ;
}
header('Content-Type: text/xml') ;
echo generer_arborescence( ) ; |
Partager