Your Ad Here

advanced code snippet search

Posted By

antpaw on 02/10/09


Tagged

php xml


Versions (?)

Who likes this?

4 people have marked this snippet as a favorite

nerdsane
Olli
dimispaceman
fomigo


recursion function for xml

 / Published in: PHP
 

your database needs id, bezeichner and parent fields

Expand | Embed | Plain Text 
  1. <?php
  2. error_reporting(E_ALL);
  3.  
  4. mysql_connect("localhost","root","root") or die (mysql_error());
  5. mysql_select_db("oop") or die (mysql_error());
  6.  
  7. function xmlloop($intParent=0, $intEbene=0){
  8. 	$space = null;
  9.  
  10. 	$sql = mysql_query("SELECT * FROM xmltest WHERE parent = ".$intParent);
  11.  
  12. 	while($query = mysql_fetch_assoc($sql)){		
  13.  
  14. 		for ($i=0;$i<$intEbene;$i++) $space .= '	';
  15.  
  16. 		echo $space.'<'.$query["bezeichnung"].' de="'.$query["val"].'">'."\n";
  17.  
  18. 		$child = mysql_fetch_assoc(mysql_query("SELECT COUNT(id) as anzahl FROM xmltest WHERE parent = ".$query["id"]." GROUP BY id"));
  19.  
  20. 		if($child["anzahl"]>0){
  21. 			xmlloop($query["id"], ($intEbene+1));
  22. 		}
  23.  
  24. 		echo $space.'</'.$query["bezeichnung"].'>'."\n";
  25.  
  26. 	}
  27. }
  28.  
  29. xmlloop();
  30. ?>

Report this snippet  

You need to login to post a comment.