Posted By

antpaw on 02/10/09

Tagged

Versions (?)

Last Edited at 02/10/09 12:54pm

Statistics

Viewed 793 times

Favorited by 1 user(s)

Related snippets

recursion function for xml

/ Published in: PHP

your database needs id, bezeichner and parent fields

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
error_reporting(E_ALL);
 
mysql_connect("localhost","root","root") or die (mysql_error());
mysql_select_db("oop") or die (mysql_error());
 
function xmlloop($intParent=0, $intEbene=0){
	$space = null;
 
	$sql = mysql_query("SELECT * FROM xmltest WHERE parent = ".$intParent);
 
	while($query = mysql_fetch_assoc($sql)){		
 
		for ($i=0;$i<$intEbene;$i++) $space .= '	';
 
		echo $space.'<'.$query["bezeichnung"].' de="'.$query["val"].'">'."\n";
 
		$child = mysql_fetch_assoc(mysql_query("SELECT COUNT(id) as anzahl FROM xmltest WHERE parent = ".$query["id"]." GROUP BY id"));
 
		if($child["anzahl"]>0){
			xmlloop($query["id"], ($intEbene+1));
		}
 
		echo $space.'</'.$query["bezeichnung"].'>'."\n";
 
	}
}
 
xmlloop();
?>