时间:2021-07-01 10:21:17 帮助过:19人阅读
Current To-Do List '; foreach($parent as $task_id => $todo) { echo <<$todo EOT; 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"); if (($_SERVER['REQUEST_METHOD'] == 'POST') && isset($_POST['tasks']) && is_array($_POST['tasks']) && !empty($_POST['tasks'])) { $q = 'UPDATE tasks SET date_completed=NOW() WHERE task_id IN ('; foreach($_POST['tasks'] as $task_id => $v) { $q .= $task_id.', '; } $q = substr($q, 0, -2) . ')'; $r = mysqli_query($db, $q); if(mysqli_affected_rows($db) == count($_POST['tasks'])) { echo ' 选择的任务已经标记完成
'; } else { echo '选择的任务不能被标记为完成
'; } } $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).''; // 这是原文档, heredoc格式 echo <<点击检查框, 标记为完成. (任务本身已经所有的子任务都将不会出现在这个列表) EOT; ?>