function echoToDoList()
{
$tasks = selectTasks("*");
foreach ($tasks as $task) {
echoToDoListTask($task['task_id'], $task['completed'], $task['description'], $task['due_date']);
}
}
function updateTaskCompletion($task_id, $completed)
{
global $dbc;
$q = "UPDATE tasks SET completed=? WHERE task_id=?";
$stmt = mysqli_prepare($dbc, $q);
mysqli_stmt_bind_param($stmt, 'ii', $completed, $task_id);
mysqli_stmt_execute($stmt);
$rows = mysqli_affected_rows($dbc);
mysqli_stmt_close($stmt);
if ($rows != 1) {
return NULL;
}
return selectTasks('*', 'task_id=' . $task_id)[0];
}
<?php
header('Content-type: application/json');
include "../inc/data.php";
include "../inc/ui.php";
$params = json_decode(file_get_contents("php://input"));
$response = array();
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
$rows = selectTasks('*');
foreach ($rows as $row) {
$task = array();
$task['task_id'] = $row['task_id'];
$task['task_html'] = buildTaskHtml($row['task_id'], $row['completed'], $row['description'], $row['due_date']);
$response[] = $task;
}
} else {
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$new_row = insertTask($params->{'description'}, $params->{'due_date'});
$response['task_id'] = $new_row['task_id'];
$response['task_html'] = buildTaskHtml($new_row['task_id'], $new_row['completed'], $new_row['description'], $new_row['due_date']);
} else {
if ($_SERVER['REQUEST_METHOD'] === 'PUT') {
$row = updateTaskCompletion($params->{'task_id'}, $params->{'completed'});
$response['task_id'] = $row['task_id'];
$response['task_html'] = buildTaskHtml($row['task_id'], $row['completed'], $row['description'], $row['due_date']);
} else {
if ($_SERVER['REQUEST_METHOD'] === 'DELETE') {
deleteTask($params->{'task_id'});
$response['task_id'] = $params->{'task_id'};
$response['task_html'] = NULL;
}
