echo "Table todo_list created";
} else {
echo "Error creating table: " . $conn->error;
}
// retrieves todo list
$conn->get('/cakemail/todo_list', function () use($conn) {
$sql = "SELECT * FROM todo_list ORDER BY item_id";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo "item_id: " . $row["item_id"] . "<br>" . "description: " . $row["description"] . "<br>" . "date_added: " . $row["date+added"] . "<br>" . "date_due: " . $row["date_due"] . "<br>" . "status: " . $row["status"] . "<br><br>";
}
} else {
echo "0 results";
}
// $data = array();
// foreach ($items as $item) {
// $data[] = array(
// 'item_id' => $item->item_id,
// 'description' => $item->description,
// 'date_added' => $item->date_added,
// 'date_due' => $item->date_due,
// 'status' => $item->status
// );
// }
// echo json_encode($data);
});
// search by item id
$conn->get('/cakemail/todo_list/search/{item_id}', function ($item_id) use($conn) {
$sql = "SELECT * FROM todo_list WHERE item_id = {$item_id}";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
