function listTodo()
{
if (isset($_SESSION['userid'])) {
$todoItems = getTodoItems($_SESSION['userid']);
if (count($todoItems) === 0) {
echo '<div class="card"><p>no items added yet</p></div>';
}
for ($i = 0; $i < count($todoItems); $i++) {
$row = $todoItems[$i];
echo '<div class="card">';
echo '<p>' . $row['description'] . '</p>';
echo '<input type="checkbox" onClick="setComplete(this, ' . $i . ')" ';
if ($row['completed']) {
echo 'checked ';
}
echo '/></div>';
}
$_SESSION['todolist'] = $todoItems;
} else {
echo '<div class="card"><p>log in to see your todo list</p></div>';
}
}
printf("PR%04d: ", $list[$i]["itemId"]);
echo "<a href=\"admin_todo_lists.php?id=" . $list[$i]["itemId"] . "\">" . $list[$i]["itemDesc"] . "</a> (" . $todo_item_status[$list[$i]["itemStatus"]] . ")<br>";
}
echo "<br>" . count($list) . " items in list.<br>";
echo $lookup_pr;
echo "<br>";
echo "<a href=\"admin_todo_lists.php?list=" . $listId . "\">» Back to TODO lists " . $todo_list[$listId] . " index</a><br>";
echo "<a href=\"admin_todo_lists.php\">» Back to TODO lists index</a><br>";
echo "<a href=\"admin.php\">» Back to Administration screen</a><br>";
} else {
/* Show the OPEN and ASSIGNED items in this category */
if (isset($_POST["desc"])) {
addTodoItem($db, $listId, $_SESSION["userId"], $_POST["desc"], $_POST["details"], $_POST["category"]);
}
echo "<b class=\"topic\">Administration screen - TODO list for '" . $todo_list[$listId] . "' category</b><br><br>";
$list = getTodoItems($db, $listId);
for ($i = 0; $i < count($list); $i++) {
printf("PR%04d: ", $list[$i]["itemId"]);
echo "<a href=\"admin_todo_lists.php?id=" . $list[$i]["itemId"] . "\">" . $list[$i]["itemDesc"] . "</a> (" . $todo_item_status[$list[$i]["itemStatus"]] . ")<br>";
}
$closeditems = getClosedTodoCategoryItems($db, $listId);
echo "<br>" . count($list) . " items (ignoring " . $closeditems . " closed items).<br>";
if ($closeditems) {
echo "<a href=\"" . $_SERVER["PHP_SELF"] . "?list=" . $listId . "&showclosed=1\">» List closed items for this category</a><br>";
}
echo "<form method=\"post\" action=\"" . $_SERVER["PHP_SELF"] . "?list=" . $listId . "\">";
echo "<b class=\"topic\">Add a item to the list</b><br><br>";
echo "Description: <input type=\"text\" name=\"desc\" size=45><br>";
echo "Details:<br>";
echo "<textarea name=\"details\" cols=60 rows=8></textarea><br>";
echo "Category: ";
<?php
include 'db_connection.php';
function getTodoItems($user_id)
{
$SQL = "SELECT * FROM todos WHERE user_id = " . $user_id . "";
$result = mysql_query($SQL);
echo "<form action='#' method = 'POST'>";
while ($data = mysql_fetch_assoc($result)) {
echo "<table>";
echo "<tr>";
echo "<td><input type='checkbox' name='check_list[]' value='" . $data["id"] . "'></td>";
echo "<td>" . $data["todo_item"] . "</td>";
echo "</tr>";
echo "</table>";
}
echo "</hr>";
echo "</form>";
}
function getCleared()
{
echo "Please, select a user with a todo list :)";
}
if ($_GET["choice"]) {
echo getTodoItems($_GET["choice"]);
} else {
echo getCleared();
}
<?php
include 'db_connection.php';
include 'db.php';
if (!$_COOKIE['islogged']) {
header("location:login.php");
}
echo "Welcome," . $_COOKIE['login'] . "<br/>";
echo "Below you may find your TODO list :)";
echo "<br/><br/>To Do list:<br/><br/>";
getTodoItems($_COOKIE['my_id']);
if (isset($_POST['submit_description'])) {
addTodoItem($_COOKIE['my_id'], $_POST['description']);
header("Refresh:0");
}
if (isset($_POST['check_list'])) {
foreach ($_POST['check_list'] as $selected) {
deleteTodoItem($_COOKIE['my_id'], $selected);
}
header("Refresh:0");
}
?>
<html>
<body>
<hr />
<form method="post">
<table>
<tr><td>Description:</td><td><input type="text" name="description" /></td></tr>
<input type="submit" name="submit_description" value="Add"/>
</td></tr>
</table>
