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) {