<!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).'
PHP怎么学习？PHP怎么入门？PHP在哪学？PHP怎么学才快？不用担心，这里为大家提供了PHP速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
广告![ThinkPHP5快速开发企业站点[全程实录]](https://img.php.cn/upload/course/000/000/068/6253d918a3ce7278.png)
收藏
收藏
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
330
