<!doctype html> <html> <head> <meta charset="utf-8"> <title>Current To-Do List</title> </head> <body> <?php function make_list($parent) { global $tasks; echo '<ol>'; foreach($parent as $task_id => $todo) { echo "<li>$todo"; if (isset($tasks[$task_id])) { // 如果当前id有子任务则递归创建菜单 make_list($tasks[$task_id]); } echo "</li>"; } echo '</ol>'; } $db = mysqli_connect('192.168.31.172' ,'root', 'root', 'phpadvanced'); mysqli_query($db, "set names utf8"); $q = 'SELECT task_id, parent_id, task FROM tasks WHERE date_completed="0000-00-00 00:00:00" ORDER BY parent_id, date_added ASC'; $r = mysqli_query($db, $q); $tasks = array(); while (list($task_id, $parent_id, $task) = mysqli_fetch_array($r, MYSQLI_NUM)) { $tasks[$parent_id][$task_id] = $task; } //echo '<pre class="brush:php;toolbar:false">'.print_r($tasks,1).''; make_list($tasks[0]); //把包含顶级任务的数组发送给它, 最顶级的parent_id是0 ?>