fork(1) download
copy 
  1. <?php
  2.  
  3.     $conn = mysql_connect('localhost', 'root', '');
  4. 	@mysql_select_db('test', $conn);
  5.  
  6. 	function printMenu($array){
  7. 		foreach($array as $item){
  8. 			if(is_array($item) && isset($item['name'])){
  9. 				echo "<ul>\n";
  10. 					if(getChildren($item['id'], false)){
  11. 						echo "<li>".$item['name'];
  12. 						printMenu(getChildren($item['id'], true));
  13. 						echo "</li>\n";
  14. 					} else {
  15. 						echo "<li>".$item['name']."</li>\n";
  16. 					}
  17.  
  18. 				echo "</ul>\n\n";
  19. 			}
  20. 		}
  21. 	}
  22.  
  23. 	function getChildren($id, $return = false){
  24. 		global $conn;
  25. 		$query = mysql_query("SELECT * FROM `tbl_category` WHERE `parent_id` = ".(int)$id);
  26. 		$num = mysql_num_rows($query);
  27. 		if($num){
  28. 			if($return){
  29. 				while($row = mysql_fetch_assoc($query)){
  30. 					$rows[] = $row;
  31. 				}
  32. 				return $rows;
  33. 			}
  34. 			return true;
  35. 		}
  36. 		return false;
  37. 	}
  38.  
  39.  
  40. 	$query = mysql_query("SELECT `id`, `parent_id`, `name` FROM `tbl_category` WHERE `parent_id`=0") or die(mysql_error());
  41. 	while($row = mysql_fetch_assoc($query)){
  42. 		$rows[] = $row;
  43. 	}
  44. 	printMenu($rows);
Not running #stdin #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/u2GNV
language:
PHP (php 7.3.5)
created:
12 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!