function make_list($parent) {
global $tasks;
echo '
- ';
foreach($parent as $task_id => $todo) {
echo "
$todo";if (isset($tasks[$task_id])) { // 如果当前id有子任务则递归创建菜单
make_list($tasks[$task_id]);
}
echo "
";}
echo '
';}
$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 '
'.print_r($tasks,1).'';
make_list($tasks[0]); //把包含顶级任务的数组发送给它, 最顶级的parent_id是0
?>
// create the array.
// Array structs
// StudentId = > ["name" => "Name", "grade" => xx.x];
$students = [
256 => ['name' => 'Jon', 'grade' => '98.5'],
2 => ['name' => 'Vance', 'grade' => '85.1'],
9 => ['name' => 'Stephen', 'grade' => '94.0'],
364 => ['name' => 'Steve', 'grade' => '85.1'],
68 => ['name' => 'Rob', 'grade' => '74.6'],
];
function name_sort($x, $y) {
static $count = 1;
echo "
Iteration $count: {$x['name']} vs. {$y['name']}
\n";$count ++;
return strcasecmp($x['name'], $y['name']);
}
function grade_sort($x, $y) {
static $count = 1;
echo "
Iteration $count: {$x['grade']} vs. {$y['grade']}
\n";$count++;
return $x['grade'] < $y['grade'];
}
echo print_r($students, 1);
uasort($students, 'name_sort'); //保持键并使用自定义排序
echo print_r($students, 1);
uasort($students, 'grade_sort');
echo print_r($students, 1);
?>
// create the array.
// Array structs
// StudentId = > ["name" => "Name", "grade" => xx.x];
$students = [
256 => ['name' => 'Jon', 'grade' => '98.5'],
2 => ['name' => 'Vance', 'grade' => '85.1'],
9 => ['name' => 'Stephen', 'grade' => '94.0'],
364 => ['name' => 'Steve', 'grade' => '85.1'],
68 => ['name' => 'Rob', 'grade' => '74.6'],
];
echo print_r($students, 1);
uasort($students, function($x, $y){
return strcasecmp($x['name'], $y['name']);
}); //保持键并使用自定义排序
echo print_r($students, 1);
uasort($students, function($x, $y){
return $x['grade'] < $y['grade'];
});
echo print_r($students, 1);
?>
function increment(&$i) {
$i++;
}
$num = 2;
increment($num);
echo $num;
?>